Question
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
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).
d. Provide 95% confidence interval estimates of the population standard deviation (to 4 decimals).
| Company | Price Change ($) | Part a | |||
| Aflac | 0.81 | Variance (to 4 decimals) | 0.4721 | ||
| Bank of Am. | 1.45 | ||||
| Cablevision | -0.05 | Part b | |||
| Diageo | 0.91 | Standard Deviation (to 4 decimals) | 0.6871 | ||
| Fluor Cp | 0.41 | ||||
| Goodrich | 0.22 | Part c | |||
| John.&John. | 1.32 | Degrees of Freedom | 11 | ||
| Loews Cp | 0.98 | ||||
| Nokia | 2.35 | Left-Tailed Probability (to 4 decimals) | -21.9200 | ||
| SmpraEngy | 0.50 | Right-Tailed Probability (to 4 decimals) | 3.8157 | ||
| Sunoco | 0.28 | ||||
| Tyson Food | 0.10 | The 95% Confidence Interval of the Population Variance | |||
| C.I.Lower Limit (to 4 decimals) | -0.2369 | ||||
| C.I.Upper Limit (to 4 decimals) | 1.3609 | ||||
| The 95% Confidence Interval of the Standard Deviation | |||||
| C.I.Lower Limit (to 4 decimals) | #NUM! | ||||
| C.I.Upper Limit (to 4 decimals) | 1.1665779 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Statistics Unlocking The Power Of Data
Authors: Robin H. Lock, Patti Frazer Lock, Kari Lock Morgan, Eric F. Lock, Dennis F. Lock
1st Edition
0470601876, 978-0470601877
