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.

Hey I need help with my excel statistic works, I need the

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!