A B C D E F G H I J K Price Company Change ($) Part a Formula NE Aflac 0.80 Variance (to 4 decimals) 0.4727 =VARA(B2:B13) Bank of Am. 1.46 AW Cablevision -0.05 Part b Diageo 0.90 Standard Deviation (to 4 decimals) 0.6876 =STDEV(B2:B13) Fluor Cp 0.40 7 Goodrich 0.22 Part c 8 John. &John. 1.32 Degrees of Freedom 11 =COUNT(B2:B13)-1 9 Loews Cp 0.98 10 Nokia 2.35 Left-Tailed Probability (to 4 decimals) #N/A 11 SmpraEngy 0.52 Right-Tailed Probability (to 4 decimals) #N/A 12 Sunoco 0.28 13 Tyson Food 0. 10 The 95% Confidence Interval of the Population Variance 14 C.I.Lower Limit (to 4 decimals) #N/A 15 C.I.Upper Limit (to 4 decimals) #N/A 16 17 The 95% Confidence Interval of the Standard Deviation 18 C.I.Lower Limit (to 4 decimals) #N/A 19 C.I.Upper Limit (to 4 decimals) #N/A 20 21 22 23 24 25 26 27 28 29 30 31 32 E & Data + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% +