Question

Hi, I would like to know how to solve this stats question using only Excel.

The mean work week for engineers in a start-up company is believed to be about 60 hours. A newly hired engineer hopes that it’s shorter. She asks ten engineering friends in start-ups for the lengths of their mean work weeks. Based on the results that follow, should she count on the mean work week to be shorter than 60 hours?

Data (length of mean work week): 70; 45; 55; 60; 65; 55; 55; 60; 50; 55.

1. What is the test statistic?

2. What is the p-value? If your answer is less than .01, write 0.

3. Do we reject the null hypothesis at α=.05?

   A.

   Yes

   B.

   No

Answer 1

from above

test statistic t =-1.3270

p valie =0.1086

Do we reject the null hypothesis at α=.05 :no (since p value >0.05)