data analysis

profilerose111
GetClarity.xlsx
Home>Business & Finance homework help>Accounting homework help>data analysis

Ex 1 & 2 Demo Data

Exhibit 1 Exhibit 2
Area Demographic Data National Demographics
Statistic Value Statistic Value
Population 26,380 Population 34,362,970
% Work at Home 5.30% % Work at Home 7.30%
Pop % 0-19 24.60% Pop % 0-19 24.10%
Pop % 20-29 13.30% Pop % 20-29 12.60%
Pop % 30-39 17.80% Pop % 30-39 13.30%
Pop % 40-49 14.10% Pop % 40-49 16.70%
Pop % 50-59 9.80% Pop % 50-59 14.40%
Pop % 60-69 7.70% Pop % 60-69 9.10%
Pop % 70-79 7.40% Pop % 70-79 6.10%
Pop % 80 + 5.50% Pop % 80 + 3.60%
Never legally married 33.60% Never legally married 35.00%
Legally married 47.40% Legally married 48.00%
Separated 2.70% Separated 3.00%
Divorced 8.10% Divorced 8.00%
Widowed 8.20% Widowed 6.10%
Not Common-law 94.70% Not Common-law 88.90%
Common-law 5.30% Common-law 11.10%
2 persons family 42.30% 2 persons family 49.00%
3 persons family 24.20% 3 persons family 21.70%
4 persons family 20.60% 4 persons family 20.20%
5+ persons family 13.00% 5+ persons family 8.60%
New to FSA per year 18.90% New to FSA per year 13.80%
No degree 15.00% No degree 15.80%
Any degree 85.00% Any degree 83.90%
High school certificate 20.00% High school certificate 23.50%
Trades degree 9.10% Trades degree 12.90%
College degree 15.10% College degree 20.40%
Any university degree 40.70% Any university degree 27.10%
University degree below BA 7.50% University degree below BA 4.80%
University cert. or degree 33.20% University cert. or degree 22.30%
Bachelor's degree 20.10% Bachelor's degree 14.10%
University degree above BA 3.70% University degree above BA 2.30%
Medical degree 0.70% Medical degree 0.70%
Master's degree 7.50% Master's degree 4.30%
Doctorate degree 1.20% Doctorate degree 0.80%
AVG Vehicle Age 5 AVG Vehicle Age 4
AVG Vehicle Estimated Value 10,937 AVG Vehicle Estimated Value 8,136
AVG House Age 36 AVG House Age 33
AVG Building Value 400,559 AVG Building Value 323,935
Percentage Value Of Provincial AVG 150.50% Percentage Value Of Provincial AVG 102.90%
Older Smoker 25.00% Older Smoker 23.50%
Mid Age Smoker 53.10% Mid Age Smoker 55.10%
Young Smoker 21.90% Young Smoker 22.10%

Question 1

Regional Average Age National Average Age
Pop % 0-19 24.60% 10 Pop % 0-19 24.10% 10
Pop % 20-29 13.30% 25 Pop % 20-29 12.60% 25
Pop % 30-39 17.80% 35 Pop % 30-39 13.30% 35
Pop % 40-49 14.10% 45 Pop % 40-49 16.70% 45
Pop % 50-59 9.80% 55 Pop % 50-59 14.40% 55
Pop % 60-69 7.70% 65 Pop % 60-69 9.10% 65
Pop % 70-79 7.40% 75 Pop % 70-79 6.10% 75
Pop % 80 + 5.50% 85 Pop % 80 + 3.60% 85
39 39.2392392392

Question 2

