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.
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 ($) |
| Aflac | 0.82 |
| Bank of Am. | 1.46 |
| Cablevision | -0.05 |
| Diageo | 0.91 |
| Fluor Cp | 0.42 |
| Goodrich | 0.19 |
| John.&John. | 1.31 |
| Loews Cp | 0.96 |
| Nokia | 2.36 |
| SmpraEngy | 0.53 |
| Sunoco | 0.28 |
| Tyson Food | 0.11 |
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 For Business And Economics
Authors: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams
11th Edition
978-0324783254, 324783256, 978-0324783247, 324783248, 978-0538481649
