Question

Please explain in manual written format and EXCEL function.

(note here that the null hypothesis improvement mean = 0)

11.         Previously, an organization reported that teenagers spent 4.5 hours per week, on average, on the phone. The organization thinks that currently the mean is higher. Fifteen randomly chosen teenagers were asked how many hours per week they spend on the phone. The sample mean was 4.75 hours with a sample standard deviation of 2.0. At a significance level of α = .05, what do you conclude about the claim?

1. Sufficient evidence to accept the claim (conclude) that the man number of hours is more than 4.75.
2. Sufficient evidence to accept the claim (conclude) that the mean number of hours is more than 4.5.
3. Insufficient evidence to accept the claim (conclude) that the mean number of hours is more than 4.5.
4. Insufficient evidence to accept the claim (conclude) that the mean number of hours is more than 4.75.

Answer 1