Using Excel, conduct a t-test (at the alpha = 0.01 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?

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

Using Excel, conduct a t-test (at the alpha = 0.01 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?

1 X1
[x2
97.88
98.66
2
105.98
102.29
4
96.01
111.40
99.70
106.15
96.96
100.10
7
99.80
104.89
8
92.73
99.24
106.30
104.79
10
97.90
101.51
11
95.04
104.04
12
94.42
104.09
13
103.16
97.28
14
98.95
103.73
15
98.42
101.94
16
97.80
103.85
17
96.40
100.41
18
102.15
104.14
19
96.12
94.57
20
95.78
98.56
21
100.11
96.74
22
100.33
104.82
23
100.03
101.48
24
103.29
107.04
25
102.22
96.67
26
104.13
102.39
27
104.04
98.24
28
107.69
105.65
96.30
99.42
29
103.89
30
101.15
31
98.26
102.15
32
108.13
33
97.59
34
109.58
35
98.93
36
100.66
37
102.74
38
105.02
39
103.80
40
100.04
41
95.27
42
100.58
43
104.62
44
45
46
Transcribed Image Text:1 X1 [x2 97.88 98.66 2 105.98 102.29 4 96.01 111.40 99.70 106.15 96.96 100.10 7 99.80 104.89 8 92.73 99.24 106.30 104.79 10 97.90 101.51 11 95.04 104.04 12 94.42 104.09 13 103.16 97.28 14 98.95 103.73 15 98.42 101.94 16 97.80 103.85 17 96.40 100.41 18 102.15 104.14 19 96.12 94.57 20 95.78 98.56 21 100.11 96.74 22 100.33 104.82 23 100.03 101.48 24 103.29 107.04 25 102.22 96.67 26 104.13 102.39 27 104.04 98.24 28 107.69 105.65 96.30 99.42 29 103.89 30 101.15 31 98.26 102.15 32 108.13 33 97.59 34 109.58 35 98.93 36 100.66 37 102.74 38 105.02 39 103.80 40 100.04 41 95.27 42 100.58 43 104.62 44 45 46
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
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman