Use computer software packages, such as Excel, to solve thisproblem.

The Jacobs Chemical Company wants to estimate the mean time(minutes) required to mix a batch of material on machines producedby three different manufacturers. To limit the cost of testing,four batches of material were mixed on machines produced by each ofthe three manufacturers. The times needed to mix the materialfollow.

Manufacturer 1	Manufacturer 2	Manufacturer 3
17	29	17
23	27	16
21	32	20
19	28	19

a. The following regression model can be usedto analyze the data.

E(y) = B0+B1D1+B2D2

Show the values of the variables below. If your answer is zeroenter “0”.

D1	D2	Manufacturer
0	0	1
1		2
0		3

b. Show the estimated regression equation (tothe nearest whole number and enter negative value as negativenumber).

y^=______+______D1 +_______D2

      

c. What null hypothesis should we test todetermine if we should reject the assumption that the mean time tomix a batch is the same for all three manufacturers?

Select the number of the null hypothesis you would want totest.

- Select your answer -12345Item 6

d. What is the value of the test statistic inyour hypothesis in part (c) (to 2 decimals)? UseTable 4 in Appendix B.

What is the -value?

- Select your answer -less than .01between .01 and .025between.025 and .05between .05 and .10greater than .10Item 8

What is your conclusion?

- Select your answer -Conclude that the mean time is not thesame for all three manufacturersConclude that the mean time is samefor all three manufacturersItem 9