Consider the data contained in the Excel worksheet named Cell Phones. This data set contains monthly phone bills (in dollars) for a random sample of 50 cell phone users.

a. Use the data set to conduct a one sample t-test to determine whether the expected bill amount equals $65 or is greater than $65. What is the p-value associated with the test?

b. Construct a 95% confidence interval on expected bill amount.

c. Do the data provide sufficient evidence to reject the claim that the expected monthly phone bill amount is $65? Explain.

d. Assess the normality of the data and comment on whether or not the one sample test is appropriate for this problem.

Data: 41.72, 69.04, 98.13, 128.82, 60.31, 39.66, 74.31, 79.97, 64.75, 46.89, 142.38, 30.70, 58.65, 44.14, 56.11, 78.35, 73.58, 54.67, 92.01, 87.17, 87.93, 60.40, 101.19, 88.34, 168.69, 101.72, 105.10, 71.42, 44.66, 61.56, 53.77, 57.55, 85.14, 57.69, 51.25, 60.75, 66.27, 80.90, 50.23, 78.34, 72.05, 111.45, 65.07, 66.88, 46.53, 43.17, 78.15, 64.24, 83.62, 51.29