Using Excel Please: ( with formulas shown)

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

A B C D E F G H ID Age Sex Opinion 1 Opinion 2 Charges Visit Time Insurance Prior 33 F 3 $ 58.00 40 Self Pay 21 F 3 $ 59.00 44 Medicaid + O N - 56 F 3 $ 78.00 51 Medicaid 53 M 4 $ 24.00 36 BCBS 7 . 51 F 4 $ 46.00 55 Private 6 22 F 5 $ 30.00 21 BCBS 7 62 F 1 $114.00 33 BCBS 8 39 F 2 $ 51.00 43 BCBS 9 60 F 6 $ 100.00 34 Private 10 61 F 4 $ 45.00 59 Private 11 65 M 3 $ 55.00 24 Private + U - K O O O + O N O + + O NO NO- WON 12 60 F $ 36.00 63 Medicaid 4 13 61 M + W - WON NO $ 62.00 31 Self Pay 14 28 F $ 100.00 25 Self Pay 6 15 54 F 3 $111.00 48 Self Pay 16 64 F 4 $ 59.00 44 Medicaid 17 44 F 2 $ 45.00 57 BCBS 9 18 25 F 3 $ 68.00 43 Private 19 35 M 1 $ 95.00 45 Private 20 32 F 5 3 $ 92.00 33 Private 2