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. Company Price Change ($) Aflac 0.79 Bank of Am. 1.44 Cablevision -0.05 Diageo 0.93 Fluor Cp 0.42 Goodrich 0.20 John.&John. 1.33 Loews Cp 0.98 Nokia 2.36 SmpraEngy 0.51 Sunoco 0.29 Tyson Food 0.13Open 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). _____<=Sigma^2<=______ d. Provide 95% confidence interval estimates of the population standard deviation (to 4 decimals). _____<=Sigma<=______
Inverse Normal Distribution
The method used for finding the corresponding z-critical value in a normal distribution using the known probability is said to be an inverse normal distribution. The inverse normal distribution is a continuous probability distribution with a family of two parameters.
Mean, Median, Mode
It is a descriptive summary of a data set. It can be defined by using some of the measures. The central tendencies do not provide information regarding individual data from the dataset. However, they give a summary of the data set. The central tendency or measure of central tendency is a central or typical value for a probability distribution.
Z-Scores
A z-score is a unit of measurement used in statistics to describe the position of a raw score in terms of its distance from the mean, measured with reference to standard deviation from the mean. Z-scores are useful in statistics because they allow comparison between two scores that belong to different normal distributions.
11.1 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.
| Company | Price Change ($) |
| Aflac | 0.79 |
| Bank of Am. | 1.44 |
| Cablevision | -0.05 |
| Diageo | 0.93 |
| Fluor Cp | 0.42 |
| Goodrich | 0.20 |
| John.&John. | 1.33 |
| Loews Cp | 0.98 |
| Nokia | 2.36 |
| SmpraEngy | 0.51 |
| Sunoco | 0.29 |
| Tyson Food | 0.13 |
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
_____<=Sigma^2<=______
d. Provide 95% confidence interval estimates of the population standard deviation (to 4 decimals).
_____<=Sigma<=______
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
