A manager of a product sales group believes the number of sales made by an employee (Y) depends on how many years that employee has been with the company (X1) and how he/she scored on a business aptitude test (X2). A random sample of 8 employees provides the following:

Employee Y X1 X2

1 100 10 7

2 90 3 10

3 80 8 9

4 70 5 4

5 60 5 8

6 50 7 5

7 40 1 4

8 30 1 1

1 what is the adjusted r2 for this model?

2,what is the value for the three regression coefficients,b0,b1, and b2?

3,for each coefficient determine whether it is significant at 95 % confidence level?explain

4,using the aptitude test what does the moel predict for his/her expected sales?

5,residual plot against the two independent variables and comment on your interpretation of the result.