One important consideration in determining which location is best for a new retail business is the amount of traffic that passes the location each business day. Counters are placed at each of four locations on the five weekdays, and the number of cars passing each location is recorded in the table below. At 0.05 level of significance, is there sufficient evidence of a significant difference in the mean number of cars per day at the four locations?Using MS Excel,what is the computed value of the F statistic ? Location III IV 45 48 44 39 50 60 50 49 39 40 38 39 44 45 42 40 42 43 44 43

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.3: Measures Of Spread
Problem 1GP
icon
Related questions
Question
One important consideration in determining which location is best for a
new retail business is the amount of traffic that passes the location each
business day. Counters are placed at each of four locations on the five
weekdays, and the number of cars passing each location is recorded in
the table below. At 0.05 level of significance, is there sufficient evidence
of a significant difference in the mean number of cars per day at the four
locations?Using MS Excel,what is the computed value of the F statistic ? *
Location
II
II
IV
45
48
44
39
50
60
50
49
39
40
38
39
44
45
42
40
42
43
44
43
0.76
2.23
1.19
0.84
Transcribed Image Text:One important consideration in determining which location is best for a new retail business is the amount of traffic that passes the location each business day. Counters are placed at each of four locations on the five weekdays, and the number of cars passing each location is recorded in the table below. At 0.05 level of significance, is there sufficient evidence of a significant difference in the mean number of cars per day at the four locations?Using MS Excel,what is the computed value of the F statistic ? * Location II II IV 45 48 44 39 50 60 50 49 39 40 38 39 44 45 42 40 42 43 44 43 0.76 2.23 1.19 0.84
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill