Lab - 2 A Saved Help Save & Exit Submit 7 Given the accompanying sample data, use Excel's formula options to determine if the population mean is less than 125 at the 5% significance level. Assume that the population is normally distributed and that the population standard deviation equals 12. HYPOTHESIS TEST FOR THE POPULATION MEAN WHEN o IS KNOWN - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW 7.5 E Fill - AutoSum- points -10 -A A Wrap Text Arial General $- % Conditional Format as Cell Formatting Table Styles Sort Filte Paste BIU- A- EE E Merge & Center - Insert Delete Format Clear- Clipboard Font Alignment Number Styles Cells Editing Ask Al fe 105 G H I A C DE F J K L M N References 1 105 HYPOTHESIS TEST FOR THE POPULATION MEAN WHEN o IS KNOWN 117 3 Given the accompanying sample data, use Excel's formula options to determine if the population mean is less than 125 at the 5% significance level. Assume that the population is normally distributed and that the population standard deviation equals 12. 112 4 148 144 106 124 124 Complete the following analysis. Do not hard code values in your calculations. 8 137 Ho: μ 2 Ha: u< 9 125 125 0.05 12 20 128 10 133 11 107 a = 12 123 13 108 n = 14 106 15 138 Sample Mean 122.95 Mean can only be calculated using values in cells A1 through A20 16 121 17 129 Z test Statistic Z Statistic can only be calculated using E9, E10, E11, E12, E13, and E15 18 130 p value Compute the probability that Z is less than the Z Statistic. 19 102 20 141 21 Conclusion 22 23
Lab - 2 A Saved Help Save & Exit Submit 7 Given the accompanying sample data, use Excel's formula options to determine if the population mean is less than 125 at the 5% significance level. Assume that the population is normally distributed and that the population standard deviation equals 12. HYPOTHESIS TEST FOR THE POPULATION MEAN WHEN o IS KNOWN - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW 7.5 E Fill - AutoSum- points -10 -A A Wrap Text Arial General $- % Conditional Format as Cell Formatting Table Styles Sort Filte Paste BIU- A- EE E Merge & Center - Insert Delete Format Clear- Clipboard Font Alignment Number Styles Cells Editing Ask Al fe 105 G H I A C DE F J K L M N References 1 105 HYPOTHESIS TEST FOR THE POPULATION MEAN WHEN o IS KNOWN 117 3 Given the accompanying sample data, use Excel's formula options to determine if the population mean is less than 125 at the 5% significance level. Assume that the population is normally distributed and that the population standard deviation equals 12. 112 4 148 144 106 124 124 Complete the following analysis. Do not hard code values in your calculations. 8 137 Ho: μ 2 Ha: u< 9 125 125 0.05 12 20 128 10 133 11 107 a = 12 123 13 108 n = 14 106 15 138 Sample Mean 122.95 Mean can only be calculated using values in cells A1 through A20 16 121 17 129 Z test Statistic Z Statistic can only be calculated using E9, E10, E11, E12, E13, and E15 18 130 p value Compute the probability that Z is less than the Z Statistic. 19 102 20 141 21 Conclusion 22 23
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
The answer should be in excel formula format.
Transcribed Image Text:Lab - 2 i
Saved
Help
Save & Exit
Submit
7
Given the accompanying sample data, use Excel's formula options to determine if the population mean is less than 125 at the 5%
significance level. Assume that the population is normally distributed and that the population standard deviation equals 12.
HYPOTHESIS TEST FOR THE POPULATION MEAN WHEN o IS KNOWN - Excel
FILE
НОМЕ
INSERT
PAGE LAYOUT
FORMULAS
DATA
REVIEW
VIEW
7.5
Σ AutoSum
points
Arial
10
A A
Wrap Text
General
V Fill -
Conditional Format as
Cell
в I U
$ - % ,
Sort
Filte
Paste
Merge & Center
.00 .0
+.0
.00
Insert Delete Format
Formatting Table Styles -
Clear -
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
Ask
A1
105
А
В
C
E
F
H.
I
J
K
M
N
References
1
105
HYPOTHESIS TEST FOR THE POPULATION MEAN WHEN o IS KNOWN
2
117
Given the accompanying sample data, use Excel's formula options to determine if the
population mean is less than 125 at the 5% significance level. Assume that the population is
normally distributed and that the population standard deviation equals 12.
3
112
4
148
5
144
6.
106
7
124
Complete the following analysis. Do not hard code values in your calculations.
8.
137
Но: и 2
125
125
0.05
12
20
9
128
10
133
На:
11
107
a =
12
123
O =
13
108
n =
14
106
15
138
Sample Mean
122.95
Mean can only be calculated using values in cells A1 through A20
16
121
Z Statistic can only be calculated using E9, E10, E11, E12, E13, and E15
17
129
Z test Statistic
18
130
19
p value
Compute the probability that Z is less than the Z Statistic.
102
20
141
21
Conclusion
S
22
23
Mc
Graw
Hill
< Prev
7 of 10
Next >
>
Transcribed Image Text:Lab - 2 i
Saved
Help
Save & Exit
Submit
8.
Given the accompanying sample data, use Excel's formula options to determine if the population mean differs from 3 at the 5%
significance level. Assume that the population is normally distributed and that the population standard deviation equals 5.
HYPOTHESIS TEST FOR THE POPULATION MEAN WHEN o IS KNOWN - Excel
FILE
НОМЕ
INSERT
PAGE LAYOUT
FORMULAS
DATA
REVIEW
VIEW
7.5
Σ AutoSum
points
Arial
10
A A
Wrap Text
General
V Fill -
Conditional Format as
Cell
в I U
$ - % ,
Sort
Filte
Paste
Merge & Center
.00 .0
+.0
.00
Insert Delete Format
Formatting Table Styles -
Clear -
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
Ask
A1
-9
A
В
C
D
E
F
H
I
J
K
M
References
1
-9
HYPOTHESIS TEST FOR THE POPULATION MEAN WHEN o IS KNOWN
2
3
8
Given the accompanying sample data, use Excel's formula options to determine if the population mean differs from 3 at the 5%
significance level. Assume that the population is normally distributed and that the population standard deviation equals 5.
4
-4
5
-7
6.
-10
7
8.
Complete the following analysis. Do not hard code values in your calculations. Use E9 thru E13 and A1:A20 to compute the values
8.
-3
Но: и
На: #
3
3
0.05
5
20
9
-2
10
-1
11
-6
a
%3D
12
4
13
-4
%3D
14
8.
15
4
Sample Mean
Mean can only be calculated using values in cells A1 through A20
16
6.
17
-7
Z test Statistic
Z Statistic can only be calculated using E9, E10, E11, E12, E13, and E15
18
-6
19
1
value
Compute the probability that Z is less than the Z Statistic.
20
10
21
Conclusion
S
22
23
Mc
Graw
Hill
< Prev
8 of 10
Next >
WE V
II
>
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman