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!
Students have asked these similar questions
https://www.hawkeslearning.com/Statistics/dbs2/datasets.html
NC Current Students - North Ce X | NC Canvas Login Links - North ( X Final Exam Comprehensive x Cengage Learning x WASTAT - Final Exam - STAT → C webassign.net/web/Student/Assignment-Responses/submit?dep=36055360&tags=autosave#question3659890_9 Part (b) Draw a scatter plot of the ordered pairs. N Life Expectancy Life Expectancy 80 70 600 50 40 30 20 10 Year of 1950 1970 1990 2010 Birth O Life Expectancy Part (c) 800 70 60 50 40 30 20 10 1950 1970 1990 W ALT 林 $ # 4 R J7 Year of 2010 Birth F6 4+ 80 70 60 50 40 30 20 10 Year of 1950 1970 1990 2010 Birth Life Expectancy Ox 800 70 60 50 40 30 20 10 Year of 1950 1970 1990 2010 Birth hp P.B. KA & 7 80 % 5 H A B F10 711 N M K 744 PRT SC ALT CTRL
Harvard University California Institute of Technology Massachusetts Institute of Technology Stanford University Princeton University University of Cambridge University of Oxford University of California, Berkeley Imperial College London Yale University University of California, Los Angeles University of Chicago Johns Hopkins University Cornell University ETH Zurich University of Michigan University of Toronto Columbia University University of Pennsylvania Carnegie Mellon University University of Hong Kong University College London University of Washington Duke University Northwestern University University of Tokyo Georgia Institute of Technology Pohang University of Science and Technology University of California, Santa Barbara University of British Columbia University of North Carolina at Chapel Hill University of California, San Diego University of Illinois at Urbana-Champaign National University of Singapore McGill…

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.
Similar questions
SEE MORE QUESTIONS
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