a. Find the relationship between Salaries (dollar per hours) as a response variable and

Education level as an explanatory variable. Use excel to find the linear regression output.

The belief is that as the education level increases, the Salaries (dollar per hours) would

increase. (You have to calculate according to your data).

b. State the slope coefficient of the least square regression equation.

c. State the intercept coefficient of the least square regression equation.

d. Determine the least square regression equation representing the approximately linear

relationship between the Salaries (dollar per hours) as a response variable and Education

level as an explanatory variable.

e. Estimate the Salaries when the education level is Diploma.

f. Construct the 95% confidence interval for the slope parameter of the least square

regression equation.

following is the data set.

SALARY

• 74.94
• 49.95
• 18.75
• 13.65
• 33.75
• 63.75
• 37.95
• 22.50
• 30.75
• 10.05
• 40.35
• 14.52
• 78.87
• 19.74
• 133.50
• 45.00
• 33.75
• 21.00
• 30.00
• 43.59
• 60.00
• 67.50
• 10.92
• 31.86
• 74.94
• 18.00
• 57.00
• 39.60
• 67.50
• 45.00
• 20.64
• 35.52
• 48.42
• 41.85
• 39.48
• 15.90
• 13.50
• 30.00
• 30.00
• 30.00
• 28.11
• 17.40
• 53.58
• 3.00
• 26.40
• 27.00
• 54.48
• 23.43
• 31.86
• 13.50
• 51.75
• 31.50
• 27.66
• 45.00
• 67.50
• 13.65
• 27.00
• 39.99
• 45.00
• 22.50
• 12.75
• 37.50
• 15.39
• 10.05
• 33.33
• 11.52
• 19.20
• 16.68
• 30.00
• 16.95