Home  >  Article  >  Topics  >  How to fit a straight line in excel

How to fit a straight line in excel

coldplay.xixi
coldplay.xixiOriginal
2021-02-24 11:25:16109439browse

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].

How to fit a straight line in excel

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

How to fit a straight line in excel

2. Select "Insert"---"Chart" in the toolbar and select the scatter plot in the chart

How to fit a straight line in excel

3. Select "Scatter plot with straight lines and data markers" in the scatter plot, and a straight line plot will appear

How to fit a straight line in excel

4. Right-click For this straight line, select "Add Trend Line" in the options

How to fit a straight line in excel

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

How to fit a straight line in excel

How to fit a straight line in excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn