Question

6. The City of Edmonton gathered data on the 10 neighbourhoods in its central core to 2/4 showcase the quality of living near major employers in the city. For eaclh characteristic, construct a frequency distribution that contains frequencies, column percentages, and cumulative percentages. There should be a separate table for each variable: Neighbourhood Median Income, Average House Price, and Walkability Table 1. Raw Data on Neighbourhood Characteristics for Central Core Edmonton Walkability 54 83 72 59 99 67 64 91 30 46 Neighbourhood Median Income House Price 88,900 72,000 94,000 62,000 82,000 51,000 74,000 112,000 495,000 345,000 295,000 300,000 270,000 452,000 405,000 372,000 318,000 400,000

Answer 1

Neighbourhood income
43000	Class interval		Frequency	Column Percentage	Cumulative percentage
51000	43000	56810	2	20.00%	20.00%
62000	56810	70620	1	10.00%	30.00%
72000	70620	84430	3	30.00%	60.00%
74000	84430	98240	3	30.00%	90.00%
82000	98240	112050	1	10.00%	100.00%
88900			10
94000
97000
112000
Average House Price	Class interval		Frequency	Column Percentage	Cumulative percentage
270000	270000	315010	3	30.00%	30.00%
295000	315010	360020	2	20.00%	50.00%
300000	360020	405030	0	0.00%	50.00%
318000	405030	450040	3	30.00%	80.00%
345000	450040	495050	2	20.00%	100.00%
372000			10
400000
405000
452000
495000
Walkability	Class interval		Frequency	Column Percentage	Cumulative percentage
30	30	44	1	10.00%	10.00%
46	44	58	2	20.00%	30.00%
54	58	72	3	30.00%	60.00%
59	72	86	2	20.00%	80.00%
64	86	100	3	30.00%	110.00%
67			10	100.00%
72
83
91
99