Home  >  Article  >  Topics  >  How to find the slope of each point of a curve in Excel

How to find the slope of each point of a curve in Excel

angryTom
angryTomOriginal
2020-02-20 17:25:1453043browse

How to find the slope of each point of a curve in Excel

How to find the slope of each point of the curve in Excel

1. Open excel and enter your own data. Here are 5 simple sets of data as an example

How to find the slope of each point of a curve in Excel

2. Click "Insert", find "Line Chart", select the first item, Line Chart

Recommended learning: excel basic tutorial

How to find the slope of each point of a curve in Excel

How to find the slope of each point of a curve in Excel

##3. Click "Select Data" and click Add

How to find the slope of each point of a curve in Excel

How to find the slope of each point of a curve in Excel

4. The series name is the X-axis, which is column A here, and the series value is the Y-axis, which is column B here

How to find the slope of each point of a curve in Excel

How to find the slope of each point of a curve in Excel

How to find the slope of each point of a curve in Excel

5. Click OK to display the curve graph. Right-click the curve graph, click Add Trend Line, and select Linear and Display in the pop-up dialog box. Formula, click OK

How to find the slope of each point of a curve in Excel

1How to find the slope of each point of a curve in Excel

6. After confirmation, you can see a fitting curve and formula appear, the slope is 2.1714

1How to find the slope of each point of a curve in Excel

PHP Chinese website, a large number of excel tutorials and

Introduction to Programming tutorials, welcome to learn.         

The above is the detailed content of How to find the slope of each point of a curve 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