Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 13, Problem 34SE

In a completely randomized experimental design, three brands of paper towels were tested for their ability to absorb water. Equal-size towels were used, with four sections of towels tested per brand. The absorbency rating data follow. At a .05 level of significance, does there appear to be a difference in the ability of the brands to absorb water?

Chapter 13, Problem 34SE, In a completely randomized experimental design, three brands of paper towels were tested for their

Expert Solution & Answer
Check Mark
To determine

Check whether there is a significant difference in the ability of the brands to absorb water at α=0.05 level of significance.

Answer to Problem 34SE

Yes, there is a significant difference in the ability of the brands to absorb water.

Explanation of Solution

Calculation:

The data represent the absorbency rate for the three brands.

Assume that μ1, μ2, and μ3 denote the population means of three brands x, y, and z, respectively.

The test hypotheses are given below:

Null hypothesis:

H0:μ1=μ2=μ3

Alternative hypothesis:

Ha:At least one of the means is not equal.

It is given that the level of significance as 0.05.

One-way ANOVA:

Software procedure:

Step-by-step procedure to obtain one-way ANOVA using EXCEL:

  • Open the EXCEL.
  • Enter x, y, and z in different columns.
  • On Data tab in analysis group, click Data Analysis.
  • Select Anova: Single Factor.
  • Click OK.
  • Click in the Input Range box, select x, y, and z.
  • Click OK.

The output obtained using EXCEL software is shown below:

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List), Chapter 13, Problem 34SE

From the output, it is observed that the F-ratio is 7.23 and the p-value is 0.0134.

Decision:

If thep-valueα, reject the null hypothesis H0.

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

Conclusion:

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

That is, p-value(=0.0134)<α(=0.05).

Therefore, the null hypothesis is rejected.

Hence, there is sufficient evidence to infer that there is a significant difference in the ability of the brands to absorb water.

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 Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)

Ch. 13.2 - Four different paints are advertised as having the...Ch. 13.2 - Restaurant Satisfaction. The Consumer Reports...Ch. 13.3 - The following data are from a completely...Ch. 13.3 - Prob. 14ECh. 13.3 - Testing Chemical Processes. To test whether the...Ch. 13.3 - Prob. 16ECh. 13.3 - Marketing Ethics. In the digital age of marketing,...Ch. 13.3 - Prob. 18ECh. 13.3 - Prob. 19ECh. 13.3 - Minor league Baseball Attendance. The...Ch. 13.4 - Consider the experimental results for the...Ch. 13.4 - Prob. 22ECh. 13.4 - 23. An experiment has been conducted for four...Ch. 13.4 - Prob. 24ECh. 13.4 - The price drivers pay for gasoline often varies a...Ch. 13.4 - SAT Performance. The Scholastic Aptitude Test...Ch. 13.4 - A study reported in the Journal of the American...Ch. 13.5 - A factorial experiment involving two levels of...Ch. 13.5 - Prob. 29ECh. 13.5 - Prob. 30ECh. 13.5 - Amusement Park Queues. An amusement park studied...Ch. 13.5 - Prob. 32ECh. 13.5 - Prob. 33ECh. 13 - In a completely randomized experimental design,...Ch. 13 - Prob. 35SECh. 13 - Prob. 36SECh. 13 - Prob. 37SECh. 13 - Assembly Methods. Three different assembly methods...Ch. 13 - In a study conducted to investigate browsing...Ch. 13 - Fuel Efficiency of Gasoline Brands. A research...Ch. 13 - Late-Night Talk Show Viewership. Jimmy Kimmel...Ch. 13 - Prob. 42SECh. 13 - Prob. 43SECh. 13 - Prob. 44SECh. 13 - CASE PROBLEM 1: WENTWORTH MEDICAL CENTER As part...Ch. 13 - CASE PROBLEM 2: COMPENSATION FOR SALES...Ch. 13 - TOURISTOPIA TRAVEL TourisTopia Travel (Triple T)...
Knowledge Booster
Background pattern image
Statistics
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
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY