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