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 ($)		Part a
Aflac	0.82		Variance (to 4 decimals)
Bank of Am.	1.46
Cablevision	-0.07		Part b
Diageo	0.90		Standard Deviation (to 4 decimals)
Fluor Cp	0.39
Goodrich	0.20		Part c
John.&John.	1.32		Degrees of Freedom
Loews Cp	0.97
Nokia	2.35		Left-Tailed Probability (to 4 decimals)
SmpraEngy	0.50		Right-Tailed Probability (to 4 decimals)
Sunoco	0.29
Tyson Food	0.12		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)