How to fit a straight line in excel: first enter the data and select the data area; then click [Insert - Chart] and select [With Straight Line and...] in the scatter plot; then select [Add Trend Line]; finally click [Linear-Show Formula-Show R Squared Value].
The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.
How to fit a straight line in excel:
1. Enter the data into the spreadsheet according to the X value in the left column and the Y value in the right column, and then select the data area
2. Select "Insert"---"Chart" in the toolbar and select the scatter plot in the chart
3. Select "Scatter plot with straight lines and data markers" in the scatter plot, and a straight line plot will appear
4. Right-click For this straight line, select "Add Trend Line" in the options
5. Select "Linear" in the small window that pops up on the right, pull down the progress bar, and select "Display" Formula"-"Show R-squared value" will display the fitted equation
Related learning recommendations: excel tutorial
The above is the detailed content of How to fit a straight line in excel. For more information, please follow other related articles on the PHP Chinese website!