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
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
Source: www.wikipedia.org.
Source: Independent project by statistics student Frances Williams. Weighed on an American Scientific Model S/P 120 analytical balance, accurate to 0.0001 gram.
Source: www.wikipedia.org
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:
And the alternative hypothesis is:
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:
The probability plot is:
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:
Alternative hypothesis:
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:
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:
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:
Where c is the number of bins and n is the sample size.
Substitute
Then the expected frequency for each bin can be obtained as shown in the table:
Weights | Expected Frequency |
Under 4.908 | 5.17 |
4.908–4.943 | 5.17 |
4.943–4.972 | 5.17 |
4.972–5.000 | 5.17 |
5.000–5.036 | 5.17 |
5.036 or more | 5.17 |
Total | 31 |
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:
Weights | Tally | Observed 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
The chi-square test statistics can be obtained by the formula:
Then the chi-square test statistics can be obtained as shown in the table:
Weights | Frequency | Expected Frequency | ||
Under 4.908 | 4 | 5.17 | –1.17 | 0.265 |
4.908–4.943 | 4 | 5.17 | –1.17 | 0.265 |
4.943–4.972 | 6 | 5.17 | 0.83 | 0.133 |
4.972–5.000 | 4 | 5.17 | –1.17 | 0.265 |
5.000–5.036 | 8 | 5.17 | 2.83 | 1.55 |
5.036 or more | 5 | 5.17 | –0.17 | 0.005 |
Total | 31 | 31 | 0 | 2.483 |
Therefore, the chi-square test statistic is 2.483.
Degrees of freedom:
The degrees of freedom can be obtained as follows:
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.
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:
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
Conclusion:
Here, the p-value is greater than the 0.01 level of significance.
That is,
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
Here, the p-value is less than the 0.05 level of significance.
That is,
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
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,
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?
Chapter 15 Solutions
Gen Combo Ll Applied Statistics In Business & Economics; Connect Access Card
- Which MS Excel Tool shall be used with this problem? Dr. Hess has done work that suggests that emotional arousal affects pupil size. To ascertain if the type of arousal makes a difference, you decided to measure pupil size under three different arousal conditions (Neutral, Pleasant, Aversive). Each participant will look at all the different pictures that differ according to the condition. The pupil size after viewing each photograph is measured in millimeters. * ANOVA Single Factor ANOVA Two Factor Without Replication ANOVA Two Factor With Replication A researcher wants to examine driving performance under three telephone conditions namely: a) No Phone, b) Hand-Held, and c) Hands- Free. If he wants to measure the differences between sample means, we will calculate the variance: * both A and B between treatments within-treatments None of the abovearrow_forwardA random sample of 50 CSCC students are surveyed to determine what percent of our students are first-generation college students. The results showed that 16 of the students identify as first-generation college students. show your work What is the sample proportion of first-generation college students at CSCC? Is this an example of a parameter or a statistic? Explain.arrow_forwardA'6arrow_forward
- You are asked to design a study to investigate the effectiveness of the Atkins diet (IV = diet, DV = weight loss). Describe a study that would utilize an independent t test as the test statistic.arrow_forwardWhen a t-test is used to compare pre- and post-treatment data. What does the t-test reveal about the difference between baseline and treatment?arrow_forwardOnly need the last question. Please put anwsers in bold thank you! A researcher with the Department of Education followed a cohort of students who graduated from high school in a certain year, monitoring the progress the students made toward completing a bachelor's degree. One aspect of his research was to determine whether students who first attended community college took longer to attain abachelor's degree than those who immediately attended and remained at a 4-year institution.arrow_forward
- Which type of research would you be conducting on this research question? Select one. Among the types of nursing homes that have existed in my town over the past five years, which ones are most likely to have less elder abuse and neglect? Mixed methods O Qualitative O Statistical analysis Quantitativearrow_forwardAccording to a recent study annual per capita consumption of milk in the United States is 21.5 gallons. Being from the Midwest, you believe milk consumption is higher there and wish to test your hypothesis. A sample of 14 individuals from the Midwestern town of Webster City was selected and then each person's milk consumption was entered into the Microsoft Excel Online file below. Use the data to set up your spreadsheet and test your hypothesis. Develop a hypothesis test that can be used to determine whether the mean annual consumption in Webster City is higher than the national mean. H0: ? _________> 21.5≥ 21.5= 21.5≤ 21.5< 21.5≠ 21.5 Ha: ? _________> 21.5≥ 21.5= 21.5≤ 21.5< 21.5≠ 21.5 What is a point estimate of the difference between mean annual consumption in Webster City and the national mean? (2 decimals) At ? = 0.01, test for a significant difference by completing the following. Calculate the value of the test statistic (2 decimals). The p-value is (4…arrow_forwardDescribe a practical problem of your interest which could be solved by using ANOVA. Explain the problem, which are the controlled factors you will test for significance, and the type of results you may get. Do a practical numerical example in the Excel sheet, i.e. get or imagine some possible reasonable data for the example and analyze it by the ANOVA you propose. Comment on the results you get from applying ANOVA to your data set.arrow_forward
- Determine your independent and dependent variables, choose the appropriate statistical test, and determine the correct amount of replication. I am measuring the height of plants grown under 3 different levels of nitrogen. I am measuring if I can predict the size of elephant offspring based on the size of the mother. I am measuring if sex can determine if someone survived on the Titanic.arrow_forwardA program administrator at a high school wanted to see if there was a significant association between experiencing verbal abuse and anxiety in teenage women. She wasn't sure what to expect. Perform the correct statistical procedure to assess the degree of association between these variables and interpret your findings. Set alpha = .05 for your statistical test. YOU CAN EITHER TYPE YOUR WORK OUT HERE OR TAKE A PICTURE OF HANDWRITTEN WORK AND EMAIL IT TO ME. %3D Anxiety Verbal Abuse 5. 4. 4.arrow_forwardPlease use excel data analysis. Provide data or file or formulas used in excel and explain how it was done. Thank you!arrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin HarcourtHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL