Please Help!!

Use the data given below to answer the following problem.

Following is an extract from a firm's database detailing the number of hours spent on the job by employees and their corresponding pay. (Note: Assume a level of significance of 0.05 wherever necessary.)

Hours on the job Salary ($)

4 1340

12 1850

7 1570

5 1470

11 1820

8 1610

9 1630

13 1900

10 1800

6 1480

Problem #4 Part A: Construct a scatter diagram and use the Excel Trendline tool to find the best-fitting simple linear regression model.

Problem #4 Part B: Is the hours spent on the job a statistically significant variable in explaining the variation in pay of employees? Explain why you think hours on the job is statistically significant or not. (Hint: Use Excel's Regression tool. You will not get full credit unless you do.)