This week’s assignment requires that you demonstrate the relationship between a dependent variable and multiple independent variables. You will be required to use the least squares approach as well as use software (SPSS preferred) to perform analyses that will yield the multiple coefficient of determination and multiple linear regression analysis. Your submission should demonstrate thoughtful consideration of the ideas and concepts presented in the course.
Please use the above statement to assist in answer the questions in the attached document.
DATA FILE 7
ASSIGNMENT 8
1. Suppose you fit the multiple regression model
y = β0 + β1×1 + β2×2 + ϵ
to n = 30 data points and obtain the following result:
The estimated standard errors of and are 1.86 and .29, respectively.
a. Test the null hypothesis H0: β2 = 0 against the alternative hypothesis Ha: β2 ≠0. Use α = .05.
b. Test the null hypothesis H0: β3 = 0 against the alternative hypothesis Ha: β3 ≠0. Use α = .05.
c. The null hypothesis H0: β2 = 0 is not rejected. In contrast, the null hypothesis H0: β3 = 0 is rejected. Explain how this can happen even though >
2. Use SPSS to fit a secondorder model to the following data:
0 
1 
2 
3 
4 
5 
6 

y 
1 
2.7 
3.8 
4.5 
5.0 
5.3 
5.2 
a. Find SSE and s2.
b. Do the data provide sufficient evidence to indicate that the secondorder term provides information for the prediction of y? [Hint: Test H0: β2 = 0].
c. State the least squares prediction equation.
3. Running a manufacturing operation efficiently requires knowledge of the time it takes employees to manufacture the product, otherwise the cost of making the product cannot be determined. Estimates of production time are frequently obtained using time studies. The data in the table below came from a recent time study of a sample of 15 employees performing a particular task on an automobile assembly line.
Time to Assemble, y (minutes) 
Months of Experience, x 
10 
24 
20 
1 
15 
10 
11 
15 
11 
17 
19 
3 
11 
20 
13 
9 
17 
3 
18 
1 
16 
7 
16 
9 
17 
7 
18 
5 
10 
20 
a. Run the multiple linear regression model in SPSS. State the least squares prediction equation.
b. Test the null hypothesis H0: β2 = 0 against the alternative Ha: β2 ≠0. Use α = .01. Does the quadratic term make an important contribution to the model?
c. Your conclusion in part b should have been to drop the quadratic term from the model. Do so and fit the “reduced model” y = β0 + β1x + ϵ to the data.
d. Define β1 in the context of this exercise. Find a 90% confidence interval for β1 in the reduced model of part c.
4. Suppose you fit the model y = β0 + β1×1 + β2×2 + β3x1x2 + β4×12+ β5×22ϵ to n = 30 data points and get SSE = .46 and R2 = .87.
a. Do the values of SSE and R2 suggest that the model provides a good fit to the data? Explain.
b. Is the model of any use in predicting y? Test the null hypothesis that E(y) = β0; that is, test
H0: β1 = β2 = β3 = β4 = β5 = 0
against the alternative hypothesis
Ha: At least one of the parameters β1, β2, … β5 is nonzero.
Use α = .05.
5. A company that services copy machines is interested in developing a regression model that will assist in personnel planning. It needs a model that describes the relationship between the time spent on a preventive maintenance service call to a customer, y, and two independent variables: the number of copy machines to be serviced, x1, and the service person’s experience in preventive maintenance, x2.
Hours of maintenance 
Number of copy machines 
Months of experience 
1.0 
1 
12 
3.1 
3 
8 
17.0 
10 
5 
14.0 
8 
2 
6.0 
5 
10 
1.8 
1 
1 
11.5 
10 
10 
9.3 
5 
2 
6.0 
4 
6 
12.2 
10 
18 
a. Fit the model y = β0 + β1×1 + β2×2 + ϵ to the data.
b. Investigate whether the model is useful. Test α = .10.
c. Find R2 for the fitted model. Interpret your results.
d. Fit the model y = β0 + β1×1 + β2×2 + β3x1x2 + ϵ to the data.
e. Find R2 for the model in part d.
f. Explain why you should not rely solely on a comparison of the two R2 values for drawing conclusions about which model is more useful for predicting y.
g. Do the data provide sufficient evidence to indicate that the interaction term, x1x2 contributes information for the prediction of y? [Hint: Test H0: β3 = 0] Which model is more useful for predicting y?
h. Can you be certain that the model you selected in part g is the best model to use in predicting maintenance time? Explain.
We are a professional custom writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework.
Yes. We have posted over our previous orders to display our experience. Since we have done this question before, we can also do it for you. To make sure we do it perfectly, please fill our Order Form. Filling the order form correctly will assist our team in referencing, specifications and future communication.
1. Click on the “Place order tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
2. Fill in your paper’s requirements in the "PAPER INFORMATION" section and click “PRICE CALCULATION” at the bottom to calculate your order price.
3. Fill in your paper’s academic level, deadline and the required number of pages from the dropdown menus.
4. Click “FINAL STEP” to enter your registration details and get an account with us for record keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
5. From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.