Bundle: Modern Business Statistics With Microsoft Excel, Loose-leaf Version, 5th + Aplia, 2 Terms Printed Access Card
Bundle: Modern Business Statistics With Microsoft Excel, Loose-leaf Version, 5th + Aplia, 2 Terms Printed Access Card
5th Edition
ISBN: 9781337367615
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:

Bundle: Modern Business Statistics With Microsoft Excel, Loose-leaf Version, 5th + Aplia, 2 Terms Printed Access Card, 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

Bundle: Modern Business Statistics With Microsoft Excel, Loose-leaf Version, 5th + Aplia, 2 Terms Printed Access Card

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