Sample Data S Percentages Population Data P Percentages t-Test: Two-Sample Assuming Equal Variances
Pop % 0-19 0.246 Pop % 0-19 0.241
Pop % 20-29 0.133 Pop % 20-29 0.126 S Percentages P Percentages
Pop % 30-39 0.178 Pop % 30-39 0.133 Mean 0.18364 0.17292
Pop % 40-49 0.141 Pop % 40-49 0.167 Variance 0.0313629067 0.03048491
Pop % 50-59 0.098 Pop % 50-59 0.144 Observations 25 25
Pop % 60-69 0.077 Pop % 60-69 0.091 Pooled Variance 0.0309239083
Pop % 70-79 0.074 Pop % 70-79 0.061 Hypothesized Mean Difference 0
Pop % 80 + 0.055 Pop % 80 + 0.036 df 48
2 persons family 0.423 2 persons family 0.49 t Stat 0.2155274563
3 persons family 0.242 3 persons family 0.217 P(T<=t) one-tail 0.4151346627
4 persons family 0.206 4 persons family 0.202 t Critical one-tail 1.6772241961
5+ persons family 0.13 5+ persons family 0.086 P(T<=t) two-tail 0.8302693255 There is no significant difference between the two means
No degree 0.15 No degree 0.158 t Critical two-tail 2.0106347576
Any degree 0.85 Any degree 0.839
High school certificate 0.2 High school certificate 0.235
Trades degree 0.091 Trades degree 0.129
College degree 0.151 College degree 0.204
Any university degree 0.407 Any university degree 0.271
University degree below BA 0.075 University degree below BA 0.048
University cert. or degree 0.332 University cert. or degree 0.223
Bachelor's degree 0.201 Bachelor's degree 0.141
University degree above BA 0.037 University degree above BA 0.023
Medical degree 0.007 Medical degree 0.007
Master's degree 0.075 Master's degree 0.043
Doctorate degree 0.012 Doctorate degree 0.008
we used population age, because we were told that the higher the population age is, the more successful the dealership is likely to be. For family size, we considered that the more people in a family, the more cars the need to have and that it helps determine what size cars the dealership needs to stock. We used the education demographics because they are usually a good indicator of family income

Area Avg. Age 2

Groups
1 1 11 24.60%
2 5 25 13.30%
3 1 31 17.80%
4 2 42 14.10%
5 2 52 9.80%
6 7 67 7.70%
7 8 78 7.40%
8 1 81 5.30%

Area Random Numbers

