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...