Use HT_5038.xls. Using Excel, conduct a t-test (at the alpha = 0.10 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 a-You cannot reject the null hypothesis. You conclude that the population mean is not equal to 100. b-You reject the null hypothesis. You conclude that the population mean is equal to 100. c-You reject the null hypothesis. You conclude that the population mean is not equal to 100. d-You cannot reject the null hypothesis. You conclude that the population mean is equal to 100. HT 5038.xls X1 X2 99.06 97.66 98.75 109.37 101.43 98.72 107.65 93.69 100.63 98.82 101.65 95.57 97.25 97.81 94.15 100.24 102.03 103.08 101.38 102.12 100.62 102.52 98.30 103.25 108.59 109.51 98.22 95.23 99.30 110.33 100.63 97.67 96.31 104.76 98.86 98.85 101.54 105.94 100.90 101.13 97.73 102.45 99.41 99.66 98.50 102.36 100.03 109.84 104.39 99.03 99.83 106.78 102.48 102.02 102.36 99.70 95.68 106.62 104.19 97.30 99.63 105.02 95.47 98.45 103.32 101.45 103.63 98.91 100.68 99.42 93.57 102.55 97.32 106.42 102.81 102.38 92.45 102.60 95.03 100.22 101.62 96.47 98.72 102.40 109.07 96.75 99.34 99.11
Use HT_5038.xls. Using Excel, conduct a t-test (at the alpha = 0.10 significance level) on whether the
Group of answer choices
a-You cannot reject the null hypothesis. You conclude that the population mean is not equal to 100.
b-You reject the null hypothesis. You conclude that the population mean is equal to 100.
c-You reject the null hypothesis. You conclude that the population mean is not equal to 100.
d-You cannot reject the null hypothesis. You conclude that the population mean is equal to 100.
HT 5038.xls
X1 X2
99.06 97.66
98.75 109.37
101.43 98.72
107.65 93.69
100.63 98.82
101.65 95.57
97.25 97.81
94.15 100.24
102.03 103.08
101.38 102.12
100.62 102.52
98.30 103.25
108.59 109.51
98.22 95.23
99.30 110.33
100.63 97.67
96.31 104.76
98.86 98.85
101.54 105.94
100.90 101.13
97.73 102.45
99.41 99.66
98.50 102.36
100.03 109.84
104.39 99.03
99.83 106.78
102.48 102.02
102.36 99.70
95.68 106.62
104.19 97.30
99.63 105.02
95.47 98.45
103.32 101.45
103.63 98.91
100.68 99.42
93.57 102.55
97.32 106.42
102.81 102.38
92.45
102.60
95.03
100.22
101.62
96.47
98.72
102.40
109.07
96.75
99.34
99.11
Step by step
Solved in 2 steps with 1 images