70 Avg. 42.19
19
30
30
32
19
56
56
32
70
32
30
56
19
19
32
19
30
32
19
19
41
32
56
41
32
41
19
56
41
19
41
32
32
56
70
89
30
56
32
30
32
32
32
89
70
19
19
41
19
30
41
32
19
19
19
19
89
41
30
30
70
19
70
19
32
19
32
56
32
56
56
56
19
30
89
41
80
32
80
32
70
32
89
70
70
19
30
89
19
32
19
56
19
19
41
30
30
32
32
89
32
56
19
19
41
32
89
80
56
30
19
80
80
70
80
56
30
32
32
89
70
70
32
32
32
19
30
32
32
32
32
89
32
70
19
19
30
19
19
30
19
30
56
32
19
30
19
19
56
56
30
70
41
32
41
89
32
80
70
32
19
19
32
30
41
70
80
30
19
19
32
41
32
56
41
41
41
32
70
19
32
56
32
80
41
80
19
19
30
80
70
19
56
19
41
30
19
70
41
80
56
56
70
32
41
19
32
19
19
19
19
56
19
41
32
30
19
41
70
32
32
41
56
19
32
56
30
19
89
19
80
70
19
89
80
41
19
32
32
70
30
56
19
32
19
30
32
32
19
19
41
32
32
32
70
32
19
56
41
32
41
70
41
30
41
32
30
41
41
89
80
41
30
56
19
70
41
56
32
70
32
41
19
70
70
70
30
41
56
32
30
30
89
19
70
56
32
19
19
30
19
41
56
89
19
32
41
32
30
32
30
32
19
32
56
19
70
89
70
56
30
30
56
19
41
41
70
70
30
41
32
32
19
32
41
80
56
30
19
19
70
30
30
56
32
32
32
89
30
70
19
19
41
30
56
30
32
32
41
89
19
32
19
30
32
19
19
19
19
19
32
56
32
41
80
19
80
56
41
70
32
41
32
70
19
41
89
30
32
30
70
30
19
89
56
41
19
32
32
19
32
32
32
41
30
19
30
32
19
30
32
32
30
19
19
41
32
32
56
80
30
19
89
41
41
56
32
32
80
19
41
80
41
80
41
19
30
89
19
32
32
19
80
80
19
32
19
56
89
32
32
89
56
70
30
19
19
89
70
70
70
41
41
19
89
32
30
32
56
41
32
30
30
32
19
30
89
19
19
32
56
41
89
32
19
41
80
30
41
70
32
56
32
32
19
30
32
70
56
30
80
19
30
80
32
32
19
70
19
80
32
19
89
56
19
32
89
30
41
41
70
32
30
41
30
19
30
30
32
80
56
32
56
41
19
56
19
32
41
89
41
19
56
32
70
30
32
41
41
41
19
41
19
56
41
19
56
32
32
80
89
19
19
56
70
19
89
19
19
70
56
30
89
56
80
30
41
19
30
19
70
32
41
19
41
56
80
56
32
19
56
32
32
19
19
32
19
41
32
80
19
19
32
32
19
41
70
32
32
19
41
80
70
19
32
80
30
30
89
30
70
70
41
56
19
19
19
41
19
41
30
41
70
30
19
41
70
32
19
80
70
32
41
32
32
32
41
32
32
80
19
56
32
80
70
41
19
41
32
41
19
19
80
32
56
80
56
32
19
19
19
80
80
56
41
19
19
32
56
41
30
30
30
30
19
80
41
30
80
70
32
19
56
41
30
19
56
70
19
32
41
19
30
19
19
32
32
41
56
89
32
30
89
19
32
30
32
89
19
70
89
56
89
56
89
70
30
30
32
19
41
80
32
70
32
32
56
41
19
32
41
70
19
41
70
41
41
89
89
32
19
56
41
41
30
30
32
70
70
19
41
32
70
30
30
56
32
30
30
19
41
19
80
32
32
32
19
30
70
19
32
30
30
30
19
19
70
80
56
30
19
30
30
80
41
30
32
30
56
19
30
19
80
80
80
32
70
56
30
32
41
30
56
70
19
41
30
32
19
56
19
30
70
32
19
19
19
41
56
32
41
19
19
30
41
70
56
30
41
41
32
89
56
41
32
41
70
89
32
19
30
89
30
19
41
32
19
32
41
41
30
70
30
19
30
30
56
56
70
32
30
19
32
19
30
19
32
56
32
70
19
41
41
19
80
41
32
32
19
70
89
19
19
70
56
89
32
56
80
41
32
19
19
56
19
80
56
56
41
56
56
89
41
89
32
19
30
89
70
32
19
30
19
30
30
80
32
41
89
19
41
70
89
30
89
56
32
19
32
19
89
32
19
19
89
32
70
30
30
80
30
89
19
32
30
89
89
41
19
19
41
19
19
32
56
30
56
19
56
32
32
80
19
19
30
19
41
30
56
70
32
30
89
32
80
32
19
41
32
70
41
56
19
56
19
32
30
89
89

National Avg. Age 2

1 10 20 24.10%
2 10 30 12.60%
3 9 39 13.30%
4 8 48 16.70%
5 5 55 14.40%
6 4 64 9.10%
7 3 73 6.10%
8 10 90 3.70%

National Random Numbers

