To get a line of best fit equation on Google Sheets, first select the data points you want to use for the equation. Then, click the Insert tab and select the Chart option. Select the Scatter chart type and click the “Trendline” option. Select the “Linear” option and click “More options.” This will display the equation of the line of best fit.
