The following are six observations collected from treatment 1, ten observations collected from treatment 2, and eight observations collected from treatment 3. Test the hypothesis that the treatment
- a. State the null hypothesis and the alternate hypothesis.
- b. What is the decision rule?
- c. Compute SST, SSE, and SS total.
- d. Complete an ANOVA table.
- e. State your decision regarding the null hypothesis.
- f. If H0 is rejected, can we conclude that treatment 2 and treatment 3 differ? Use the 95% level of confidence.
a.

Obtain the null and the alternative hypotheses.
Explanation of Solution
The null and alternative hypotheses are given below:
Null Hypothesis
That is, mean of all treatments are equal.
Alternative Hypothesis
b.

Give the decision rule.
Explanation of Solution
The treatment and error degrees of freedom are given below:
Treatment degrees of freedom:
Error degrees of freedom:
The critical F value is as follows:
Here, the level of significance
Step-by-step procedure to obtain the critical F value using Excel-MegaStat:
- In EXCEL, Select Add-Ins > MegaStat > Probability.
- Choose probability> F-distribution> calculate F given probability.
- Enter P as 0.05.
- Enter df1 as 2.
- Enter df2 as 21.
- Click Ok.
Output using the Excel-MegaStat software is given below:
From the output, the critical F value is 3.47.
Decision rule:
If
Therefore, the decision rule is to reject
c.

Find the values of SST, SSE and SS total.
Answer to Problem 12E
The value of SST is 46.96.
The value of SSE is 53.00.
The value of SS total is 99.96.
Explanation of Solution
Here, the level of significance
Step-by-step procedure to obtain the sum of square total, sum of square treatment and sum of square error using Excel-MegaStat:
- Choose MegStat > Analysis of Variance > One-Factor ANOVA.
- Select the column of Treatment 1, Treatment 2 and Treatment 3 in Input range.
- Click OK.
Output using the Excel-MegaStat software is given below:
From the output, the values of SST is 46.96, SSE is 53.00 and SS total is 99.96.
d.

Find an ANOVA table.
Explanation of Solution
From the output in Part (c), the ANOVA table is obtained.
The ANOVA table is given below:
Source of Variation | Sum of Squares | Degrees of Freedom | Mean Square | F |
Treatments | 46.96 | 2 | 23.48 | 9.3 |
Error | 53 | 21 | 2.52 | |
Total | 99.96 | 23 |
e.

Find the decision regarding the null hypothesis.
Explanation of Solution
Conclusion:
The F value is 9.30 and the F critical value is 3.47.
Here, F value is greater than F critical value. That is, 9.30 > 3.47.
Using rejection rule, reject the null hypothesis.
Therefore, there is sufficient evidence that at least one treatment mean is different from others.
f.

Check whether there is significant difference between treatment 2 and treatment 3, if null hypothesis is rejected by using the 95% level of confidence.
Explanation of Solution
A 95% confidence interval is as follows:
Where,
From the output in Part (c), mean of treatment 2 is 6, mean of treatment 3 is 4.3, and MSE is 2.524.
Step-by-step procedure to obtain t-critical value using Excel-MegaStat:
- In EXCEL, Select Add-Ins > MegaStat > Probability > t-Distribution.
- Select calculate t given P.
- Enter probability as 0.05.
- Enter df as 21.
- Under Shading, choose two-tail.
- Click Ok.
Output using the Excel-MegaStat software is given below:
From the output, the t is
Therefore, a 95% confidence interval for that difference is 0.14 and 3.26. Here, 0 does not lie in the confidence interval. It means that there is a significant difference between the means of treatment 2 and treatment 3.
Want to see more full solutions like this?
Chapter 12 Solutions
STATISTICAL TECHNIQUES FOR BUSINESS AND
- In a company with 80 employees, 60 earn $10.00 per hour and 20 earn $13.00 per hour. Is this average hourly wage considered representative?arrow_forwardThe following is a list of questions answered correctly on an exam. Calculate the Measures of Central Tendency from the ungrouped data list. NUMBER OF QUESTIONS ANSWERED CORRECTLY ON AN APTITUDE EXAM 112 72 69 97 107 73 92 76 86 73 126 128 118 127 124 82 104 132 134 83 92 108 96 100 92 115 76 91 102 81 95 141 81 80 106 84 119 113 98 75 68 98 115 106 95 100 85 94 106 119arrow_forwardThe following ordered data list shows the data speeds for cell phones used by a telephone company at an airport: A. Calculate the Measures of Central Tendency using the table in point B. B. Are there differences in the measurements obtained in A and C? Why (give at least one justified reason)? 0.8 1.4 1.8 1.9 3.2 3.6 4.5 4.5 4.6 6.2 6.5 7.7 7.9 9.9 10.2 10.3 10.9 11.1 11.1 11.6 11.8 12.0 13.1 13.5 13.7 14.1 14.2 14.7 15.0 15.1 15.5 15.8 16.0 17.5 18.2 20.2 21.1 21.5 22.2 22.4 23.1 24.5 25.7 28.5 34.6 38.5 43.0 55.6 71.3 77.8arrow_forward
- In a company with 80 employees, 60 earn $10.00 per hour and 20 earn $13.00 per hour. a) Determine the average hourly wage. b) In part a), is the same answer obtained if the 60 employees have an average wage of $10.00 per hour? Prove your answer.arrow_forwardThe following ordered data list shows the data speeds for cell phones used by a telephone company at an airport: A. Calculate the Measures of Central Tendency from the ungrouped data list. B. Group the data in an appropriate frequency table. 0.8 1.4 1.8 1.9 3.2 3.6 4.5 4.5 4.6 6.2 6.5 7.7 7.9 9.9 10.2 10.3 10.9 11.1 11.1 11.6 11.8 12.0 13.1 13.5 13.7 14.1 14.2 14.7 15.0 15.1 15.5 15.8 16.0 17.5 18.2 20.2 21.1 21.5 22.2 22.4 23.1 24.5 25.7 28.5 34.6 38.5 43.0 55.6 71.3 77.8arrow_forwardBusinessarrow_forward
- https://www.hawkeslearning.com/Statistics/dbs2/datasets.htmlarrow_forwardNC 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 CTRLarrow_forwardHarvard 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…arrow_forward
- 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…arrow_forwardA company found that the daily sales revenue of its flagship product follows a normal distribution with a mean of $4500 and a standard deviation of $450. The company defines a "high-sales day" that is, any day with sales exceeding $4800. please provide a step by step on how to get the answers in excel Q: What percentage of days can the company expect to have "high-sales days" or sales greater than $4800? Q: What is the sales revenue threshold for the bottom 10% of days? (please note that 10% refers to the probability/area under bell curve towards the lower tail of bell curve) Provide answers in the yellow cellsarrow_forwardFind the critical value for a left-tailed test using the F distribution with a 0.025, degrees of freedom in the numerator=12, and degrees of freedom in the denominator = 50. A portion of the table of critical values of the F-distribution is provided. Click the icon to view the partial table of critical values of the F-distribution. What is the critical value? (Round to two decimal places as needed.)arrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillCollege Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning


