How to Add Line of Best Fit in Google Sheets | Scribe

    How to Add Line of Best Fit in Google Sheets

    • Alai Umerez |
    • 11 steps |
    • 36 seconds
      1
      Start by entering your data into a Google Sheets spreadsheet Ensure your data is organized correctly, with the X-axis values (independent variables) in one column and the Y-axis values (dependent variables) in an adjacent column Proper organization is crucial for accurately generating a line of best fit later in the process
      2
      Select and highlight the entire range of your data, making sure to include the column headers at the top The headers are important as they define what each column represents and will also be used in the chart for labeling the axes
      3
      Look through the top menu of your Google Sheets interface for the Insert option
      4
      Click on the "Chart" option from the drop-down menu that appears after selecting Insert
      5
      Go to the Chart type drop-down
      6
      Look for the "Scatter Chart" option
      7
      In the Chart Editor on the right-hand side, navigate to the "Customise" tab
      8
      Under the "Customize" tab, expand the "Series" section
      9
      Scroll down and check the box labeled "Trendline" to enable it
      10
      From the "Trendline" options, choose "Linear" to add a line of best fit to your scatter plot
      11
      Review the results