Question: Hey I need help with my excel statistic works, I need the excel formulas and answer please and thank you. A B D E F
Hey I need help with my excel statistic works, I need the excel formulas and answer please and thank you.

A B D E F G H K L M N P This test has five questions. Each question has a separate tab at the bottom of the page. Question 1 This question is on two pages with 4 parts. A random sample of 100 U.S. college students had a mean age of 22.68 years. Assume the population standard deviation is o = 4.74 years. 1) In constructing a confidence interval for the mean age of students would you use the normal distribution or the t-distribution to compute the critical value for the margin of error computation? Explain your reasoning below. 2) Construct a 99% confidence interval for the mean age of students using the critical value method. You will need to compute the following. Put your answers in the yellow cells. Be sure to include a one-sentence interpretation of your results. z ort value Standard Error Margin of Error lower bound upper bound Interpretation
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
