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 12, Problem 25SE

In 2011, the industries with the most complaints to the Better Business Bureau were banks, cable and satellite television companies, collection agencies, cellular phone providers, and new car dealerships (USA Today, April 16, 2012). The results for a sample of 200 complaints are contained in the DATAfile named BBB.

  1. a. Construct a frequency distribution for the number of complaints by industry.
  2. b. Using α = .01, conduct a hypothesis test to determine whether the probability of a complaint is the same for the five industries. What is your conclusion?
  3. c. Drop the industry with the most complaints. Using α = .05, conduct a hypothesis test to determine whether the probability of a complaint is the same for the remaining four industries.

a.

Expert Solution
Check Mark
To determine

Construct a frequency distribution for the number of complaints by industry.

Answer to Problem 25SE

The frequency distribution for the number of complaints by industry is tabulated as follows:

CategoryObserved Frequency
Bank26
Cable44
Car42
Cell60
Collection28

Explanation of Solution

Calculation:

The given data show the results for a sample of 200 complaints.

From the given data, it can be observed that the number of categories is 4. The frequencies for bank, cable, car, cell, and collection are 26, 44, 42, 60, and 28, respectively.

Therefore, the frequency distribution for the number of complaints by industry is tabulated as follows:

CategoryObserved Frequency
Bank26
Cable44
Car42
Cell60
Collection28

b.

Expert Solution
Check Mark
To determine

Perform a hypothesis test at 0.01 level of significance.

Draw conclusion.

Answer to Problem 25SE

The conclusion is that the probability of a complaint is not the same for the five industries.

Explanation of Solution

Calculation:

State the test hypotheses:

Null hypothesis:

 H0:p1=p2=p3=p4=p5.

That is, all population proportions are equal for five museums.

Alternative hypothesis:

 Ha:not all population proportions are equal.

That is, not all population proportions are equal for five industries.

The formula for chi-square test statistic is as follows:

χ2=i(fiei)2ei.

Here, ei is the expected frequency and fi is the observed frequency for ith observation.

In this case, it is observed that the probability of a complaint is the same for each of the five industries. That is, 0.2 (=15).

The expected frequency is obtained as follows:

Expected frequency=Sum of actual frequencies× Probability value=(26+44+42+60+28)×0.20=200×0.20=40

The value of χ2 is obtained as follows:

Observed Frequency (fi)Expected Frequency (ei)fiei(fiei)2ei
2640–144.9
444040.4
424020.1
60402010
2840–123.6
Total  χ2=19

Thus, the value of χ2 is 19.

Degrees of freedom:

The degrees of freedom is df=k1, where k is the number of categories.

df=k1=51=4

Thus, the degree of freedom is 4.

Level of significance:

The given level of significance is α=0.01.

p-value:

Software procedure:

Step-by-step software procedure to obtain p-value using EXCEL:

  • Open an EXCEL sheet and select cell A1.
  • In cell A1, enter the formula =CHISQ.DIST.RT(19,4).
  • Press Enter.

The output obtained using EXCEL is given below:

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List), Chapter 12, Problem 25SE , additional homework tip  1

From the output, the p-value is 0.0008.

Rejection rule:

  • If the p-valueα, then reject the null hypothesis.
  • Otherwise, do not reject the null hypothesis.

Conclusion:

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

That is, p-value(=0.0008)<α(=0.01)

Thus, the decision is “reject the null hypothesis”.

Therefore, there is sufficient evidence to conclude that the probability of a complaint is not the same for the five industries.

c.

Expert Solution
Check Mark
To determine

Drop the industry with the most complaints and perform a hypothesis test at 0.05 level of significance.

Answer to Problem 25SE

The conclusion is that the probability of a complaint is the same for the remaining four industries.

Explanation of Solution

Calculation:

From Part (a), it can be observed that the category cell has more complaints. Therefore, drop the category cell.

State the test hypotheses:

Null hypothesis:

 H0:p1=p2=p3=p4.

That is, all population proportions are equal for five museums.

Alternative hypothesis:

 Ha:not all population proportions are equal.

That is, not all population proportions are equal for the remaining four industries.

The formula for chi-square test statistic is as follows:

χ2=i(fiei)2ei.

Here, ei is the expected frequency and fi is the observed frequency for ith observation.

In this case, it is observed that the probability of a complaint is the same for each of the four industries. That is, 0.25 (=14).

The expected frequency is obtained as follows:

Expected frequency=Sum of actual frequencies× Probability value=(26+44+42+28)×0.25=140×0.25=35

The value of χ2 is obtained as follows:

Observed Frequency (fi)Expected Frequency (ei)fiei(fiei)2ei
2635–92.31
443592.31
423571.4
2835–71.4
Total  χ2=7.42

Thus, the value of χ2 is 7.42.

Degrees of freedom:

The degrees of freedom is df=k1, where k is the number of categories.

df=k1=41=3

Thus, the degree of freedom is 3.

Level of significance:

The given level of significance is α=0.05.

p-value:

Software procedure:

Step-by-step software procedure to obtain p-value using EXCEL:

  • Open an EXCEL sheet and select cell A1.
  • In cell A1, enter the formula =CHISQ.DIST.RT(7.42,3).
  • Press Enter.

The output using EXCEL is given below:

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List), Chapter 12, Problem 25SE , additional homework tip  2

From the output, the p-value is 0.0596.

Rejection rule:

  • If the p-valueα, then reject the null hypothesis.
  • Otherwise, do not reject the null hypothesis.

Conclusion:

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

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

Thus, the decision is “reject the null hypothesis”.

Therefore, there is no sufficient evidence to conclude that the probability of a complaint is not the same for the remaining four industries.

Therefore, the conclusion is that the probability of a complaint is the same for the remaining four industries.

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
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…
Name 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…

Chapter 12 Solutions

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)

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
Text book image
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
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
College Algebra
Algebra
ISBN:9781938168383
Author:Jay Abramson
Publisher:OpenStax
Statistics 4.1 Point Estimators; Author: Dr. Jack L. Jackson II;https://www.youtube.com/watch?v=2MrI0J8XCEE;License: Standard YouTube License, CC-BY
Statistics 101: Point Estimators; Author: Brandon Foltz;https://www.youtube.com/watch?v=4v41z3HwLaM;License: Standard YouTube License, CC-BY
Central limit theorem; Author: 365 Data Science;https://www.youtube.com/watch?v=b5xQmk9veZ4;License: Standard YouTube License, CC-BY
Point Estimate Definition & Example; Author: Prof. Essa;https://www.youtube.com/watch?v=OTVwtvQmSn0;License: Standard Youtube License
Point Estimation; Author: Vamsidhar Ambatipudi;https://www.youtube.com/watch?v=flqhlM2bZWc;License: Standard Youtube License