______________ 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 in Lab 4 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:
View Full Document
Unlocking...