15 Avg. 39.16
54
54
77
15
15
15
15
15
54
15
15
54
33
46
64
54
15
15
15
15
46
15
54
46
77
64
54
46
15
25
64
77
15
64
54
77
64
64
25
25
54
25
64
15
64
25
15
77
46
25
33
25
54
64
25
33
15
25
64
15
25
33
46
15
15
54
15
46
46
15
64
87
77
33
15
77
77
15
25
25
54
54
46
54
54
33
15
64
46
15
77
15
54
33
25
64
46
15
15
15
15
33
33
15
46
54
25
25
54
25
54
54
33
54
15
33
46
33
15
15
33
25
64
15
33
64
25
15
64
64
33
15
25
64
64
54
33
64
15
15
77
15
77
33
15
54
64
77
46
46
87
77
54
64
25
15
87
15
15
54
15
77
33
64
46
25
77
46
25
33
54
15
15
54
15
15
15
46
33
64
33
46
77
15
77
25
77
64
54
15
15
64
15
33
64
64
15
15
46
25
15
15
64
15
46
54
15
54
54
46
64
46
15
64
25
15
77
46
46
33
15
25
77
87
54
54
64
54
64
54
33
46
33
25
64
54
33
77
15
54
46
15
46
33
46
15
33
87
54
77
15
77
15
15
87
64
33
33
25
15
77
46
46
54
15
54
46
46
46
64
54
15
33
54
64
54
33
25
64
46
54
33
15
46
15
15
64
15
46
15
46
33
54
15
15
46
54
15
25
77
64
54
54
15
46
15
15
46
33
33
15
54
46
33
87
46
15
15
15
15
15
25
46
15
54
54
54
15
15
33
77
25
33
46
46
15
33
25
33
15
46
46
33
25
15
46
15
15
33
33
46
33
15
25
46
33
87
77
46
46
15
46
77
46
54
54
54
64
64
77
54
33
15
15
33
15
33
25
46
46
15
54
46
15
64
15
46
46
46
15
54
25
25
15
15
46
54
33
15
15
46
54
15
15
64
33
54
33
15
54
25
46
64
46
15
46
15
54
15
46
15
33
15
15
25
25
15
46
25
46
46
25
15
33
25
25
33
25
87
15
77
64
46
33
46
15
46
54
54
87
15
33
25
46
77
25
46
15
77
25
77
54
33
33
15
15
46
25
15
33
46
25
64
54
87
15
54
33
15
54
15
15
15
15
15
77
25
33
77
46
15
15
77
15
54
33
33
15
46
15
25
87
33
33
15
46
77
54
54
46
15
33
46
15
25
33
77
46
25
25
15
15
33
15
46
15
15
15
77
25
64
87
46
54
87
54
46
15
15
25
15
15
33
46
77
64
15
64
33
87
25
54
46
46
64
46
54
54
46
33
33
46
15
46
15
15
15
15
87
54
15
54
25
33
15
15
33
15
54
33
33
54
33
15
64
25
33
54
15
64
54
77
25
15
15
64
15
46
33
15
25
25
64
64
46
33
15
33
15
25
77
25
15
46
64
15
33
33
54
33
15
25
54
15
77
15
15
33
25
54
54
15
25
64
46
33
15
64
15
15
15
54
54
15
54
46
77
64
54
64
15
46
15
33
25
54
15
25
15
15
15
15
64
15
25
25
25
64
46
54
87
54
54
54
64
15
33
46
15
77
64
54
15
15
25
46
33
77
64
54
77
15
25
54
46
15
54
15
46
64
33
25
64
46
46
25
46
64
64
64
33
33
46
33
87
54
15
15
25
15
46
54
15
33
46
54
77
46
46
46
33
54
54
64
54
64
77
15
54
77
46
77
46
33
64
33
54
77
46
64
46
46
54
54
46
87
15
15
46
15
33
15
25
87
54
77
46
54
46
15
46
64
64
15
54
77
54
33
33
25
64
54
46
15
33
15
15
15
46
33
54
15
15
64
25
46
87
15
25
33
54
25
15
25
54
25
46
77
64
15
15
33
15
25
25
25
54
54
46
15
33
15
15
15
15
25
15
77
25
15
25
54
46
25
46
33
25
15
25
15
77
33
15
33
33
15
54
46
15
46
54
15
15
54
46
15
25
46
15
77
54
15
46
54
54
25
54
54
15
54
54
46
15
46
33
64
33
15
15
87
33
33
64
46
33
25
46
46
46
77
33
46
54
15
15
87
87
15
33
15
54
15
15
46
33
77
25
46
54
15
54
15
33
46
46
15
33
46
64
33
15
46
54
54
54
33
33
25
46
15
15
87
15
64
15
54
54
54
64
54
46
46
54
87
54
25
15
77
46
15
46
54
64
25
46
25
15
46
33
25
15
46
54
15
46
15
46
46
54
46
46
33
87
15
15
54
54
25
15
15
25
46
64
33
46
33
33
46
46
54
46
33
87
46
15
33
54
54
54

