I just need help setting it up so I can figure out the answer. Any help would be appreciated. You can even change the numbers if you want. I just need to be shown how to it so I can figure it out for the other problems myself. Examples of how to do it in excel would be appreciated as well.

Using the 8-step hypothesis test, showing all calculations, solve the following, provide both the critical value method and the p-value method in your calculations.

It has been reported that the mean amount of sleep that adults receive is 7 hours per night. Your boss has asked you to look into this statistic by running your own study. You gather 49 adults and find the following information. The mean amount of sleep was 6.2 hours with a standard deviation of 1.8 hours. Based on your results, you claim that adults receive less than 7 hours of sleep. Test your claim with a 0.05 significance level.