Gen Combo Ll Applied Statistics In Business & Economics; Connect Access Card
Gen Combo Ll Applied Statistics In Business & Economics; Connect Access Card
6th Edition
ISBN: 9781260260632
Author: David Doane, Lori Seward Senior Instructor of Operations Management
Publisher: McGraw-Hill Education
bartleby

Videos

Textbook Question
Book Icon
Chapter 15, Problem 40CE

Instructions: In all exercises, include software results (e.g., from Excel, MegaStat, or Minitab) to support your calculations. State the hypotheses, show how the degrees of freedom are calculated, find the critical value of chi-square from Appendix E or from Excel’s function =CHISQ.INV.RT(alpha, deg_freedom), calculate the chi-square test statistic, and interpret the p-value. Tell whether the conclusion is sensitive to the level of significance chosen, identify cells that contribute the most to the chi-square test statistic, and check for small expected frequencies. If necessary, you can calculate the p-value by using Excel’s function =CHISQ. DIST.RT(test statistic, deg freedom). Note: Exercises marked * are harder or require optional material.

Pick one Excel data set (A through F) and investigate whether the data could have come from a normal population using α = .01. Use any test you wish, including a histogram, or MegaStat’s Descriptive Statistics > Normal curve goodness of fit test, or Minitab’s Stats > Basic Statistics > Normality Test to obtain a probability plot with the Anderson-Darling statistic. Interpret the p-value from your tests. For larger data sets, only the first three and last three observations are shown.

Chapter 15, Problem 40CE, Instructions: In all exercises, include software results (e.g., from Excel, MegaStat, or Minitab) to , example  1

Source: www.wikipedia.org.

Chapter 15, Problem 40CE, Instructions: In all exercises, include software results (e.g., from Excel, MegaStat, or Minitab) to , example  2

Chapter 15, Problem 40CE, Instructions: In all exercises, include software results (e.g., from Excel, MegaStat, or Minitab) to , example  3

Source: Independent project by statistics student Frances Williams. Weighed on an American Scientific Model S/P 120 analytical balance, accurate to 0.0001 gram.

Chapter 15, Problem 40CE, Instructions: In all exercises, include software results (e.g., from Excel, MegaStat, or Minitab) to , example  4

Chapter 15, Problem 40CE, Instructions: In all exercises, include software results (e.g., from Excel, MegaStat, or Minitab) to , example  5

Source: www.wikipedia.org

Chapter 15, Problem 40CE, Instructions: In all exercises, include software results (e.g., from Excel, MegaStat, or Minitab) to , example  6

Expert Solution & Answer
Check Mark
To determine

State the null and alternative hypothesis.

Find the degrees of freedom.

Find the critical value of chi-square from Appendix E or from Excel’s function.

Calculate the chi-square test statistics at 0.01 level of significance.

Interpret the p-value.

Check whether the conclusion is sensitive to the level of significance chosen, identify the cells that contribute to the chi-square test statistic and check for the small expected frequencies.

Draw histogram.

Test to obtain a probability plot with the Anderson-Darling statistic.

Interpret p-values.

Answer to Problem 40CE

The null hypothesis is:

H0: Circulated nickels come from a Normal population.

And the alternative hypothesis is:

H1: Circulated nickels do not come from a Normal population.

The degrees of freedom is 1.

The critical-value using EXCEL is 2.705543.

The chi-square test statistics at 0.1 level of significance is 0.0486.

The p-value for the hypothesis test is 0.825518.

There is enough evidence to conclude that the Circulated nickels come from a Normal population.

The conclusion is not sensitive to the level of significance chosen.

The chi-square test statistic has highest chi-square value for zero appointments.

There is no expected frequencies that are too small.

The histogram is:

Gen Combo Ll Applied Statistics In Business & Economics; Connect Access Card, Chapter 15, Problem 40CE , additional homework tip  1

The probability plot is:

Gen Combo Ll Applied Statistics In Business & Economics; Connect Access Card, Chapter 15, Problem 40CE , additional homework tip  2

The Anderson-Darling statistics is 0.881.

The p-value is 0.021.

There is enough evidence to conclude that the Circulated nickels come from a Normal population.

Explanation of Solution

Calculation:

Results will vary.

There are 6 data set and pick any of them. The given information is the 31 randomly chosen circulated nickels.

The claim is to test whether the data provide sufficient evidence to conclude that the Circulated nickels come from a Normal population. If the claim is rejected, then the Circulated nickels do not come from a Normal population.

The test hypotheses are given below:

Null hypothesis:

H0: Circulated nickels come from a Normal population.

Alternative hypothesis:

H1: Circulated nickels do not come from a Normal population.

Software procedure:

  • Step by step procedure to obtain the mean and standard deviations using the MINITAB software.
  • Choose Stat > Basic Statistics>Display Descriptive Statistics.
  • Under Variables, choose 'Weight'
  • Choose Statistics, Select mean and Standard deviation.
  • Click OK.

Output obtained from MINITAB software for the data is:

Gen Combo Ll Applied Statistics In Business & Economics; Connect Access Card, Chapter 15, Problem 40CE , additional homework tip  3

Thus, the mean and the standard deviation of the data is 4.9719 and 0.0662 respectively.

For a normal distribution the first and last class must be open-ended. The upper limit of bin j can be is obtained by the Excel’s function.

Procedure for upper limit using EXCEL:

Step-by-step software procedure to obtain upper limit for first class using EXCEL software is as follows:

  • Open an EXCEL file.
  • In cell A1, enter the formula “=NORM.INV(1/6,75.38,8.94)”
  • Output using EXCEL software is given below:

