Question

In: Statistics and Probability

You must include all EXCEL printouts and the 6 step write-up for both problems. The questions...

You must include all EXCEL printouts and the 6 step write-up for both problems. The questions are given below.

USING ANOVA: Assuming variances are equal.

Concerned about Friday absences, management examined the number of persons absent for each of the past three Fridays. Does this sample provide sufficient evidence to conclude there is a significant difference in the average number of absences? Use alpha = .05.

Plant 1

Plant 2

Plant 3

Plant 4

19

17

27

22

24

20

32

27

20

16

27

25

  1. Is there sufficient evidence of a difference in the variances in number of absences among the four plants? (Set alpha = to .05)

  1. Provide the p-value for part a, and explain its meaning in words.

  1. Is there sufficient evidence to indicate a difference in the mean number of absences among the four plants? (Set alpha = to .05)

  1. Provide the p-value for part a, and explain its meaning in words.

  1. If there is a difference in the means, what test would you use to figure out which ones are different?

Solutions

Expert Solution

Using Minitab software, (Stat -> ANOVA -> Test for equal variances), we get

b) Since p-value = 0.956 > 0.05, so we fail to reject H0 and we can conclude that there is no sufficient evidence of a difference in the variances in number of absences among the four plants.

c) Using Minitab software, (Stat -> ANOVA -> One way), we get

Since P-value = 0.004 < 0.05, so at 5% level of significance, we reject H0 and we can conclude that there is significant difference in the mean number of absences among the four plants.

e) Since there is a difference in the means,  to figure out which ones are different, one need to use independent samples t test.


Related Solutions

PLEASE SHOW ALL THE FORMULA IN AN EXCEL FORMAT AND ANSWER ALL QUESTIONS All problems must...
PLEASE SHOW ALL THE FORMULA IN AN EXCEL FORMAT AND ANSWER ALL QUESTIONS All problems must be solved using Excel formulas to receive credit. Question Set 1. You are in charge of quality control for computer monitors at Dell. You have data on twenty-five batches of monitors, tracking five types of defects: brightness, color, contrast, dead pixels, and stuck pixels. These data are given in the table below. 1. For each defect type, find the average number of defects per...
You must use Excel for solving all the problems In problem 13.9 on page 501, an...
You must use Excel for solving all the problems In problem 13.9 on page 501, an agent for real estate company wanted to predict the monthly rent for one-bedroom apartments, based on the size of the apartment. The data are stored in rentsliverspring. Use the results of that problem. a. at the 0.05 level of significance, is there evidence of a linear relationship between the size of the apartment and the monthly rent? b. Construct at 95% confidence interval estimate...
Do the following present value problems. You must set up all present value problems before calculation....
Do the following present value problems. You must set up all present value problems before calculation. Merely writing down the answer (even if it is correct) is an automatic zero. You must show your work. a. Suppose we have a four year fixed-payment loan with $1000 payments made at the end of each year. Given a market interest rate of 12 percent, how much was initially borrowed? b. Suppose you were considering purchasing a $5000 machine today that would generate...
all hypothesis testing problems must include specification of the null and alternative hypotheses and must report...
all hypothesis testing problems must include specification of the null and alternative hypotheses and must report the p-value of the data Standards for automated filling of bulk coffee bean bags require that the mean fill amount should be 10 kg and the s.d. of fill amounts should be no more than 0.01 kg. A random sample of 30 bags was weighed and their weights are given 10.0072 10.0021 10.0105 10.0098 10.0162 9.9756 10.0196 10.0237 10.0432 10.0147 10.053 9.9728 10.0338 9.9446...
Each student must answer all parts to both questions below. Write your answers thoroughly, showing all...
Each student must answer all parts to both questions below. Write your answers thoroughly, showing all mathematical steps you took to answer each question. Keep it professional Question 1: Write a brief description (3-4 sentences) of how probability has been part of your life. Question 2: You may not be aware of when statistics has come into your life. In this discussion, you need to provide examples of how statistics may be used to sway individuals to think information differently.
**PLEASE ANSWER ALL SUB-QUESTIONS AND EXPLAIN STEP BY STEP. PLEASE INCLUDE FORMULAE IN CORRECT FORMAT NOT...
**PLEASE ANSWER ALL SUB-QUESTIONS AND EXPLAIN STEP BY STEP. PLEASE INCLUDE FORMULAE IN CORRECT FORMAT NOT COMPUTED VERSIONS, PLEASE INCLUDE NOMENCLATURE FOR ALL FORMULAE USED.THANK YOU!*** Discuss the following in detail: (1) Equimolar counterdiffusion and unimolecular diffusion in liquids (2) For diffusion in liquids between counterdiffusion and unimolecular diffusion which is more commonly observed? Why is this observed?
**PLEASE ANSWER ALL SUB-QUESTIONS AND EXPLAIN STEP BY STEP. PLEASE INCLUDE FORMULAE IN CORRECT FORMAT NOT...
**PLEASE ANSWER ALL SUB-QUESTIONS AND EXPLAIN STEP BY STEP. PLEASE INCLUDE FORMULAE IN CORRECT FORMAT NOT COMPUTED VERSIONS, PLEASE INCLUDE NOMENCLATURE FOR ALL FORMULAE USED.THANK YOU!*** Methyl alcohol and water are brought into contact in such a way that the two components form a layer 1.00 cm thick on top of a 3cm deep layer of water. Both components(water and methyl alcohol) are mutually diffusing into each other at 270C, there is no mixing of water and methyl alcohol and...
*Include all calculations and no excel please* A buyer for National Sports must place orders with...
*Include all calculations and no excel please* A buyer for National Sports must place orders with Saucony prior to the time the shows will be sold as they are manufactured overseas and shipping takes several months.  The buyer must decide on November 1 how many pairs of the latest model Saucony’s to order for sale during the coming summer season. Saucony’s ordering policy requires retailers to purchase shoes in lots of 100 pair.  Saucony charges National Sports $45 per pair.  National retails them...
Please solve all answers on Excel and show step by step how you get the WACC...
Please solve all answers on Excel and show step by step how you get the WACC answer.   Tornado Motors is a major producer of sport and utility trucks. It is a family owned company, started by Jane Biscayne in 1935, at the height of the Great Depression. Today the firm produces 3 lines of trucks. These include a standard, no-frills short bed pickup truck (Model A), a mid-size version (Model B ) and a larger, heavy-duty work truck (Model C)....
PLEASE ANSWER QUESTIONS WITH ALL CALCULATIONS! WILL GIVE THUMBS UP ! THANK YOU ! 6. Use...
PLEASE ANSWER QUESTIONS WITH ALL CALCULATIONS! WILL GIVE THUMBS UP ! THANK YOU ! 6. Use the information below and the Two-stage Growth Model to find Axis Capital’s intrinsic value.  Forecast its cash flows from t+1 to t+3.  If its current price is $37.54, is it over or under valued? t t+1 t+2 t+3 t+4 Beta 0.80 ROE 0.09 0.08 0.08 0.08 DPO 0.37 0.34 0.34 0.34 Div $1.64
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT