How to record daily expenses with excel?

The first derivative diagram is actually a fitting curve, and the operation method is as follows:

Excel provides the function of "adding trend line" to fit curves, but the types of curves are limited to exponent, logarithm, power function, polynomial and so on. Taking Excel 20 10 as an example, demonstrate-fit the following sample data:

1. First, make a scatter plot of X and Y data.

2. Select a data point → right mouse button and select "Add Trend Line" in the pop-up menu.

3. In the newly pop-up dialog box, according to the distribution trend of data points, try to set the curve type as polynomial and the order as 2, and check the check box showing the formula. In addition, you can set the color and line type of the trend line.

4. The final effect is as follows

(The content of this article is contributed by netizen Baidu. )