Gen Combo Ll Applied Statistics In Business & Economics; Connect Access Card, Chapter 15, Problem 40CE , additional homework tip  4

Thus, the upper limit for first class using EXCEL is 4.908.

Similarly the remaining limits can be obtained as shown below:

Weights
Under 4.908
4.908–4.943
4.943–4.972
4.972–5.000
5.000–5.036
5.036 or more

The expected frequency can be obtained by the following formula:

ej=nc

Where c is the number of bins and n is the sample size.

Substitute n=31and c=6

ej=316=5.17

Then the expected frequency for each bin can be obtained as shown in the table:

WeightsExpected Frequency ej=nc
Under 4.9085.17
4.908–4.9435.17
4.943–4.9725.17
4.972–5.0005.17
5.000–5.0365.17
5.036 or more5.17
Total31

Frequency:

The frequencies are calculated by using the tally mark and the range of the data is from 4.796 to 5.045.

  • Based on the given information, the class intervals are under 4.908, 4.908–4.943, and so on, 5.036 or more.
  • Make a tally mark for each value in the corresponding class and continue for all values in the data.
  • The number of tally marks in each class represents the frequency, f of that class.

Similarly, the frequency of remaining classes for the emission is given below:

WeightsTallyObserved Frequency
Under 4.908||||4
4.908–4.943||||4
4.943–4.972|||||6
4.972–5.000||||4
5.000–5.036|||||||8
5.036 or more||||5

Let fi and ej denote the actual and expected frequency of number of arrivals.

The chi-square test statistics can be obtained by the formula:

χcalc2=j=1c(fiej)2ej

Then the chi-square test statistics can be obtained as shown in the table:

WeightsFrequency fjExpected Frequency ejfjej(fjej)2ej
Under 4.90845.17–1.170.265
4.908–4.94345.17–1.170.265
4.943–4.97265.170.830.133
4.972–5.00045.17–1.170.265
5.000–5.03685.172.831.55
5.036 or more55.17–0.170.005
Total313102.483

Therefore, the chi-square test statistic is 2.483.

Degrees of freedom:

The degrees of freedom can be obtained as follows:

d.f=cm1

Where c is the number of classes and m is the number of parameters estimated. Here only 2 parameters are estimated.

Substitute 6 for c and 2 for m.

d.f =cm1=621=3

Thus, the degrees of freedom for the test is 3.

Procedure for p-value using EXCEL:

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

  • Open an EXCEL file.
  • In cell A1, enter the formula “=CHISQ.DIST.RT(2.483,3)”
  • Output using EXCEL software is given below:

Gen Combo Ll Applied Statistics In Business & Economics; Connect Access Card, Chapter 15, Problem 40CE , additional homework tip  5

Thus, the p-value using EXCEL is 0.478.

  Rejection rule:

If the p-value is less than or equal to the significance level, then reject the null hypothesis H0. Otherwise, do not reject H0.

Conclusion:

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

That is, p-value(=0.478)>α(=0.01).

Therefore, the null hypothesis is not rejected.

Thus, the data provide sufficient evidence to conclude that the Circulated nickels come from a Normal population.

Take α=0.05

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

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

Therefore, the null hypothesis is not rejected.

Thus, the data provide sufficient evidence to conclude that the Circulated nickels come from a Normal population.

Thus, the conclusion is same for both the significance levels.

Hence, the conclusion is not sensitive to the level of significance chosen.

The class 5.000-5.036 contribute most to the chi-square test statistic.

Since all ej2, there is no expected frequencies that are too small.

Frequency Histogram:

Software procedure:

  • Step by step procedure to draw the relative frequency histogram for mileage for 2000 using MINITAB software.
  • Choose Graph > Histogram.
  • Choose Simple.
  • Click OK.
  • In Graph variables, enter the column of 'Weight'.
  • In Scale, Choose Y-scale Type as Frequency.
  • Click OK.
  • Select Edit Scale, Enter 4.8, 4.88, 4.96, 5.04, 5.12 in Positions of ticks.
  • In Labels, Enter 4.8, 4.88, 4.96, 5.04, 5.12 41 in Specified.
  • Click OK.

Observation:

It is clear from the histogram that the histogram is not symmetric. The left hand tail is little larger than the right hand tail from the maximum frequency value. Thus, there is little negative skewness on the histogram.

Software procedure:

Step by step procedure to obtain the probability plot using the MINITAB software:

  • Choose Stat > Basic Statistics > Normality Test.
  • In Variable, enter the column of 'Weights'.
  • Under Test for Normality, select the column of Anderson-Darling.
  • Click OK.

From the probability plot, it can be observed that most of the observations lies near to the straight line. Therefore, the data is from a normal distribution.

From the MINITAB output the Anderson-Darling statistics is 0.881.

From the MINITAB output the p-value is 0.021.

Conclusion:

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

That is, p-value(=0.021)>α(=0.01).

Therefore, the null hypothesis is not rejected.

Thus, the data provide sufficient evidence to conclude that the Circulated nickels come from a Normal population.

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
Please help me figure this out. Thank you :)
Please show work in Excel.
Pap smears are a diagnostic test used to detect cervical cancer. Although the test has high specificity, it also has low sensitivity.  As a result, women have to be screened often.  Using the definitions of sensitivity and specificity, explain why increased frequency of screening is needed when sensitivity is low and specificity is high.

Chapter 15 Solutions

Gen Combo Ll Applied Statistics In Business & Economics; Connect Access Card

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
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Type I and II Errors, Power, Effect Size, Significance and Power Analysis in Quantitative Research; Author: NurseKillam;https://www.youtube.com/watch?v=OWn3Ko1WYTA;License: Standard YouTube License, CC-BY