Massachusetts Institute of Technology
Department of Urban Studies and Planning


11.520: A Workshop on Geographic Information Systems
11.188: Urban Planning and Social Science Laboratory

Lab Assignment 3: Database Operations in ArcMap
Due Monday,Oct 5, 2009 (in lab)

Your Name: ______________________________________

Your Athena Username: _____________________________
 

1. What are the mean and standard deviation of the 85 Cambridge block groups with median household income of $50,000 or less?

Mean: ______________;    Standard Deviation: _____________

2. What are the mean and standard deviation of the 82 Cambridge block groups with median household income of $50,000 or less and a median income greater than zero?

Mean: ______________;    Standard Deviation: _____________

3. What is the second highest percentage of low-educated adults among the Cambridge block groups? (The highest is 55.5%).

Second-highest p_lowed in Cambridge block groups =: ______________ for block group ______________

4. How many block groups have a p_lowed >  50%? _______________

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? 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 mean and standard deviation of the RealPrice field for the 140 Cambridge sales that fell within the 1/2 mile buffer of Mass Ave?

Mean RealPrice: ______________;    Standard Deviation: _____________
 


Updated 24 Sept. 2001-08 by Thomas Grayson, Joe Ferreira, Jeeseong Chung, Jinhua Zhao, Xiongjiu Liao, Mi Diao, Yang Chen.
Last Modified 27 September 2009 by Joe Ferreira.

Back to the 11.520 Home Page.
Back to the CRON Home Page.