14 1 Generate a regression output using this data 2 Develop

14

1. Generate a regression output using this data.

2. Develop an estimated regression equation using Excel output.

3. Perform the T test (5 steps) to see whether the years of experience and the annual sales are significantly related.

4. What is the predicted amount of sales of a salesperson with 12 years of experience?

Solution