statistic

profilesuzies_119
IndividualProjectData.xlsx
Home>Mathematics homework help>Statistics homework help>statistic

Data

ZIP Code Population Season Pass Holders
45220 14171 224
45219 17576 42
45225 13437 15
45217 5731 78
45214 9952 19
45232 6913 28
45223 13349 83
45229 15713 75
45206 11353 69
45202 15105 83
45203 3411 9
45207 8233 8
41074 5566 36
41073 6193 63
45224 21043 207
41071 21596 133
45205 21683 102
45204 6642 36
41016 5603 42
45216 9028 55
45212 22356 207
41011 25849 193
41014 7913 41
45237 21137 86
45208 18236 424
45211 33968 342
45239 26485 269
41075 15868 236
45209 8941 111
45226 5029 84
45238 42737 564
45231 39939 361
45213 11683 153
45215 28915 308
45218 3917 54
41017 40218 493
41076 14779 176
45251 22887 205
45227 18431 215
45247 20372 357
41015 22298 189
45248 22880 380
45236 21823 310
45240 27033 142
45246 13522 100
45230 25763 423
45233 14175 244
45252 4799 58
41018 29001 244
45243 14755 303
45241 25623 299
45014 44178 307
45242 20015 377
45244 26316 448
41059 2266 22
41048 12597 214
41051 18730 323
45255 22552 307
45174 2072 52
41042 50429 440
45002 13298 184
45015 12504 47
45069 46264 561
45052 3770 52
45249 13432 154
41001 16982 164
41005 20892 209
45011 62303 496
45245 17701 189
41091 17372 226
45013 51730 286
45150 31179 316
41094 9748 106
45030 16386 192
45140 52874 657
41063 3662 19
45040 51183 549
45102 22009 217
45039 21398 278
41007 3215 26
45053 3441 25
45157 10312 72
45050 6988 80
41080 2114 11
45067 12507 62
45034 1227 11
45103 29874 267
47025 21986 154
45044 49621 322
41030 7280 35
41092 3198 18
45065 5194 35
41033 1712 11
47060 6910 38
41006 4835 19
45122 12550 59
45042 28821 91
45056 28811 88
45036 36066 225
45064 2376 9
47040 5242 10
45153 2132 10
45152 9686 101
47022 2740 17
47001 10370 36
45162 2900 11
45005 31944 93
41035 9671 54
45106 12675 61
45176 8485 47
45311 7381 10
41043 2968 7
45327 7961 13
41040 7249 14
45066 23119 129
41097 6854 22
45054 1730 12
41095 4218 11
45120 3774 20
45342 31929 55
47032 3628 10
45107 9608 40
47012 10579 23
45130 4202 17
45118 4239 23
41086 1602 5
47018 4435 12
45458 26281 75
45449 19237 15
45068 11293 28
47041 5544 18
45113 4118 16
45154 8093 41
45320 15282 8
45459 26744 39
47031 5179 12
41004 4311 9
41003 2397 5
41010 3321 5
41002 2104 6
45429 25537 39
45305 11159 16
45409 13554 9
45419 15782 33
45121 8919 26
45440 19463 25
45420 24393 20
45410 17025 7
45430 7137 7
45403 16794 8
45142 4973 10

Season Pass Holders 14171 17576 13437 5731 9952 6913 13349 15713 11353 15105 3411 8233 5566 6193 21043 21596 21683 6642 5603 9028 22356 25849 7913 21137 18236 33968 26485 15868 8941 5029 42737 39939 11683 28915 3917 40218 14779 22887 18431 20372 22298 22880 21823 27033 13522 25763 14175 4799 29001 14755 25623 44178 20015 26316 2266 12597 18730 22552 2072 50429 13298 12504 46264 3770 13432 16982 20892 62303 17701 17372 51730 31179 9748 16386 52874 3662 51183 22009 21398 3215 3441 10312 6988 2114 12507 1227 29874 21986 49621 7280 3198 5194 1712 6910 4835 12550 28821 28811 36066 2376 5242 2132 9686 2740 10370 2900 31944 9671 12675 8485 7381 2968 7961 7249 23119 6854 1730 4218 3774 31929 3628 9608 10579 4202 4239 1602 4435 26281 19237 11293 5544 4118 8093 15282 26744 5179 4311 2397 3321 2104 25537 11159 13554 15782 8919 19463 24393 17025 7137 16794 4973 224 42 15 78 19 28 83 75 69 83 9 8 36 63 207 133 102 36 42 55 207 193 41 86 424 342 269 236 111 84 564 361 153 308 54 493 176 205 215 357 189 380 310 142 100 423 244 58 244 303 299 307 377 448 22 214 323 307 52 440 184 47 561 52 154 164 209 496 189 226 286 316 106 192 657 19 549 217 278 26 25 72 80 11 62 11 267 154 322 35 18 35 11 38 19 59 91 88 225 9 10 10 101 17 36 11 93 54 61 47 10 7 13 14 129 22 12 11 20 55 10 40 23 17 23 5 12 75 15 28 18 16 41 8 39 12 9 5 5 6 39 16 9 33 26 25 20 7 7 8 10

Regression

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.7983920548
R Square 0.6374298732
Adjusted R Square 0.6349965167
Standard Error 87.8306083792
Observations 151
ANOVA
df SS MS F Significance F
Regression 1 2020777.25450307 2020777.25450307 261.9549822314 1.21754879330383E-34
Residual 149 1149418.14947044 7714.215768258
Total 150 3170195.40397351
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -16.2583669498 11.4377663975 -1.4214634558 0.1572717254 -38.8595440746 6.3428101749 -38.8595440746 6.3428101749
Population 0.0091829496 0.0005673733 16.185023393 1.2175487933039E-34 0.0080618125 0.0103040866 0.0080618125 0.0103040866
Critical Value 1.9760131777

Descriptive Stat

Season Pass Holders Population
Mean 128.2649006623 Mean 15738.2185430464
Standard Error 11.8306583501 Standard Error 1028.5914706962
Median 59 Median 12675
Mode 11 Mode ERROR:#N/A
Standard Deviation 145.3775636971 Standard Deviation 12639.5436014091
Sample Variance 21134.6360264901 Sample Variance 159758062.451921
Kurtosis 1.4545462674 Kurtosis 1.6125772189
Skewness 1.4289111467 Skewness 1.306203371
Range 652 Range 61076
Minimum 5 Minimum 1227
Maximum 657 Maximum 62303
Sum 19368 Sum 2376471
Count 151 Count 151
Confidence Level(95.0%) 23.376260902 Confidence Level(95.0%) 2032.3993702633