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?

Holt Mcdougal Larson Pre-algebra: Student Edition 2012
1st Edition
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Chapter11: Data Analysis And Probability
Section11.3: Using Data Displays
Problem 1E
icon
Related questions
Question

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?

 

 

Quiz: Quiz - 9.2 Two-sample two- X
L Files
b Quiz: Quiz - 9.2 Two-sample two
+
loyno.instructure.com/courses/9897/files/folder/HT_1234%20data?preview=1106738
E
HT_4143.xls
BUAN
205-001 BUSINESS ANALYTICS
T 1234 data
I Download
O Info
X Close
ZOOM
+
X1
X2
99.73
98.69
95.93
98.94
94.92
96.63
100.52
99.16
101.28
94.93
99.79
101.97
97.92
98.75
97.71
100.72
10
100.82
102.75
99.78
101.34
95.87
99.16
100.21
98.96
105.68
102.69
100.32
94.37
101.22
96.88
98.74
104.39
102.65
105.40
101.73
92.90
101.39
94.82
95.42
101.30
98.94
92.52
99.71
102.13
101.63
100.54
100.34
96.12
98.11
106.75
103.37
106.21
102.47
107.57
95.41
104.52
97.05
105.75
99.97
103.88
94.06
105.75
101.14
99.73
100.95
97.73
100.53
101.23
104.39
101.01
104.09
104.29
97.81
100.83
92.38
102.55
97.22
101.19
104.12
104.25
97.69
106.09
100.55
104.76
12:15 PM
O Type here to search
N
E 4)
N
3/31/2022
>
Transcribed Image Text:Quiz: Quiz - 9.2 Two-sample two- X L Files b Quiz: Quiz - 9.2 Two-sample two + loyno.instructure.com/courses/9897/files/folder/HT_1234%20data?preview=1106738 E HT_4143.xls BUAN 205-001 BUSINESS ANALYTICS T 1234 data I Download O Info X Close ZOOM + X1 X2 99.73 98.69 95.93 98.94 94.92 96.63 100.52 99.16 101.28 94.93 99.79 101.97 97.92 98.75 97.71 100.72 10 100.82 102.75 99.78 101.34 95.87 99.16 100.21 98.96 105.68 102.69 100.32 94.37 101.22 96.88 98.74 104.39 102.65 105.40 101.73 92.90 101.39 94.82 95.42 101.30 98.94 92.52 99.71 102.13 101.63 100.54 100.34 96.12 98.11 106.75 103.37 106.21 102.47 107.57 95.41 104.52 97.05 105.75 99.97 103.88 94.06 105.75 101.14 99.73 100.95 97.73 100.53 101.23 104.39 101.01 104.09 104.29 97.81 100.83 92.38 102.55 97.22 101.19 104.12 104.25 97.69 106.09 100.55 104.76 12:15 PM O Type here to search N E 4) N 3/31/2022 >
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill