The US Census is looking to gather the results for the following scenarios. The function used in the Excel tool is known as a pivot table. In data analysis, a pivot table is a data summarization tool found in data visualization programs or business intelligence software. Among other functions, a pivot-table can automatically sort, count, total or give the average of the data stored in one table or spreadsheet. In addition, we will use other functions of excel, such as charts, filters & statistics, all calculated from the given dataset.
The dataset contains information collected from the Starlit Archive (http://lib. Stats. UCM. Du/datasets/Boston). The dataset contains 506 cases. The data was originally published by Harrison, D. & Rubberier, D. L ‘Hedonistic prices & the demand for clean air”, J. Environ. Economics & Management, Volvo, 81-10, 1978 There are 14 attributes in each case Of the dataset. They are: CRIB M per capita crime rate by town ZEN proportion of residential land zoned for lots over 25,000 sq. Ft. INDUS proportion of non-retail business acres per town. CHAOS KNOX AGE
Charles River dummy variable (1 if tract bounds river; O otherwise) nitric oxides concentration (parts per 10 million) proportion of owner-occupied units built prior to 1940 RMI average number of rooms per dwelling DISC RADAR TAX weighted distances to five Boston employment centers index of accessibility to radial highways full-value property-tax rate per $10,000 POTATO pupil-teacher ratio by town 1000(BC – 0. 63)AY where BC is the proportion of blacks by town L STATS % lower status of the population MED Median value of owner-occupied homes in $1000