(I) Excel coding question:

1) (5 points)The average cost of a hotel room in New York is said to be $168 per

night. To determine if this is true, a random sample of 200 hotels is taken and

resulted in a sample mean of $172.50 and an S of $15.40. Test the appropriate

hypotheses at = 0.05.

a. Please write Excel coding to complete this Hypothesis test using T approach.

b. Please write Excel coding to complete this Hypothesis test using P approach. Write

a complete coding, no calculation is needed.

2) (5 points) A marketing company claims that it receives 8% responses from its

mailing. To test this claim, a random sample of 500 were surveyed with 25

responses. Test at the = 0.05 significance level by the following coding:

H0: = 0.08

H1: 0.08

Z* = -2.47

=if (normsinv(Z*)