The table showing the stock price changes for a sample of 12 companies on a day is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. Open spreadsheet a. Compute the sample variance for the daily price change (to 4 decimals). b. Compute the sample standard deviation for the price change (to 4 decimals). c. Provide 95% confidence interval estimates of the population variance (to 4 decimals). <0²< d. Provide 95% confidence interval estimates of the population standard deviation (to 4 decimals). sos

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.4: Distributions Of Data
Problem 19PFA
icon
Related questions
Question
100%

please help asap i will upvote!!

E2
1234567
File
A
Company
Aflac
Bank of Am.
Home
Cablevision
Diageo
Fluor Cp
Goodrich
8 John.&John.
9
10
11 SmpraEngy
12 Sunoco
Loews Cp
Nokia
13 Tyson Food
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
24
=
Insert
Arial
x ✓ fx
B
Price
Change ($)
0.82
1.44
-0.06
0.91
0.40
0.19
1.31
0.95
2.38
0.51
0.31
0.10
Data +
Draw Page Layout
✓ 10
B
Part a
Variance (to 4 decimals)
Formulas
Part c
Degrees of Freedom
Part b
Standard Deviation (to 4 decimals)
D
Calculation Mode: Automatic Workbook Statistics
Data
Left-Tailed Probability (to 4 decimals)
Right-Tailed Probability (to 4 decimals)
Review
The 95% Confidence Interval of the Population Variance
C.I.Lower Limit (to 4 decimals)
C.I.Upper Limit (to 4 decimals)
The 95% Confidence Interval of the Standard Deviation
C.I.Lower Limit (to 4 decimals)
C.I.Upper Limit (to 4 decimals)
View Help
Ev ab
E
F
Number
Formula
G
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
$
←0
.00
.00
→.0
H
I
Loading Add-ins
J
Editing
Σv
K
T
L
Give Feedback to Microsoft
Comments
Ov
M
100% +
Transcribed Image Text:E2 1234567 File A Company Aflac Bank of Am. Home Cablevision Diageo Fluor Cp Goodrich 8 John.&John. 9 10 11 SmpraEngy 12 Sunoco Loews Cp Nokia 13 Tyson Food 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 24 = Insert Arial x ✓ fx B Price Change ($) 0.82 1.44 -0.06 0.91 0.40 0.19 1.31 0.95 2.38 0.51 0.31 0.10 Data + Draw Page Layout ✓ 10 B Part a Variance (to 4 decimals) Formulas Part c Degrees of Freedom Part b Standard Deviation (to 4 decimals) D Calculation Mode: Automatic Workbook Statistics Data Left-Tailed Probability (to 4 decimals) Right-Tailed Probability (to 4 decimals) Review The 95% Confidence Interval of the Population Variance C.I.Lower Limit (to 4 decimals) C.I.Upper Limit (to 4 decimals) The 95% Confidence Interval of the Standard Deviation C.I.Lower Limit (to 4 decimals) C.I.Upper Limit (to 4 decimals) View Help Ev ab E F Number Formula G #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A $ ←0 .00 .00 →.0 H I Loading Add-ins J Editing Σv K T L Give Feedback to Microsoft Comments Ov M 100% +
The table showing the stock price changes for a sample of 12 companies on a day is contained in the Excel Online file below. Construct a spreadsheet to answer the following
questions.
X
Open spreadsheet
a. Compute the sample variance for the daily price change (to 4 decimals).
b. Compute the sample standard deviation for the price change (to 4 decimals).
c. Provide 95% confidence interval estimates of the population variance (to 4 decimals).
so² s
d. Provide 95% confidence interval estimates of the population standard deviation (to 4 decimals).
<o<
Check My Work
Reset Problem
Transcribed Image Text:The table showing the stock price changes for a sample of 12 companies on a day is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. X Open spreadsheet a. Compute the sample variance for the daily price change (to 4 decimals). b. Compute the sample standard deviation for the price change (to 4 decimals). c. Provide 95% confidence interval estimates of the population variance (to 4 decimals). so² s d. Provide 95% confidence interval estimates of the population standard deviation (to 4 decimals). <o< Check My Work Reset Problem
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill