Given the accompanying sample data, use Excel's formula options to find the 90% confidence interval for the population mean.
Assume that the population is normally distributed and that the population standard deviation equals 5
...
CONFIDENCE INTERVAL FOR μ WHEN & IS KNOWN - Excel
?图
FILE
HOME
INSERT
PAGE LAYOUT
FORMULAS
DATA REVIEW VIEW
Calibri
A A
Paste
Wrap Text
BIUÙ Ù ==== Merge & Center
==
General
$%
Clipboard
A24
Font
X
✓
fx
Alignment
Γ
Number
Conditional Format as Cell
Formatting Table Styles
Styles
Insert Delete Format Editing
Cells
4
A
B
C
D
E
F
G
H
I
J
K
L
M
N
0
5
-7
equals 5
6
-10
7
8
Complete the following analysis. Do not hard code values in your calculations.
8
-3
9
-2
Confidence Coefficient
10
-1
Population Standard Deviation
0.9
5
11
-6
Sample Size n
20
12
4
α/2
0.05
13
-4
14
8
Sample Mean x
Compute the sample mean using A1 thru A20
15
4
16
6
Z1-α/2
Compute the Z score using E12
17
-7
18
-6
Lower Limit of Confidence Interval
Compute the lower limit of the confidence Interval using E10, E11, E14, an
19
1
20
10
Upper Limit of Confidence Interval
Compute the upper limit of the confidence Interval using E10, E11, E14, an