Question

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

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

Homework Answers

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)

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The mean work week for engineers in a start-up company is believed to be about 62...
The mean work week for engineers in a start-up company is believed to be about 62 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 conclude at the 5% significance level that the mean work week is shorter than 62 hours?Data (length of mean work week): 70; 50; 55; 60; 65; 55; 55; 60; 50; 55.
Using TI 83 Calculator Only Show All Steps 1. The average work week for engineers in...
Using TI 83 Calculator Only Show All Steps 1. The average 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 10 engineering friends in start-ups for the lengths of their average work weeks. Based on the results that follow, should she count on the average work week to be shorter than 60 hours? Data (length of average work week): 70; 45; 55; 60; 65;...
The average work week for engineers in a start-up company is believed to be about 60...
The average 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 10 engineering friends in start-ups for the lengths of their average work weeks. Based on the results that follow, should she count on the average work week to be shorter than 60 hours? Conduct a hypothesis test at the 5% level. Data (length of average work week): 70; 45; 55; 60; 65; 60;...
The mean work week for engineers in a start-up company is believed to be about 60...
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 10 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? Conduct a hypothesis test at the 5% level. Data (length of average work week): 70; 50; 55; 65; 65; 55;...
The work week for adults in the US that work full time is normally distributed with...
The work week for adults in the US that work full time is normally distributed with a mean of 47 hours. A newly hired engineer at a start-up company believes that employees at start-up companies work more on average then most working adults in the US. She asks 12 engineering friends at start-ups for the lengths in hours of their work week. Their responses are shown in the table below. Test the claim using a 10% level of significance. Give...
The workweek for adults in the US that work full time is normally distributed with a...
The workweek for adults in the US that work full time is normally distributed with a mean of 47 hours. A newly hired engineer at a start-up company believes that employees at start-up companies work more on average then working adults in the US. She asks 15 engineering friends at start-ups for the lengths in hours of their workweek. Their responses are shown in the table below. Test the claim using a 5% level of significance. See Excel for Data....
he work week for adults in the US that work full time is normally distributed with...
he work week for adults in the US that work full time is normally distributed with a mean of 47 hours. A newly hired engineer at a start-up company believes that employees at start-up companies work more on average then most working adults in the US. She asks 12 engineering friends at start-ups for the lengths in hours of their work week. Their responses are shown in the table below. Test the claim using a 10% level of significance. Give...
The work week for adults in the US that work full time is normally distributed with...
The work week for adults in the US that work full time is normally distributed with a mean of 47 hours. A newly hired engineer at a start-up company believes that employees at start-up companies work more on average then most working adults in the US. She asks 12 engineering friends at start-ups for the lengths in hours of their work week. Their responses are shown in the table below. Test the claim using a 1% level of significance. Give...
INTRO NewForm IT is a seven-year-old IT consulting company founded in 2012 that provides services to...
INTRO NewForm IT is a seven-year-old IT consulting company founded in 2012 that provides services to small businesses in their local and regional area. NewForm employs 83 people, 61 of whom are IT professionals/ consultants. NewForm is struggling financially; it has not met its revenue projections in the last five quarters. NewForm has suffered excessive leadership turnover in the past three years. The original founders sold NewForm in 2015; one of them, James Stanton, remained on as CHRO but sold...
INTRO NewForm IT is a seven-year-old IT consulting company founded in 2012 that provides services to...
INTRO NewForm IT is a seven-year-old IT consulting company founded in 2012 that provides services to small businesses in their local and regional area. NewForm employs 83 people, 61 of whom are IT professionals/ consultants. NewForm is struggling financially; it has not met its revenue projections in the last five quarters. NewForm has suffered excessive leadership turnover in the past three years. The original founders sold NewForm in 2015; one of them, James Stanton, remained on as CHRO but sold...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT