Skip to content. Navigation Menu Toggle navigation ...

Train the linear regression model on 80% of the data. Evaluate it on 20% of the test data. Print a comparison of actual and predicted salaries. Show visualizations for both training and test sets.

For this Step-by-Step guide below, I will use the following table that contains data with a linear trend to explain how to do linear regression in Google Sheets using the LINEST function.