Modern Business Statistics with Microsoft Excel (MindTap Course List)
Modern Business Statistics with Microsoft Excel (MindTap Course List)
5th Edition
ISBN: 9781285433301
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams
Publisher: Cengage Learning
Question
Book Icon
Chapter 13, Problem 36SE
To determine

Check whether there is any difference in the mean ozone level among the four cities at the α=0.05 level of significance.

Expert Solution & Answer
Check Mark

Answer to Problem 36SE

There is no sufficient evidence to conclude that there is a significant difference in the mean ozone level among the four cities at the α=0.05 level of significance.

Explanation of Solution

Calculation:

The data represent the levels of ozone pollution in four cities for 10 dates from last year.

Denote treatment means as city and block means as dates.

State the hypotheses:

For treatments

Null hypothesis:

H0T: There is no significant difference among the treatment means.

Alternative hypothesis:

HaT: There is a significant difference among the treatment means.

For Blocks

Null hypothesis:

H0B: There is no significant difference among the block means.

Alternative hypothesis:

HaB: There is a significant difference among the block means.

There are 4 cities (Treatments) and 10 dates from which the data was collected (Blocks). The level of significance is 0.05.

Randomized block design:

Software procedure:

Step-by-step procedure to obtain the randomized block design using the EXCEL:

  • Open new EXCEL worksheet.
  • Enter the data values in the EXCEL sheet.
  • On Data tab in Analysis group, click Data Analysis.
  • Select Anova: Two-Factor Without Replication.
  • Click Ok.
  • Click in the Input Range box, select the range $A$1: $E$11.
  • Select Labels and Enter Alpha as 0.05.
  • Click in the Output range, select $G$1.
  • Click OK.

Output obtained using the EXCEL software is given below:

Modern Business Statistics with Microsoft Excel (MindTap Course List), Chapter 13, Problem 36SE

From the EXCEL output, the F-ratio for treatments (city) is 2.42 and the p-value is 0.088. The F-ratio for blocks (Date) is 4.55 and the p-value is 0.001.

Decision:

If p-valueα,, reject the null hypothesis H0

If p-value>α, fail to reject the null hypothesis H0

Conclusion:

Here, the p-value of treatments is greater than the level of significance.

That is, p-value(=0.088)>α(=0.05).

Therefore, the null hypothesis of treatments is not rejected.

Thus, there is no sufficient evidence to conclude that there is a significant difference in the mean ozone level among the four cities at the α=0.05 level of significance.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Stem1: 1,4 Stem 2: 2,4,8 Stem3: 2,4 Stem4: 0,1,6,8 Stem5: 0,1,2,3,9 Stem 6: 2,2 What’s the Min,Q1, Med,Q3,Max?
Are the t-statistics here greater than 1.96? What do you conclude?   colgPA= 1.39+0.412 hsGPA                (.33)      (0.094)   Find the P value
A poll before the elections showed that in a given sample 79% of people vote for candidate C. How many people should be interviewed so that the pollsters can be 99% sure that from 75% to 83% of the population will vote for candidate C? Round your answer to the whole number.

Chapter 13 Solutions

Modern Business Statistics with Microsoft Excel (MindTap Course List)

Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Text book image
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781305652224
Author:Charles P. McKeague, Mark D. Turner
Publisher:Cengage Learning