GMU Statistics Excel

Type your G # here:G12345678
You have until 5:45PM on Thursday Dec 3rd
Problem #
1
2
3
4
5
6
7
Point value
2
2
2
2
2
3
2
Total
15
Topic
multinomial distribution
test for independence / randomness
test for independence / randomness
test for independence / randomness
nonparametric test for the center
test for distribution of a population
multinomial distribution
8
59.8
97.0
133.4
88.6
27.6
128.2
138.0
73.2
45.2
32.0
80.6
141.6
170.6
75.2
94.6
68.2
38.0
66.6
67.8
51.4
19.6
71.2
39.2
69.8
126.0
49.4
70.0
52.8
65.4
87.2
74.2
151.4
110.0
156.6
77.8
17.4
20.8
144.2
77.0
61.2
73.2
82.6
35.6
97.4
58.4
47.4
44.0
16.2
82.8
32.8
#6 data
67.8
105.0
141.4
96.6
35.6
136.2
146.0
81.2
53.2
40.0
88.6
149.6
178.6
83.2
102.6
76.2
46.0
74.6
75.8
59.4
27.6
79.2
47.2
77.8
134.0
57.4
78.0
60.8
73.4
95.2
82.2
159.4
118.0
164.6
85.8
25.4
28.8
152.2
85.0
69.2
81.2
90.6
43.6
105.4
66.4
55.4
52.0
24.2
90.8
40.8
In craps, the shooter rolls 2 dice. Depending on the result,
three things can happen:
Dice show
7 or 11
2, 3, or 12
4, 5, 6, 8, 9, 10
Outcome
Immediate win
Immediate loss
Game continues
If the shooter plays the game 5 times, what are the chances of having
1 immediate win, 1 immediate loss, and 3 cases where the game continues?
0.222222
0.111111
0.666667
A casino decides to test whether there is a “best seat” at the blackjack table.
Note that, in blackjack, each player compares their cards to the dealer’s cards to determine whether they win or lose.
You can assume that the house has a 2% advantage, ie out of 1000 games the player expects to win 490 times.
1,000 games are observed, with these results:
Seat #
Number of Winners
1
468
2
481
Test the hypothesis that all seats are equal using 5% significance
Pearson’s “D” statistic is:
The 5% critical value is:
The decision is:
(accept or reject)
3
483
4
495
5
502
r they win or lose.
6
511
Do husbands and wives vote independently of each other?
Here are the data from 152 households:
husband
Trump
Biden
Green
wife
Trump
Biden
Green
28
38
8
24
27
8
8
8
3
60
73
19
74
59
19
152
Test the hypothesis of independence using 2.5% significance
The test statistic is:
The 2.5% critical value is:
The decision is:
(accept or reject)
Does the stock market “remember” what happened yesterday, or is each day indpendent of the day before?
We observe the closing S&P 500 average for each of the 252 trading days over the past year:
Day
S&P Avg
move
W
11/29/2019
12/2/2019
12/3/2019
12/4/2019
12/5/2019
12/6/2019
12/9/2019
12/10/2019
12/11/2019
12/12/2019
12/13/2019
12/16/2019
12/17/2019
12/18/2019
12/19/2019
12/20/2019
12/23/2019
12/24/2019
12/26/2019
12/27/2019
12/30/2019
12/31/2019
1/2/2020
1/3/2020
1/6/2020
1/7/2020
1/8/2020
1/9/2020
1/10/2020
1/13/2020
1/14/2020
1/15/2020
1/16/2020
1/17/2020
1/21/2020
1/22/2020
1/23/2020
1/24/2020
1/27/2020
1/28/2020
1/29/2020
1/30/2020
3140.97998
3113.870117
3093.199951
3112.76001
3117.429932
3145.909912
3135.959961
3132.52002
3141.629883
3168.570068
3168.800049
3191.449951
3192.52002
3191.139893
3205.370117
3221.219971
3224.01001
3223.379883
3239.909912
3240.02002
3221.290039
3230.780029
3257.850098
3234.850098
3246.280029
3237.179932
3253.050049
3274.699951
3265.350098
3288.129883
3283.149902
3289.290039
3316.810059
3329.620117
3320.790039
3321.75
3325.540039
3295.469971
3243.629883
3276.23999
3273.399902
3283.659912
down
down
up
up
up
down
down
up
up
up
up
up
down
up
up
up
down
up
up
down
up
up
down
up
down
up
up
down
up
down
up
up
up
down
up
up
down
down
up
down
up
down
1
1
2
2
2
3
3
4
4
4
4
4
5
6
6
6
7
8
8
9
10
10
11
12
13
14
14
15
16
17
18
18
18
19
20
20
21
21
22
23
24
25
The test statistic is:
The 5% critical value is:
The decision is:
In one sentence, indicate a possible flaw in th
1/31/2020
2/3/2020
2/4/2020
2/5/2020
2/6/2020
2/7/2020
2/10/2020
2/11/2020
2/12/2020
2/13/2020
2/14/2020
2/18/2020
2/19/2020
2/20/2020
2/21/2020
2/24/2020
2/25/2020
2/26/2020
2/27/2020
2/28/2020
3/2/2020
3/3/2020
3/4/2020
3/5/2020
3/6/2020
3/9/2020
3/10/2020
3/11/2020
3/12/2020
3/13/2020
3/16/2020
3/17/2020
3/18/2020
3/19/2020
3/20/2020
3/23/2020
3/24/2020
3/25/2020
3/26/2020
3/27/2020
3/30/2020
3/31/2020
4/1/2020
4/2/2020
4/3/2020
4/6/2020
4/7/2020
3225.52002
3248.919922
3297.590088
3334.689941
3345.780029
3327.709961
3352.090088
3357.75
3379.449951
3373.939941
3380.159912
3370.290039
3386.149902
3373.22998
3337.75
3225.889893
3128.209961
3116.389893
2978.76001
2954.219971
3090.22998
3003.370117
3130.120117
3023.939941
2972.370117
2746.560059
2882.22998
2741.379883
2480.639893
2711.02002
2386.129883
2529.189941
2398.100098
2409.389893
2304.919922
2237.399902
2447.330078
2475.560059
2630.070068
2541.469971
2626.649902
2584.590088
2470.5
2526.899902
2488.649902
2663.679932
2659.409912
up
up
up
up
down
up
up
up
down
up
down
up
down
down
down
down
down
down
down
up
down
up
down
down
down
up
down
down
up
down
up
down
up
down
down
up
up
up
down
up
down
down
up
down
up
down
up
26
26
26
26
27
28
28
28
29
30
31
32
33
33
33
33
33
33
33
34
35
36
37
37
37
38
39
39
40
41
42
43
44
45
45
46
46
46
47
48
49
49
50
51
52
53
54
4/8/2020
4/9/2020
4/13/2020
4/14/2020
4/15/2020
4/16/2020
4/17/2020
4/20/2020
4/21/2020
4/22/2020
4/23/2020
4/24/2020
4/27/2020
4/28/2020
4/29/2020
4/30/2020
5/1/2020
5/4/2020
5/5/2020
5/6/2020
5/7/2020
5/8/2020
5/11/2020
5/12/2020
5/13/2020
5/14/2020
5/15/2020
5/18/2020
5/19/2020
5/20/2020
5/21/2020
5/22/2020
5/26/2020
5/27/2020
5/28/2020
5/29/2020
6/1/2020
6/2/2020
6/3/2020
6/4/2020
6/5/2020
6/8/2020
6/9/2020
6/10/2020
6/11/2020
6/12/2020
6/15/2020
2749.97998
2789.820068
2761.629883
2846.060059
2783.360107
2799.550049
2874.560059
2823.159912
2736.560059
2799.310059
2797.800049
2836.73999
2878.47998
2863.389893
2939.51001
2912.429932
2830.709961
2842.73999
2868.439941
2848.419922
2881.189941
2929.800049
2930.189941
2870.120117
2820
2852.5
2863.699951
2953.909912
2922.939941
2971.610107
2948.51001
2955.449951
2991.77002
3036.129883
3029.72998
3044.310059
3055.72998
3080.820068
3122.870117
3112.350098
3193.929932
3232.389893
3207.179932
3190.139893
3002.100098
3041.310059
3066.590088
up
down
up
down
up
up
down
down
up
down
up
up
down
up
down
down
up
up
down
up
up
up
down
down
up
up
up
down
up
down
up
up
up
down
up
up
up
up
down
up
up
down
down
down
up
up
up
54
55
56
57
58
58
59
59
60
61
62
62
63
64
65
65
66
66
67
68
68
68
69
69
70
70
70
71
72
73
74
74
74
75
76
76
76
76
77
78
78
79
79
79
80
80
80
6/16/2020
6/17/2020
6/18/2020
6/19/2020
6/22/2020
6/23/2020
6/24/2020
6/25/2020
6/26/2020
6/29/2020
6/30/2020
7/1/2020
7/2/2020
7/6/2020
7/7/2020
7/8/2020
7/9/2020
7/10/2020
7/13/2020
7/14/2020
7/15/2020
7/16/2020
7/17/2020
7/20/2020
7/21/2020
7/22/2020
7/23/2020
7/24/2020
7/27/2020
7/28/2020
7/29/2020
7/30/2020
7/31/2020
8/3/2020
8/4/2020
8/5/2020
8/6/2020
8/7/2020
8/10/2020
8/11/2020
8/12/2020
8/13/2020
8/14/2020
8/17/2020
8/18/2020
8/19/2020
8/20/2020
3124.73999
3113.48999
3115.340088
3097.73999
3117.860107
3131.290039
3050.330078
3083.76001
3009.050049
3053.23999
3100.290039
3115.860107
3130.01001
3179.719971
3145.320068
3169.939941
3152.050049
3185.040039
3155.219971
3197.52002
3226.560059
3215.570068
3224.72998
3251.840088
3257.300049
3276.02002
3235.659912
3215.629883
3239.409912
3218.439941
3258.439941
3246.219971
3271.120117
3294.610107
3306.51001
3327.77002
3349.159912
3351.280029
3360.469971
3333.689941
3380.350098
3373.429932
3372.850098
3381.98999
3389.780029
3374.850098
3385.51001
down
up
down
up
up
down
up
down
up
up
up
up
up
down
up
down
up
down
up
up
down
up
up
up
up
down
down
up
down
up
down
up
up
up
up
up
up
up
down
up
down
down
up
up
down
up
up
81
82
83
84
84
85
86
87
88
88
88
88
88
89
90
91
92
93
94
94
95
96
96
96
96
97
97
98
99
100
101
102
102
102
102
102
102
102
103
104
105
105
106
106
107
108
108
8/21/2020
8/24/2020
8/25/2020
8/26/2020
8/27/2020
8/28/2020
8/31/2020
9/1/2020
9/2/2020
9/3/2020
9/4/2020
9/8/2020
9/9/2020
9/10/2020
9/11/2020
9/14/2020
9/15/2020
9/16/2020
9/17/2020
9/18/2020
9/21/2020
9/22/2020
9/23/2020
9/24/2020
9/25/2020
9/28/2020
9/29/2020
9/30/2020
10/1/2020
10/2/2020
10/5/2020
10/6/2020
10/7/2020
10/8/2020
10/9/2020
10/12/2020
10/13/2020
10/14/2020
10/15/2020
10/16/2020
10/19/2020
10/20/2020
10/21/2020
10/22/2020
10/23/2020
10/26/2020
10/27/2020
3397.159912
3431.280029
3443.620117
3478.72998
3484.550049
3508.01001
3500.310059
3526.649902
3580.840088
3455.060059
3426.959961
3331.840088
3398.959961
3339.189941
3340.969971
3383.540039
3401.199951
3385.48999
3357.01001
3319.469971
3281.060059
3315.570068
3236.919922
3246.590088
3298.459961
3351.600098
3335.469971
3363
3380.800049
3348.419922
3408.600098
3360.969971
3419.439941
3446.830078
3477.139893
3534.219971
3511.929932
3488.669922
3483.340088
3483.810059
3426.919922
3443.120117
3435.560059
3453.48999
3465.389893
3400.969971
3390.679932
up
up
up
up
up
down
up
up
down
down
down
up
down
up
up
up
down
down
down
down
up
down
up
up
up
down
up
up
down
up
down
up
up
up
up
down
down
down
up
down
up
down
up
up
down
down
down
108
108
108
108
108
109
110
110
111
111
111
112
113
114
114
114
115
115
115
115
116
117
118
118
118
119
120
120
121
122
123
124
124
124
124
125
125
125
126
127
128
129
130
130
131
131
131
10/28/2020
10/29/2020
10/30/2020
11/2/2020
11/3/2020
11/4/2020
11/5/2020
11/6/2020
11/9/2020
11/10/2020
11/11/2020
11/12/2020
11/13/2020
11/16/2020
11/17/2020
11/18/2020
11/19/2020
11/20/2020
11/23/2020
11/24/2020
11/25/2020
11/27/2020
3271.030029
3310.110107
3269.959961
3310.23999
3369.159912
3443.439941
3510.449951
3509.439941
3550.5
3545.530029
3572.659912
3537.01001
3585.149902
3626.909912
3609.530029
3567.790039
3581.870117
3557.540039
3577.590088
3635.409912
3629.649902
3638.350098
up
down
up
up
up
up
down
up
down
up
down
up
up
down
down
up
down
up
up
down
up
132
133
134
134
134
134
135
136
137
138
139
140
140
141
141
142
143
144
144
145
146
(accept or reject)
dicate a possible flaw in this test
The following data come from an unknown distribution, and you cannot assume that its variance is finite
Test the hypothesis that the median = 60 using a 2-tail test with a 5% chance of committing a Type I error
Data
67.8
105
141.4
96.6
35.6
136.2
146
81.2
53.2
40
88.6
149.6
178.6
83.2
102.6
76.2
46
74.6
75.8
59.4
27.6
79.2
47.2
77.8
134
57.4
78
60.8
73.4
95.2
82.2
159.4
118
164.6
85.8
25.4
28.8
152.2
85
69.2
The test statistic is:
The 5% critical value is:
The decision is:
(accept or reject)
Test the hypothesis that the following data come from a normal distribution
with mean equal to the sample mean, and variance equal to the unbiased estimator from the sample.
Use 5% significance.
Data
Sample statistics
67.8
n
(max likelihood estimate of μ)
105.0
Ῡ
141.4
96.6
35.6
136.2
146.0
81.2
53.2
40.0
88.6
149.6
178.6
83.2
102.6
76.2
46.0
74.6
75.8
59.4
27.6
79.2
47.2
77.8
134.0
57.4
78.0
60.8
73.4
95.2
82.2
159.4
118.0
164.6
85.8
25.4
28.8
152.2
85.0
69.2
81.2
90.6
s2
s
(the unbiased estimate of σ2, using n-1 as divisor)
Test of H0
test statistic
dof
critical value
decision
(7 strata; subtract 1 because it was a sample; subt
(accept or reject)
To do this problem, use these 7 strata
Low
High
0
40
60
70
80
90
110
40
60
70
80
90
110
1000
43.6
105.4
66.4
55.4
52.0
24.2
90.8
40.8
because it was a sample; subtract 2 because we estimated 2 parameters)
Fit these data with an exponential model and perform
the appropriate goodness-of-fit test at 5% significance.
Remember to combine ranges with sparse data to the extent appropriate.
Range
0–1
1–2
2–3
3–4
4–5
5–6
6–7
7–8
D-statistic
Critical value
Decision
Observed Frequency
136
41
25
8
2
3
1
1
(accept or reject)