Based on the Excel output, what conclusion can the researcher arrive?

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 10CYU
icon
Related questions
icon
Concept explainers
Topic Video
Question

Suppose a researcher is interested determining whether on average, driving times on the major traffic routes are approximately the same. The following data are randomly collected from three major traffic routes.The entries in the table are drivings times in minutes on the these routes.

 

Route 1 Route 2 Route 3
45 39 41
42 40 40
46 39 41
43 40 42
43 39 43
43 39 43
43 41 40
43 38 40
48 41 41
45 39 43
  39 40
  39 40
  46 43
  40 41
  40 42
    40
    40
    46
    46
    41

 

A One-Way ANOVA test was conducted at a 0.02 level of significance. The results are shown below.

Note that some values in the table might be in scientific notation. Say, 1.65E-07 means 1.65x10-7 or 0.000000165.

ANOVA: Single Factor

SUMMARY        
Groups Count Sum Average Variance
Route 1 10 441 44.100 3.433333
Route 2 15 599 39.933 3.495238
Route 3 20 833 41.650 3.502632



ANOVA
Source of Variation SS df MS F P-value F crit
Between Groups 104.19444 2 52.09722 14.9476 0.00001 4.30012
Within Groups 146.38333 42 3.48532    

Total 250.57778 44        



Based on the Excel output, what conclusion can the researcher arrive?

 

  • For 0.02 level of significance the ANOVA test shows the sample means and the sample variances, but fails to answer the question whether different traffic routes affect the average driving times. Probably, the researcher should increase the sample sizes.
  • At the 0.02 level of significance, the sample data support the claim that there is a difference in the average driving times. On average,the driving times on the major traffic routes are not the same.
  • For 0.02 level of significance the ANOVA test is unable to give positive or a negative answer to the question whether different traffic routes affect the average driving times. The question needs futher investigation.
  • At the 0.02 level of significance,there is not sufficient sample evidence to support the claim that there is a difference in the average driving times. On average, the driving times are approximately the same.
  • None of the above
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Sample space, Events, and Basic Rules of Probability
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL