| 11.188: Urban Planning and Social Science Laboratory |
Your Athena Username: _____________________________
Note that, when answering questions for this lab, you should exclude the three Cambridge block groups with zero households and work with the remaining 91.
1. What are the block group count, and the mean and standard deviation of Med_hh_inc fpr those Cambridge block groups with median household income of less than $40,000?
Count: ______________; Mean: ______________; Standard Deviation: _____________
2. What are the mean and standard deviation of those Cambridge block groups with median household income less than $40,000 and a median income greater than zero?
Mean: ______________; Standard Deviation: _____________
3. What is the fourth highest percentage of low-educated adults among the Cambridge block groups? (The highest is 55.5%).
Fourth-highest p_lowed in Cambridge block groups =: ______________ for block group ______________
4. How many block groups have a p_lowed > 40%? _______________
5. What are the mean and standard deviation of the p_lowed field for the 21 Cambridge block groups containing the low-priced housing sales (<$150K)? What about for the 70 block groups containing the other sales?
21-group Mean: ______________; 21-group Standard Deviation: _____________
70-group Mean: ______________; 70-group Standard Deviation: _____________
6. What are the sales count, and the mean and standard deviation of the RealPrice field for those Cambridge sales that fell within the 750 meter buffer of Mass Ave?
Sales Count: ____________; Mean RealPrice: ______________; Standard Deviation: _____________
7. Save the PDF of your map from Part IV and submit it as a separate document or include it within the document containing your answers to the above questions.
Updated Sept. 2001-17 by Thomas Grayson, Joe
Ferreira, Jeeseong Chung, Jinhua Zhao, Xiongjiu Liao, Mi Diao, Yang
Chen, Eric Schultheis, and Hongmou Zhang.
Last Modified 0 Feb. 2020 by [rqadri,jf].
Back to the 11.188 Home Page.
Back to the CRON Home
Page.