Sample data from a normal population are located in the Microsoft Excel Online file below. Use the data to answer the following questions for the ? unknown case.

Open spreadsheet

The point estimate of the population mean is (to 2 decimals)

The standard deviation is (to 2 decimals)

The margin of error is (to 1 decimal)

The 95% confidence interval is (to 1 decimal)

to

M Your ans X Course H X Course H X Course H x Course H X [ Chicago X C @ about:blank G Excel template v Search (Alt + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Editing Comments A" A aD Wrap Text LIX _ AutoSum G AY O Arial Copy E Clear v Paste Conditional Format As Styles Insert Delete Format Sort & Find & BIUDYA. Merge & Center $ ~ % 9 78 Filter Select v Format Painter Formatting v Table v Undo Clipboard Font Alignment Number Tables Cells Editing D4 v fx A B C D E F G H I J K L M N Sample Data Interval Estimate of a Population Mean: Formula Used 13 Sigma Unknown Case 6 17 Sample Size #N/A 14 Mean #N/A 13 8 Standard Deviation #N/A 18 Confidence Coefficient 0.95 4 Level of Significance #N/A Margin of Error #N/A Point Estimate #N/A C.I. Lower Limit #N/A 15 C.I. Upper Limit #N/A 16 17 18 19 20 21 > E A Sheet1 + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% + 6 1 8:44