Based on the following data, where A, B, and C are independent variables and y is the dependent variable:

A	B	C	y
49.2	51.5	55.4	79.8
44.3	64.6	48.3	88.3
45.8	52.6	52.4	86.5
47.1	67.4	46.8	82.9
56.3	56.3	51.8	76.5
50.2	57.9	43.8	77.6
44.1	66.4	67.3	98.6
47.1	51.4	46.4	83.1
44.8	63	56.3	87.8
46.5	59.4	50.7	83.6
59.9	51.9	50.4	72.6
44.6	50.5	61.6	97.8
53.8	60.7	46.5	72.6
49.6	68.7	47.1	80.1
40.3	53.6	58.2	98.9
55	65	46.8	72.3
45.2	64.1	55	86.5
44.5	72.9	47.9	87.5
41.8	72.3	62	94.9
49.8	61.9	55.2	83

***FOR ALL MULTIPLE CHOICE ANSWERS, ANSWER ONLY WITH THE LETTER OF THE APPROPRIATE CHOICE***

1) Test the model for OVERALL and INDIVIDUAL significance (at a 5% significance level) and remove any/all non-relevent variables. Which of the following statements is the appropriate decision based on the significance tests?

A) Overall model is significant, Independent variable A is not significant and needs to be removed.

B) Overall model is significant, Independent variable B is not significant and needs to be removed.

C) Overall model is significant, Independent variable C is not significantand needs to be removed.

D) Overall model is significant, and ALL independent variables are significant.

REMOVE ANY/ALL NON-RELEVENT VARIABLE(S) AND ANSWER THE REMAINING QUESTIONS:

2) Test for multicollinearity on any remaining variable combinations. What is the numerical value from the test that you performed. (IF YOUR ANSWER IS NEGATIVE, ENSURE TO INCLUDE THE NEGATIVE SIGN)ANSWER TO 2 DECIMAL PLACES

3) After testing for multicollinearity, did any (or any further) variables need to be removed?

A) Yes

B) No

IF MULTICOLLINEARITY IS AN ISSUE, REMOVE A PROBLEM VARIABLE AND ANSWER THE REMAINING QUESTIONS:

4) What is the value of the multiple coefficient of determination. ANSWER IN DECIMAL FORM, TO 4 DECIMAL PLACES.

5) Select the approriate interpretation of the adjusted multiple coefficient of determination.

A)After adjusting for the two independent variables, 92.78% of the variability in dependent variable can be explained by the estimated regression equation.

B) After adjusting for the two independent variables, 91.93% of the variability in dependent variable can be explained by the estimated regression equation.

C)After adjusting for the three independent variables, 93.02% of the variability in dependent variable can be explained by the estimated regression equation.

D)After adjusting for the three independent variables, 91.71% of the variability in dependent variable can be explained by the estimated regression equation.

6) State the estimated regression equation.(USE ONLY THE REMAINING VARIABLES. ANSWER ONLY THE VALUE AFTER THE EQUAL SIGN WITH VARIABLES TO 1 DECIMAL PLACE. FOR EXAMPLE IF THE EQUATION IS: y = 12.34 + 23.45x1 + 34.56x2 + etc ...YOUR ANSWER IS: 12.3 + 23.5x1 + 34.6x2 + etc)...(VARIABLES MUST BE ENTERED IN CORRECT ORDER...b0, b1, b2...WHERE b1 IS FIRST ALPHABETICAL VARIABLE, b2 IS SECOND ALPHABETICAL VARIABLE, AND SO ON)

7) Calculate the estimated value of y for A = 45, B = 50, C = 55.USE ONLY THE REMAINING APPLICABLE VARIABLES. FINAL ANSWER TO 1 DECIMAL PLACE.

Question 5 options:

Blank # 1
Blank # 2
Blank # 3
Blank # 4
Blank # 5
Blank # 6
Blank # 7