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!

Chapter 13 Solutions

Modern Business Statistics with Microsoft Excel (MindTap Course List)

Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
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
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill