Deliverable 2.1- Confidence Intervals.xIsx - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW DEVELOPER ADD-INS NITRO PRO 10 PDFelement TEAM 1 Cut AutoSun Calibri - 11 AA E Be Wrap Text General BB Copy Fill - Paste BIU . - A. E Merge & Center - $ - % :08 Conditional Format as Cell Insert Delete Format Format Painter Formatting * Table Styles Clear Clipboard Font Alignment G Number Styles Cells 04 X v fx A B C D E F G H K L M N O P 2. Using the data from the 'Data' tab in this workbook, construct a 95% confidence interval for the population w mean. Assume that your data is normally distributed and o is unknown. Include a statement that correctly Calculations/Values Formulas/Answers interprets the confidence interval in context of the scenario. Mean 71999.27473 Hint: Use the sample mean and sample standard deviation from Deliverable 1. Do NOT copy and paste the values. Standard Deviation 22847.2573 Instead, use cell referencing to use the unrounded values. n 364 Calculate all of the values needed to create this confidence interval to the right. Critical Value LO CO Below, include a breakdown of the steps, include formulas, and correctly interpret the solution in context of the Margin of Error 10 scenario with the correct units. Lower Limit 11 Upper Limit 12 13 14 15 16 17 18 19 20 21 22 23