Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

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

/in /by

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

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"