Simple Regression Modeling Steps- Attach scatter chart

1. Open the Excel worksheet containing your Team Project Data.
2. As you learned in Module 2, run a simple linear regression model using the independent numerical variable whose Excel worksheet column is highlighted in DARK ORANGE WorkHrs as the predictor of Y the YELLOW Salary Excel column.
   1. Cut and paste into your report the scatter plot and the Excel Regression Output for this simple linear regression model.
   2. Write the sample regression equation.
   3. Interpret the meaning of the Y-intercept and slope for your fitted model.
   4. Interpret the meaning of the coefficient of determination r ² .
   5. Interpret the meaning of the standard error of the estimate SYX .
   6. Obtain the residual plots and cut and paste them into the report. Briefly comment on the appropriateness of your fitted model.
      1. (1) If the assumptions are met and the fitted model is appropriate,continue to Step 2G.
      2. (2) If any of the linearity, normality, or equality of variance assumptions are problematic state this but continue to Step 2G. Note -- you do not need to check the assumption of independence in your project. (That assumption is automatically met because your project is not time-dependent).
   7. Comment on the statistical significance of your fitted model
   8. Comment on the 95% confidence interval estimate on the average impact on the response variable for each unit increase in the predictor variable.
   9. Select a value for your independent variable in its relevant range:
      1. Predict -Reference; Unknown -NO SOURCE PROVIDED

Salary	WorkHrs
125.3	55
64.8	40
32.3	40
57.1	40
97.3	50
61.4	30
122.6	60
44.0	40
102.7	44
42.6	40
53.0	40
20.8	50
53.3	30
54.1	55
40.3	45
68.3	40
23.5	40
26.2	45
42.1	40
77.9	50
29.4	35
24.6	40
85.9	48
21.4	45
121.0	50
44.2	40
58.1	45
48.5	32
66.4	62
51.5	40
36.0	40
32.2	40
81.0	50
90.7	72
26.4	30
69.3	40
35.2	40
20.3	35
66.1	40
86.7	48
80.0	40
37.8	55
62.4	40
49.4	40
51.7	40
28.6	40
63.7	35
87.4	40
30.1	50
63.4	59
124.8	40
103.2	45
65.3	40
62.7	50
33.8	42
45.4	50
24.0	40
46.7	32
36.8	40
32.0	40
42.9	40
21.5	40
38.2	41
30.2	50
58.1	44
82.9	35
35.4	32
36.0	40
61.1	40
59.7	55
82.9	40
68.0	40
71.0	55
80.8	50
130.7	70
88.5	60
68.2	43
67.7	52
36.0	46
75.4	50
62.6	76
23.8	38
53.0	40
34.7	40
25.8	54
48.6	60
45.8	50
40.3	40
49.0	40
49.4	67
56.2	44
42.7	48
36.3	38
43.4	40
72.5	52
54.4	40
92.5	60
72.5	52
61.0	40
23.5	50
56.8	40
77.8	60
71.7	60
64.2	50
82.2	55
47.8	49
37.9	32
42.2	40
49.3	40
73.1	40
76.3	60
62.4	40
51.8	55
49.9	60
26.2	42
41.8	40
94.9	50
67.7	70
43.0	40
61.3	89
94.9	50
26.1	72
55.0	40
50.2	65
86.1	75
42.2	68
37.0	38
25.2	48
36.5	50
49.1	45
73.3	45
47.2	60
41.4	45
42.9	40
65.9	40
41.6	60
30.4	45
21.0	40
30.9	56
33.8	57
58.6	47
46.9	60
30.9	40
69.8	46
24.5	40
23.0	40
48.5	50
84.3	80
73.1	40
25.9	60
71.5	40
29.0	72
88.0	40
44.0	45
40.3	40
34.2	45
25.8	40
51.0	40
80.6	40
25.9	60
87.8	50
81.4	45
41.8	40
92.8	48
52.8	40
42.6	40
33.3	40
34.1	40
65.9	55
62.7	40
82.6	60
44.0	50
81.9	50
122.2	32
31.2	54
68.5	50
23.5	40
32.6	40
61.6	40
58.6	40
49.9	40
48.6	40
74.6	40
107.2	50
63.0	52
147.0	45
69.8	40
36.0	50
50.9	40
44.6	60
40.0	40
59.0	48
68.3	44
60.3	60
84.2	73
52.0	40
75.5	40
59.0	60
21.1	75
36.0	50
37.3	50
28.5	60
49.8	50
26.4	80
34.9	60
75.0	50
21.9	40
77.4	35
28.0	55
23.8	56
44.8	56
35.0	50
65.8	50
49.9	84
35.2	40
32.3	42
20.2	50
24.3	70
25.3	40
34.1	34
28.2	63
61.6	65
54.2	40
36.2	40
50.2	65
30.9	40
21.3	40
77.4	80
36.0	50
65.8	45
23.2	40
58.1	40
84.5	60
41.1	30
40.3	50
24.0	40
28.8	40
49.6	32
53.3	40
25.3	40
51.2	40
57.1	64
38.9	49
57.8	40
37.9	40
50.1	48
38.6	42
48.5	50
28.6	40
32.6	40
34.6	32
27.2	40
28.3	40
20.9	38
52.5	40
26.1	40
71.5	40
80.2	40
47.7	40
64.3	40
22.6	40
36.0	46
24.8	40
27.2	40
31.7	40
30.9	40
25.6	40
29.0	48
34.7	40
59.5	40
40.3	45
45.8	43
98.7	55
56.2	46
33.0	40
21.9	30
31.5	40
43.4	36
23.4	40
28.5	45
37.0	36
30.9	50
26.7	40
25.4	43
41.3	35
92.8	40
41.1	40
39.7	40
25.0	37
45.6	60
32.0	40
26.7	40
36.3	40
25.9	40
55.4	40
25.6	42
33.9	40
40.2	40
66.4	45
43.2	41
22.2	37
22.4	40
36.3	42
32.0	40
31.5	40
53.3	45
39.5	50
21.8	40
32.8	40
30.2	32
60.6	40
42.7	60
21.1	40
61.9	40
23.0	40
29.9	40
36.8	55
27.7	40
23.0	40
21.4	40
24.5	35
44.6	35
24.8	60
43.7	40
60.3	35
32.6	45
37.4	40
22.8	55
21.9	40
100.5	40
40.3	50
51.5	40
45.0	40
20.5	43
40.0	45
28.5	45
24.6	40
41.4	65
24.0	40
45.8	45
40.8	50
65.1	40
29.0	40
22.7	37
44.2	46
38.2	40
43.2	51
27.4	40
26.9	29
41.6	40
37.4	40
33.3	32
45.0	36
30.4	40
63.4	40
48.3	40
37.1	32
28.3	45
47.0	40
32.8	35
29.1	40
24.5	40
69.4	28
29.0	40
53.4	34
53.9	60
50.1	40
53.9	40
26.6	38
28.2	40
22.7	40
41.1	48
34.6	60
27.8	42
23.5	32
36.3	40
40.6	60
61.4	40
29.9	40
42.6	56
83.0	48
36.0	40
21.3	40
24.0	44
38.7	50
31.8	38
26.2	40
47.5	50
57.1	36
24.5	48
38.2	40
24.6	40
24.9	40
37.8	40
20.2	40
35.0	47
23.5	32
46.2	37
24.8	40
28.6	40