Question

The following Excel table is the result of a study by MBA students to see if...

The following Excel table is the result of a study by MBA students to see if the average commuting times from suburbs to down town Chicago is any different in the winter. At the .05 level of significance, can it be concluded that the commuting times are different in the winter?

                       

Winter

Spring , Summer, Fall

Mean

38.2 minutes

32.5 minutes

Known Variance

82.81

51.84

Observations

40

40

Hypothesized Mean Difference

0

0

Z

4.50

P(Z<=z) One-tail

.004

Z Critical one-tail

1.645

P(Z<=z) Two-tail

.008

Z Critical two-tail

1.96

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Claim: The commuting times are different in the winter.

The null and alternative hypothesis is

H0: The commuting times are the same in the winter.

H1: The commuting times are different in the winter.

Level of significance = 0.05

Our hypothesis is a two-tailed test.

P-value = 0.008 ( Using result)

P-value < 0.05 we reject null hypothesis.

Conclusion: The commuting times are different in the winter.

Add a comment
Know the answer?
Add Answer to:
The following Excel table is the result of a study by MBA students to see if...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Hi, See the data set below. Based on this, Excel comes with the following analysis (paired diffe...

    Hi, See the data set below. Based on this, Excel comes with the following analysis (paired difference). I need to calculate a 95% confidence interval. Based on this, I came to the following formula: [Mean of the difference (D-mean) +/ t(alpha/2) * Sd / sqrt(n)]. I can fill in the following information: D-mean = 27-34 = -7. t(alpha/2) = 2,262 sqrt(n) = sqrt(10) Do you now how I can find the standard deviation of the sample? (Sd) I think it...

  • Please m asking for assistance on statistics Q10. A population consists of the following N-5 scores:...

    Please m asking for assistance on statistics Q10. A population consists of the following N-5 scores: 0, 6, 4, 3, and 12 a. Compute u ando for the population b. Find the 2-score for each score in the population c. Transform the original population into a new population of N = 5 scores with a mean of u = 100 and a standard deviation of a = 20 Q11. For a sample with a mean of M = 51, a...

  • STA2221 examples on CI & Testing of Hypothesis Name MULTIPLE CHOICE. Choose the one alternative that...

    STA2221 examples on CI & Testing of Hypothesis Name MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answer the question Provide an appropriate response. 1) Find the critical value,te for 0.99 and n-10. A) 3.250 B) 3.169 1.833 D) 2.262 2) Find the critical value to forc=0.95 and n=16. A) 2.947 B) 2.602 2120 D) 2.131 3) Find the value of E, the margin of error, for A) 1.69 B) 0.42 0.99, n=16 and s=2.6. C)...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT