Use dataset HT_2448.xls. Using Excel, conduct a t-test (at the alpha = 0.05 significance level) on whether the mean of X2 is equal to 100. What do you conclude from this sample data? Is the population mean equal to 100? Group of answer choices -You reject the null hypothesis. You conclude that the population mean is equal to 100. -You cannot reject the null hypothesis. You conclude that the population mean is not equal to 100. -You cannot reject the null hypothesis. You conclude that the population mean is equal to 100. -You reject the null hypothesis. You conclude that the population mean is not equal to 100. HT_2448.xls: X1 X2 102.04 96.13 100.47 97.63 103.17 95.42 95.09 104.41 103.81 102.08 95.36 103.33 103.38 112.25 100.26 96.93 97.24 100.19 99.61 102.70 96.00 106.94 100.69 102.29 100.50 100.00 98.81 97.67 95.15 99.09 100.01 98.57 102.88 97.70 101.36 108.11 103.05 106.94 96.17 104.36 98.44 96.87 101.00 102.42 96.93 100.17 91.57 106.98 100.99 100.54 103.18 110.63 104.37 100.11 100.99 107.77 102.50 104.10 107.25 102.75 100.45 99.85 105.07 100.93 96.16 98.94
Use dataset HT_2448.xls. Using Excel, conduct a t-test (at the alpha = 0.05 significance level) on whether the
Group of answer choices
-You reject the null hypothesis. You conclude that the population mean is equal to 100.
-You cannot reject the null hypothesis. You conclude that the population mean is not equal to 100.
-You cannot reject the null hypothesis. You conclude that the population mean is equal to 100.
-You reject the null hypothesis. You conclude that the population mean is not equal to 100.
HT_2448.xls:
X1 X2
102.04 96.13
100.47 97.63
103.17 95.42
95.09 104.41
103.81 102.08
95.36 103.33
103.38 112.25
100.26 96.93
97.24 100.19
99.61 102.70
96.00 106.94
100.69 102.29
100.50 100.00
98.81 97.67
95.15 99.09
100.01 98.57
102.88 97.70
101.36 108.11
103.05 106.94
96.17 104.36
98.44 96.87
101.00 102.42
96.93 100.17
91.57 106.98
100.99
100.54
103.18
110.63
104.37
100.11
100.99
107.77
102.50
104.10
107.25
102.75
100.45
99.85
105.07
100.93
96.16
98.94
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 7 images
