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, October 1, 2007 (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 third highest percentage of low-educated adults among the Cambridge block groups? (The highest is 55.5%).

Third-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 by Thomas Grayson.
Updated 17 September 2002 by Joe Ferreira.
Updated 16 September 2003 by Jeeseong Chung.
Updated 25 September 2004 by Jinhua Zhao.
Updated 25 September 2005 by Xiongjiu Liao.
Updated 15 September 2006 by Mi Diao.
Last modified 09 September 2007 by Yang Chen.

Back to the 11.520 Home Page.
Back to the CRN Home Page.

Please send comments about this page to the 11.520 class staff <11.520staff@mit.edu>.