Excel linear fitting method

Excel linear fitting method

Select the sample data, ctrl A, click the "Insert" tab "Icon" item.

Select "XY Scatter Plot" and click "OK".

Select "Icon Filter" and click "Select Data".

Click "Edit" after the series, enter the series name, select the series values ​​of the X-axis and Y-axis according to the table content, and click "OK" twice.

Right-click on the scatter point and select "Add Trend Line".

Select "Linear" in the trend line options, check "Show formula" and "Show R-squared value".

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

The above is the detailed content of Excel linear fitting method. For more information, please follow other related articles on the PHP Chinese website!