help with Hypothesis testing question
I'm a little lost on how to do this problem. Would someone please help me
In a British study, 12 healthy college students deprived of one night’s sleep, received an array of tests intended to measure thinking time, fluency, flexibility and originality of thought. The overall test scores of the sleep-deprived students were compared to the average score expected from students who received their accustomed sleep (
Sleep, Jan 1989). Suppose the overall scores of the 12 sleep-deprived students had a mean of 63 and a standard deviation of 17. (Lower scores are associated with a decreased ability to think creatively).
a)Test the hypothesis that the true mean score of sleep-deprived subjects is less than 80, the mean score of subjects who received sleep prior to taking the test.Use α = 0.05
and what function do I use in Excel to find the P-value for this test.
Also what assumption is required for the hypothesis test of part a) to be valid?