The data is:

Obs	Salary	Avg Perf.	Years	Certifications
1	48.20	3.50	9	6
2	55.30	5.30	20	6
3	53.70	5.10	18	7
4	61.80	5.80	33	7
5	56.40	4.20	31	8
6	52.50	6.00	13	6
7	54.00	6.80	25	6
8	55.70	5.50	30	4
9	45.10	3.10	5	6
10	67.90	7.20	47	8
11	53.20	4.50	25	5
12	46.80	4.90	11	6
13	58.30	8.00	23	8
14	59.10	6.50	35	7
15	57.80	6.60	39	5
16	48.60	3.70	21	4
17	49.20	6.20	7	6
18	63.00	7.00	40	7
19	53.00	4.00	35	6
20	50.90	4.50	23	4
21	55.40	5.90	33	5
22	51.80	5.60	27	4
23	60.20	4.80	34	8
24	50.10	3.90	15	5

The personnel director for a small manufacturing company has collected the data found in the file Manufacturing.xlsx describing the salary (Y) earned by each machinist in the factory along with the average performance rating (X1) over the past 3 years, the years of service (X2), and the number of different machines each employee is certified to operate (X3). The personnel director wants to build a regression model to estimate the average salary an employee should expect to receive based on his or her performance, years of service, and certifications. a. Prepare three scatter plots showing the relationship between the salaries and each of the independent variables. What sort of relationship does each plot suggest? The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank b. If the personnel director wanted to build a regression model using only one independent variable to predict the salaries, what variable should be used? I. Average performance rating (X1) II. Years of service (X2) III. Number of certifications (X3) What is its R2 value? Round your answer to one decimal place. % c. If the personnel director wanted to build a regression model using only two independent variables to predict the salaries, what two variables should be used? I. Average performance rating (X1) II. Years of service (X2) III. Number of certifications (X3) II and III What is its adjusted-R2 value? Round your answer to one decimal place. *% d. Compare the adjusted-R2 statistics obtained in parts b and c with that of a regression model using all three independent variables. Which model would you recommend the personnel director use? 1. X2 II. X2 & X3 III. X1, X2 & X3 What is its adjusted-R2 value? Round your answer to one decimal place. 8 % e. Suppose the personnel director chooses to use the regression function with all three independent variables. What is the estimated regression function? e. Suppose the personnel director chooses to use the regression function with all three independent variables. What is the estimated regression function? If required, round your answers to two decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) = + 1.06 X1 + 33x2+ 1.30X3 f. Suppose the company considers an employee's salary to be fair if it is within 1.5 standard errors of the value estimated by the regression function in part e. What salary range would be appropriate for an employee with 12 years of service, who has received average reviews of 4.5, and is certified to operate 4 pieces of machinery? Round your answers to a whole dollar amount