6-13. From a sample of 22 graduate students, the mean number of months of work experience prior to entering an MBA program was 34.86. The national standard deviation is known to be 19 months. What is a 95% confidence interval for the population mean? Compute the confidence interval using the appropriate formula and verify your results using the Excel Confidence Intervals template.

Please show how to do in excel

Population Standard Deviation, o 19 Sample size (n) 22 Sample mean, x 34.86 Hint: Use the formula below & Table A.1 P. 633 - 634 Find 95% Confidence Interval for Mean Upper Limit O (Specify formulas for upper & lower limits in cells C7 & C8) Lower Limit x I za (They should match the values in B21 & B20 below.) N 8 Confidence Interval for Population Mean, Standard Deviation Known (TEMPLATE) Alpha 0.05 Standard deviation 19 Sample size 22 Sample average 34.86 Confidence Interval 95% Error 7.94 Lower 26.92 Upper 42.80