Thank you for your answer, but how do I put this into Excel to achieve the same output?

Using Excel Please:

Suppose the 20 people who have made clinic visits as represented on the visits sheet below are considered to be a random sample of all the people who have ever come or will ever come to the clinic in question.

A) Test the null hypothesis at the 95% level of confidence at the average visits time for the population is 37 minutes (H0: VT =37) against the alternative hypothesis that the visit time is not 37 minutes (1: VT /= 37) and state your conclusion.

B) Test the same hypothesis at the 99% level of confidence and state your conclusion

C) Test the null hypothesis at the 95% level of confidence that average charges for the population is $75 (H0: C= $75) against the alternative hypothesis that charges is not $75 (H1: C =/75$) and state your conclusion

D) Test the same hypothesis at the 99% level of confidence and state your conclusion

Data is attached.

• Download Attachments:
• Chpt 03-1.xls
• Comment
• Flag Question

Subject:

• Statistics and Probability

Course: HIMS 650

• $8.00
• Due in 4 hours 18 minutes

1 Answer

• BestAnswer?a) sample mean = 40.95std = 11.1425t test statistic = xbar - u /std/sqrt(19) = 1.54, t alpha = 2.09,then we accept H0 at5% levelb) t test statistic = 1.54, t alpha = 2.54, then we accept H0c)t test statistic = xbar - u /std/sqrt(19) = 1.45, t alpha = 2.09,then we accept H0 at5% leveld)t test statistic = 56.93, t alpha = 1.45, then we accept H0