PROVIDE ALL EXCEL FORMULAS USED TO SOLVE THIS PROBLEM! AND STEPS TO SOLVE THIS PROBLEM AS WELL! THANK YOU!

3. Using the data from the 'Data' tab in this workbook, construct a99%confidence interval for the population mean. Assume that your data is normally distributed and ? is unknown. Include a statement that correctly interprets the confidence interval in context of the scenario.

Hint: Use the sample mean and sample standard deviation from Deliverable 1. Use cell referencing to use the unrounded values.

SAMPLE MEAN AND STANDARD DEVIATION FROM DELIVARABLE 1

Calculations/Values Formulas/Answers Mean Standard Deviation n Critical Value Margin of Error Lower Limit Upper Limitsource: http://www.bis.gov/ Excell Formulas Here Calculations Formulas/Answers Mean 71999.27473 Median 67095 Mode 73870