TextRequest reports that adults 18-24 years old send and receive 128 texts every day. Suppose we take a sample of 25-34-year-olds to see if their mean number of daily texts differs from the mean for 18-24-year-olds reported by TextRequest.

On the basis of above information, answer the following questions:

Please tell me how to solve the question in Excel, and show me how the answer looks in Excel.

Qs. 1 State the null and alternative hypotheses we should use to test whether the popu-lation mean daily number of texts for 25-34 year olds differs from the population daily mean number of texts for 18-24 year olds

Hint: Will it be a upper one tailed, lower one tailed or a two tailed test? Your research hypothesis should be in the alternative hypothesis.

Qs. 2 Suppose a sample of thirty 25-34 year olds showed a sample mean of 118.6 texts per day. Assume a population standard deviation of 33.17 texts per day and compute the p-value.

Hint: You are given the population mean in the question set up. For this part, you also are given population standard deviation, sample mean and sample size. Compute the z-value= (sample mean -population mean) / (population standard deviation/square root of the sample size)

The relevant p-value calculation will depend on the alternative hypothesis--upper tailed value, lower tailed p-value and two tailed p-value should be calculated using NORM.S.DIST(z-value, TRUE)

Qs. 3 Using a .05 level of significance, what is your conclusion?

Hint: Use Reject the null hypothesis if p-value< level of significance, otherwise do not reject the null.