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