Suppose the 20 people who have made clinic visits as represented on the visit sheet of Chpt 3-1.xls, 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 hyposthesis at the 95 percent level of confidence that the average visit time for the population is 37 minutes (H0: VT=37) against the alternative hypothesis that the visit time is not 37 minutes (H1=37, and state your conclusion

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

C) Test the null hypothesis at the 95 percent 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 percent level of confidence, and state your conclusion

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