Hands On Group Excel Analysis
Hands-on Group Excel Project
April 16, 2014
Camesha Vera, Nadia Ferrari, Shuo Sun, Jiashun Hu, Siddhant Dutt, YuXin Xing
Alliant University
IST 6010
Professor Kumar
The US Census Service is need of analysis for some recently released data, pertaining to housing in the Boston Massachusetts area. The reports generated from this analysis will be completed using an Excel spreadsheet. Excel features calculations, graphing tools, pivot tables, “what if “ scenarios, along with other data analysis functions. It has been a very widely applied spreadsheet for these platforms, and is considered the industry standard for spreadsheets.
The US Census is looking to gather the results for the following scenarios. The function used in …show more content…
Find neighborhoods where these levels of concentrations are dangerous. Also human rights group are interested in the correlation between median values of homes and the levels of nitric oxide concentrations
Count of MEDV
Column Labels
Row Labels
0
1
Grand Total
0.35-0.4
7
7
0.4-0.45
117
5
122
0.45-0.5
56
7
63
0.5-0.55
96
5
101
0.55-0.6
45
3
48
0.6-0.65
51
5
56
0.65-0.7
36
1
37
0.7-0.75
47
1
48
0.75-0.8
4
4
8
0.85-0.9
12
4
16
Grand Total
471
35
506
Solution:
Column labels
CHAS
Row Labels
NOX
Values
COUNT OF CHAS
Solution: In this instance 7 tract bound the river and 56
April 16, 2014
Camesha Vera, Nadia Ferrari, Shuo Sun, Jiashun Hu, Siddhant Dutt, YuXin Xing
Alliant University
IST 6010
Professor Kumar
The US Census Service is need of analysis for some recently released data, pertaining to housing in the Boston Massachusetts area. The reports generated from this analysis will be completed using an Excel spreadsheet. Excel features calculations, graphing tools, pivot tables, “what if “ scenarios, along with other data analysis functions. It has been a very widely applied spreadsheet for these platforms, and is considered the industry standard for spreadsheets.
The US Census is looking to gather the results for the following scenarios. The function used in …show more content…
Find neighborhoods where these levels of concentrations are dangerous. Also human rights group are interested in the correlation between median values of homes and the levels of nitric oxide concentrations
Count of MEDV
Column Labels
Row Labels
0
1
Grand Total
0.35-0.4
7
7
0.4-0.45
117
5
122
0.45-0.5
56
7
63
0.5-0.55
96
5
101
0.55-0.6
45
3
48
0.6-0.65
51
5
56
0.65-0.7
36
1
37
0.7-0.75
47
1
48
0.75-0.8
4
4
8
0.85-0.9
12
4
16
Grand Total
471
35
506
Solution:
Column labels
CHAS
Row Labels
NOX
Values
COUNT OF CHAS
Solution: In this instance 7 tract bound the river and 56