cument, click Duplicate. 18 2. (t Test (in Excel) for Two Samples with Equal Variances) Amy has two ways to travel from her home in Norco to her office in Los Angeles. One is to go via the 10 Freeway, and the other is to go via the 60 Freeway. In order to determine which way she should travel on a daily basis, Amy has recorded the travel times for samples of fifteen trips via the 10 Freeway and fifteen trips via the 60 Freeway. The following table gives the travel times (in minutes) for the thirty trips: 10 Freeway 60 Freeway Travel times in minutes 74, 68, 75, 73, 73, 73, 69, 72, 70, 77, 67, 71, 74, 71, 71 Assume that the two populations of travel times are normally distributed and that the population variances are equal. Can we conclude, at the 0.075 level of significance, that the mean travel time via the 10 Freeway is less than the mean travel time via the 60 Freeway? Use Excel to perform the hypothesis test. 75, 69, 73, 70, 78, 74, 78, 70, 74, 71, 76, 74, 75, 77, 70 a. State the null and alternate hypotheses that would be appropriate for this hypothesis test. Use proper notation and formatting. b. Give the value of the test statistic. Round to three decimal places if needed. c. Give the p-value of the test statistic. Round to four decimal places if needed. d. Using the p-value method, should Ho be rejected at the a= 0.075 level of significance? Why or why not? ii. e. Choose an appropriate conclusion based on your decision in part d. i. United States) Accessibility: Investigate The mean travel times via the 10 Freeway is less than the mean travel time via the 60 Freeway. There is not enough evidence to conclude that the mean travel via the 10 Freeway is less than the mean travel time via the 60 Freeway. Focus FO

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
AutoSave OFF
Home Insert Draw Design
Paste
B
Page 2 of 4
I
Layout
A A Aav
References
✓ A ✓ A v
X Read Only To save a copy of this document, click Duplicate.
1115 words English (United States)
18
W Using Excel for Hypothesis Testing with Two Means - Read-Only - Saved to my Mac
Mailings
=
Review
V
10 Freeway
V
60 Freeway
View
Tell me
A
E✓ ✓
2. (t Test (in Excel) for Two Samples with Equal Variances) Amy has two ways to travel from her home in
Norco to her office in Los Angeles. One is to go via the 10 Freeway, and the other is to go via the 60
Freeway. In order to determine which way she should travel on a daily basis, Amy has recorded the travel
times for samples of fifteen trips via the 10 Freeway and fifteen trips via the 60 Freeway. The following
table gives the travel times (in minutes) for the thirty trips:
AaBbCcDdEe
i.
Normal
ii.
Accessibility: Investigate
AaBb CcDdEe
No Spacing
Travel times in minutes
74, 68, 75, 73, 73, 73, 69, 72, 70, 77, 67, 71, 74, 71, 71
Assume that the two populations of travel times are normally distributed and that the population variances
are equal. Can we conclude, at the 0.075 level of significance, that the mean travel time via the 10 Freeway
is less than the mean travel time via the 60 Freeway?
Use Excel to perform the hypothesis test.
75, 69, 73, 70, 78, 74, 78, 70, 74, 71, 76, 74, 75, 77, 70
a. State the null and alternate hypotheses that would be appropriate for this hypothesis test. Use proper
notation and formatting.
b. Give the value of the test statistic. Round to three decimal places if needed.
c. Give the p-value of the test statistic. Round to four decimal places if needed.
e. Choose an appropriate conclusion based on your decision in part d.
d. Using the p-value method, should Ho be rejected at the a = 0.075 level of significance? Why or why
not?
Aa BbCcDc AaBbCcDdEe AaBb AaBb CcDd Ee
Heading 1
Heading 2
Title
Subtitle
The mean travel times via the 10 Freeway is less than the mean travel time via the 60 Freeway.
There is not enough evidence to conclude that the mean travel via the 10 Freeway is less than the
mean travel time via the 60 Freeway.
Focus
Share
E
Styles
Pane
I
Viewing
Dictate
Comments
Editor
BOD
Duplicate
+ 100%
Transcribed Image Text:AutoSave OFF Home Insert Draw Design Paste B Page 2 of 4 I Layout A A Aav References ✓ A ✓ A v X Read Only To save a copy of this document, click Duplicate. 1115 words English (United States) 18 W Using Excel for Hypothesis Testing with Two Means - Read-Only - Saved to my Mac Mailings = Review V 10 Freeway V 60 Freeway View Tell me A E✓ ✓ 2. (t Test (in Excel) for Two Samples with Equal Variances) Amy has two ways to travel from her home in Norco to her office in Los Angeles. One is to go via the 10 Freeway, and the other is to go via the 60 Freeway. In order to determine which way she should travel on a daily basis, Amy has recorded the travel times for samples of fifteen trips via the 10 Freeway and fifteen trips via the 60 Freeway. The following table gives the travel times (in minutes) for the thirty trips: AaBbCcDdEe i. Normal ii. Accessibility: Investigate AaBb CcDdEe No Spacing Travel times in minutes 74, 68, 75, 73, 73, 73, 69, 72, 70, 77, 67, 71, 74, 71, 71 Assume that the two populations of travel times are normally distributed and that the population variances are equal. Can we conclude, at the 0.075 level of significance, that the mean travel time via the 10 Freeway is less than the mean travel time via the 60 Freeway? Use Excel to perform the hypothesis test. 75, 69, 73, 70, 78, 74, 78, 70, 74, 71, 76, 74, 75, 77, 70 a. State the null and alternate hypotheses that would be appropriate for this hypothesis test. Use proper notation and formatting. b. Give the value of the test statistic. Round to three decimal places if needed. c. Give the p-value of the test statistic. Round to four decimal places if needed. e. Choose an appropriate conclusion based on your decision in part d. d. Using the p-value method, should Ho be rejected at the a = 0.075 level of significance? Why or why not? Aa BbCcDc AaBbCcDdEe AaBb AaBb CcDd Ee Heading 1 Heading 2 Title Subtitle The mean travel times via the 10 Freeway is less than the mean travel time via the 60 Freeway. There is not enough evidence to conclude that the mean travel via the 10 Freeway is less than the mean travel time via the 60 Freeway. Focus Share E Styles Pane I Viewing Dictate Comments Editor BOD Duplicate + 100%
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
  1. Using the p-value method, should be rejected at the  level of significance?  Why or why not? 
Solution
Bartleby Expert
SEE SOLUTION
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman