Hands$-$On Exercises

Skills covered

Add a Trendline to a Chart

Use the INTERCEPT and SLOPE Functions

Use the RSQ and STEYX Functions

Use the FORECAST Function

$3$ Trend Analysis

For your next task, you will create a linear trendline visualizing the changes in teachers' salaries as their careers progress. You will then use the INTERCEPT and SLOPE functions to verify the trendline equation. Next, you will use the STEYX and RSQ functions to verify the accuracy of your findings. Finally, you will finalize the project by using the FORECAST.LINEAR function to forecast the salary of a teacher who works for $30$ years.

Step $1$ Add a$.$ Trendline to a Chart

You have collected a sample set of data that includes the years of service and salaries of $50$ teachers from the Banton school system. You want to