ent answers. 4. The file Hawaiipercapita.xls7 contains information about the ann
ID: 3044435 • Letter: E
Question
ent answers. 4. The file Hawaiipercapita.xls7 contains information about the annual per capita income for Hawai's four county governments. This informatio lected by the Hawaii Department of Business Economic Development and Tourism, is used to allocate state funds for many social services. Va. Use KStat or Excel to calculate the sample mean and standard deviation for each county. b. Set up hypothesis tests to determine if a statistically significant differ- ence exists between each pair of counties. You will need to set up six separate tests. c. Use the formulas from Section 2.5 to calculate the test statistic for each of d. Use the test statistics from part c to compute p-values for each of the e. Repeat the p-value calculations for each test directly using Excel's TTEST the six tests. six tests. function. Ensure your answers resemble the ones you found in part d. Some rounding in the hand calculations will give you slightly different answers. See http://www2.hawaii.gov/DBEDT/ 05Explanation / Answer
Year
State Total
City and County of fHonolulu
Harwaii
Kauai
Maui and Kalawao
1969
4548
4752
3593
3799
3679
1970
5096
5287
4223
4174
4308
1971
5332
5630
4093
4107
4235
1972
5697
5927
4744
4596
4693
1973
6151
6410
5027
4971
5070
1974
6952
6968
6917
6937
6791
1975
7388
7590
6501
6375
6657
1976
7880
8167
6563
6577
6983
1977
8356
8636
7035
7104
7516
1978
9148
9511
7581
7547
8000
1979
10188
10608
8405
8394
8893
1980
11512
11855
10150
10085
10399
1981
12309
12914
9859
9988
10485
1982
12927
13583
10233
10595
11038
1983
13880
14499
11198
11567
12382
1984
14912
15769
11391
11784
12717
1985
15693
16635
11681
12428
13482
1986
16409
17350
12379
13044
14434
1987
17392
18477
12854
13503
15205
1988
18891
20038
13878
15613
16575
1989
20540
21727
15309
17420
18258
1990
22391
23772
16619
18692
19782
1991
23155
24680
17117
19553
19965
1992
24227
26293
17685
12640
21498
1993
25026
26756
18108
20662
22032
1994
25335
27042
18408
21231
22512
1995
25584
27328
18521
21855
22655
1996
25661
27436
18842
21602
22493
1997
26249
28140
18970
21899
22755
1998
26731
28640
19712
22277
23273
1999
27533
29465
20340
23061
24312
Mean=
15583.65
16512.42
11868.90
12712.26
13647.65
SD=
7894.18
8548.64
5446.43
6471.55
6978.12
T Test
Pair
City and County of Honolulu and Harwaii
P Value
0.013321487
*
T Value
2.553341081
T Test
Pair
City and County of Honolulu and Kauai
NS
P Value
0.053064099
T Value
1.974744774
T Test
Pair
City and County of Honolulu and Maui and Kalawao
P Value
0.1535421
NS
T Value
1.446062484
T Test
Pair
Harwaii and Kauai
P Value
0.580862498
NS
T Value
0.555244849
T Test
Pair
Harwaii and Maui and Kalawao
P Value
0.267684623
T Value
1.119161946
T Test
Pair
Kauai and Maui and Kalawao
P Value
0.586252409
NS
T Value
0.547329472
In the Table above given P values and T values of Test statistic used to compare the annual per capita income between every pair of states in Hawaii. Table also shows either * or NS. The symbol * means statistically significant difference in per capita income of the respective pair of states. The letters NS means per capita income in the respective pair of states is not significant.
Year
State Total
City and County of fHonolulu
Harwaii
Kauai
Maui and Kalawao
1969
4548
4752
3593
3799
3679
1970
5096
5287
4223
4174
4308
1971
5332
5630
4093
4107
4235
1972
5697
5927
4744
4596
4693
1973
6151
6410
5027
4971
5070
1974
6952
6968
6917
6937
6791
1975
7388
7590
6501
6375
6657
1976
7880
8167
6563
6577
6983
1977
8356
8636
7035
7104
7516
1978
9148
9511
7581
7547
8000
1979
10188
10608
8405
8394
8893
1980
11512
11855
10150
10085
10399
1981
12309
12914
9859
9988
10485
1982
12927
13583
10233
10595
11038
1983
13880
14499
11198
11567
12382
1984
14912
15769
11391
11784
12717
1985
15693
16635
11681
12428
13482
1986
16409
17350
12379
13044
14434
1987
17392
18477
12854
13503
15205
1988
18891
20038
13878
15613
16575
1989
20540
21727
15309
17420
18258
1990
22391
23772
16619
18692
19782
1991
23155
24680
17117
19553
19965
1992
24227
26293
17685
12640
21498
1993
25026
26756
18108
20662
22032
1994
25335
27042
18408
21231
22512
1995
25584
27328
18521
21855
22655
1996
25661
27436
18842
21602
22493
1997
26249
28140
18970
21899
22755
1998
26731
28640
19712
22277
23273
1999
27533
29465
20340
23061
24312
Mean=
15583.65
16512.42
11868.90
12712.26
13647.65
SD=
7894.18
8548.64
5446.43
6471.55
6978.12
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.