Question 4

After running the data, we got an average age for the Area of 42.19, and an average national age of 39.16. These numbers are not far off of the numbers we got in question 1, meaning that the methods used in question 1 are fairly accurate. The increase in the average age for the Area leads us to conclude that this is a good area for the automaker to conduct business in as the area age is higher than the national average.

Z-Test Raw Data

Area National
70 15 467.8038348348
19 54 429.036975
30 54
30 77
32 15
19 15
56 15
56 15
32 15
70 54
32 15
30 15
56 54
19 33
19 46
32 64
19 54
30 15
32 15
19 15
19 15
41 46
32 15
56 54
41 46
32 77
41 64
19 54
56 46
41 15
19 25
41 64
32 77
32 15
56 64
70 54
89 77
30 64
56 64
32 25
30 25
32 54
32 25
32 64
89 15
70 64
19 25
19 15
41 77
19 46
30 25
41 33
32 25
19 54
19 64
19 25
19 33
89 15
41 25
30 64
30 15
70 25
19 33
70 46
19 15
32 15
19 54
32 15
56 46
32 46
56 15
56 64
56 87
19 77
30 33
89 15
41 77
80 77
32 15
80 25
32 25
70 54
32 54
89 46
70 54
70 54
19 33
30 15
89 64
19 46
32 15
19 77
56 15
19 54
19 33
41 25
30 64
30 46
32 15
32 15
89 15
32 15
56 33
19 33
19 15
41 46
32 54
89 25
80 25
56 54
30 25
19 54
80 54
80 33
70 54
80 15
56 33
30 46
32 33
32 15
89 15
70 33
70 25
32 64
32 15
32 33
19 64
30 25
32 15
32 64
32 64
32 33
89 15
32 25
70 64
19 64
19 54
30 33
19 64
19 15
30 15
19 77
30 15
56 77
32 33
19 15
30 54
19 64
19 77
56 46
56 46
30 87
70 77
41 54
32 64
41 25
89 15
32 87
80 15
70 15
32 54
19 15
19 77
32 33
30 64
41 46
70 25
80 77
30 46
19 25
19 33
32 54
41 15
32 15
56 54
41 15
41 15
41 15
32 46
70 33
19 64
32 33
56 46
32 77
80 15
41 77
80 25
19 77
19 64
30 54
80 15
70 15
19 64
56 15
19 33
41 64
30 64
19 15
70 15
41 46
80 25
56 15
56 15
70 64
32 15
41 46
19 54
32 15
19 54
19 54
19 46
19 64
56 46
19 15
41 64
32 25
30 15
19 77
41 46
70 46
32 33
32 15
41 25
56 77
19 87
32 54
56 54
30 64
19 54
89 64
19 54
80 33
70 46
19 33
89 25
80 64
41 54
19 33
32 77
32 15
70 54
30 46
56 15
19 46
32 33
19 46
30 15
32 33
32 87
19 54
19 77
41 15
32 77
32 15
32 15
70 87
32 64
19 33
56 33
41 25
32 15
41 77
70 46
41 46
30 54
41 15
32 54
30 46
41 46
41 46
89 64
80 54
41 15
30 33
56 54
19 64
70 54
41 33
56 25
32 64
70 46
32 54
41 33
19 15
70 46
70 15
70 15
30 64
41 15
56 46
32 15
30 46
30 33
89 54
19 15
70 15
56 46
32 54
19 15
19 25
30 77
19 64
41 54
56 54
89 15
19 46
32 15
41 15
32 46
30 33
32 33
30 15
32 54
19 46
32 33
56 87
19 46
70 15
89 15
70 15
56 15
30 15
30 25
56 46
19 15
41 54
41 54
70 54
70 15
30 15
41 33
32 77
32 25
19 33
32 46
41 46
80 15
56 33
30 25
19 33
19 15
70 46
30 46
30 33
56 25
32 15
32 46
32 15
89 15
30 33
70 33
19 46
19 33
41 15
30 25
56 46
30 33
32 87
32 77
41 46
89 46
19 15
32 46
19 77
30 46
32 54
19 54
19 54
19 64
19 64
19 77
32 54
56 33
32 15
41 15
80 33
19 15
80 33
56 25
41 46
70 46
32 15
41 54
32 46
70 15
19 64
41 15
89 46
30 46
32 46
30 15
70 54
30 25
19 25
89 15
56 15
41 46
19 54
32 33
32 15
19 15
32 46
32 54
32 15
41 15
30 64
19 33
30 54
32 33
19 15
30 54
32 25
32 46
30 64
19 46
19 15
41 46
32 15
32 54
56 15
80 46
30 15
19 33
89 15
41 15
41 25
56 25
32 15
32 46
80 25
19 46
41 46
80 25
41 15
80 33
41 25
19 25
30 33
89 25
19 87
32 15
32 77
19 64
80 46
80 33
19 46
32 15
19 46
56 54
89 54
32 87
32 15
89 33
56 25
70 46
30 77
19 25
19 46
89 15
70 77
70 25
70 77
41 54
41 33
19 33
89 15
32 15
30 46
32 25
56 15
41 33
32 46
30 25
30 64
32 54
19 87
30 15
89 54
19 33
19 15
32 54
56 15
41 15
89 15
32 15
19 15
41 77
80 25
30 33
41 77
70 46
32 15
56 15
32 77
32 15
19 54
30 33
32 33
70 15
56 46
30 15
80 25
19 87
30 33
80 33
32 15
32 46
19 77
70 54
19 54
80 46
32 15
19 33
89 46
56 15
19 25
32 33
89 77
30 46
41 25
41 25
70 15
32 15
30 33
41 15
30 46
19 15
30 15
30 15
32 77
80 25
56 64
32 87
56 46
41 54
19 87
56 54
19 46
32 15
41 15
89 25
41 15
19 15
56 33
32 46
70 77
30 64
32 15
41 64
41 33
41 87
19 25
41 54
19 46
56 46
41 64
19 46
56 54
32 54
32 46
80 33
89 33
19 46
19 15
56 46
70 15
19 15
89 15
19 15
19 87
70 54
56 15
30 54
89 25
56 33
80 15
30 15
41 33
19 15
30 54
19 33
70 33
32 54
41 33
19 15
41 64
56 25
80 33
56 54
32 15
19 64
56 54
32 77
32 25
19 15
19 15
32 64
19 15
41 46
32 33
80 15
19 25
19 25
32 64
32 64
19 46
41 33
70 15
32 33
32 15
19 25
41 77
80 25
70 15
19 46
32 64
80 15
30 33
30 33
89 54
30 33
70 15
70 25
41 54
56 15
19 77
19 15
19 15
41 33
19 25
41 54
30 54
41 15
70 25
30 64
19 46
41 33
70 15
32 64
19 15
80 15
70 15
32 54
41 54
32 15
32 54
32 46
41 77
32 64
32 54
80 64
19 15
56 46
32 15
80 33
70 25
41 54
19 15
41 25
32 15
41 15
19 15
19 15
80 64
32 15
56 25
80 25
56 25
32 64
19 46
19 54
19 87
80 54
80 54
56 54
41 64
19 15
19 33
32 46
56 15
41 77
30 64
30 54
30 15
30 15
19 25
80 46
41 33
30 77
80 64
70 54
32 77
19 15
56 25
41 54
30 46
19 15
56 54
70 15
19 46
32 64
41 33
19 25
30 64
19 46
19 46
32 25
32 46
41 64
56 64
89 64
32 33
30 33
89 46
19 33
32 87
30 54
32 15
89 15
19 25
70 15
89 46
56 54
89 15
56 33
89 46
70 54
30 77
30 46
32 46
19 46
41 33
80 54
32 54
70 64
32 54
32 64
56 77
41 15
19 54
32 77
41 46
70 77
19 46
41 33
70 64
41 33
41 54
89 77
89 46
32 64
19 46
56 46
41 54
41 54
30 46
30 87
32 15
70 15
70 46
19 15
41 33
32 15
70 25
30 87
30 54
56 77
32 46
30 54
30 46
19 15
41 46
19 64
80 64
32 15
32 54
32 77
19 54
30 33
70 33
19 25
32 64
30 54
30 46
30 15
19 33
19 15
70 15
80 15
56 46
30 33
19 54
30 15
30 15
80 64
41 25
30 46
32 87
30 15
56 25
19 33
30 54
19 25
80 15
80 25
80 54
32 25
70 46
56 77
30 64
32 15
41 15
30 33
56 15
70 25
19 25
41 25
30 54
32 54
19 46
56 15
19 33
30 15
70 15
32 15
19 15
19 25
19 15
41 77
56 25
32 15
41 25
19 54
19 46
30 25
41 46
70 33
56 25
30 15
41 25
41 15
32 77
89 33
56 15
41 33
32 33
41 15
70 54
89 46
32 15
19 46
30 54
89 15
30 15
19 54
41 46
32 15
19 25
32 46
41 15
41 77
30 54
70 15
30 46
19 54
30 54
30 25
56 54
56 54
70 15
32 54
30 54
19 46
32 15
19 46
30 33
19 64
32 33
56 15
32 15
70 87
19 33
41 33
41 64
19 46
80 33
41 25
32 46
32 46
19 46
70 77
89 33
19 46
19 54
70 15
56 15
89 87
32 87
56 15
80 33
41 15
32 54
19 15
19 15
56 46
19 33
80 77
56 25
56 46
41 54
56 15
56 54
89 15
41 33
89 46
32 46
19 15
30 33
89 46
70 64
32 33
19 15
30 46
19 54
30 54
30 54
80 33
32 33
41 25
89 46
19 15
41 15
70 87
89 15
30 64
89 15
56 54
32 54
19 54
32 64
19 54
89 46
32 46
19 54
19 87
89 54
32 25
70 15
30 77
30 46
80 15
30 46
89 54
19 64
32 25
30 46
89 25
89 15
41 46
19 33
19 25
41 15
19 46
19 54
32 15
56 46
30 15
56 46
19 46
56 54
32 46
32 46
80 33
19 87
19 15
30 15
19 54
41 54
30 25
56 15
70 15
32 25
30 46
89 64
32 33
80 46
32 33
19 33
41 46
32 46
70 54
41 46
56 33
19 87
56 46
19 15
32 33
30 54
89 54
89 54

Question 5

z-Test: Two Sample for Means
Area National
Mean 42.187 39.605
Known Variance 468 429
Observations 1000 1000
Hypothesized Mean Difference 0
z 2.7262144563
P(Z<=z) one-tail 0.0032032679
z Critical one-tail 1.644853627
P(Z<=z) two-tail 0.0064065358 The two data sets are significantly different, and the average age in the section is higher than in the population
z Critical two-tail 1.9599639845