Question 1:

In week 4 Practice Exercise Q#1, we looked at a randomized block design problem. Use Minitab to set up this problem as a linear regression problem. (You will need to stack the data.) The data are in Assignment3.xlsx, tab: Question 1.

	Detergent 1	Detergent 2	Detergent 3	Detergent 4
Stain 1	45	47	48	42
Stain 2	43	46	50	37
Stain 3	51	52	55	49

1. 1. Use categorical predictors in Minitab to develop an estimated regression equation for cleanness. Include the estimated regression equation output.
2. 2. Use indicator variables to develop an estimated regression equation. (Rename the indicator variables since the default names are much too long.) Include the estimated regression equation output here:
3. 3. Interpret the constant in your equation in part b.
4. 4. Test the overall utility of the model. Include the pertinent output.
5. 5. Test the significance of each predictor variable. Use a 0.05 significance level. Include any pertinent output.
6. 6. In Minitab, predict the result for Detergent #2 with Stain 3 using each of the two equations you found (parts a & b). (To use the PREDICT function, you must copy your data into a new WORKSHEET so that you have access to the individual regression analyses/equations.) Include your output for the Settings and Prediction for each equation.

Categorical Predictors:

Indicator Variables:

(NOTE: include all pictures of your excel or minitab work)

Anyone, please help me with this question. Thank you!