Illustration of Excel Curve fitting method

When doing social research or scientific experiments, it is often necessary to synthesize the obtained experimental data to form a graph, which can make the result easy to understand. The following describes how to use Excel to quickly curve fit. Include smoothing curves, linear, exponential, power, polynomial (such as two-time curves, three-time curves). ), logarithmic fitting.

Software Name:

EXCEL2003 Green version EXCEL2003 Lite Green version (with excel2003 green tools)

Software size:

13.3MB

Update Time:

2012-06-19

Method/Step

Enter the experimental data into Excel, two variables of the best two vertical rows. Select all the data and be careful not to select the text too.

In the menu bar, click Insert, and then select the Drop-down menu under scatter chart.

Smooth curve:

Choose the type you want from the menu, generally select both the data point and the smooth curve of the scatter plot. You can get a smooth curve.

Polynomial fitting (linear, exponential, power, logarithm is similar):

Select data;

Insert, scatter plot;

Select the type of only a few positions;

You can get the data points shown in the second picture.

Click a point to select all data points, then right-click, and select "Add Trendline" in the pop-up menu.

Here you can choose the type of curve you want, such as linearity, exponent, power, logarithm, polynomial. Select the polynomial.

The following "show Formula", "Show R squared" check box to tick, you can get the required curve, formula, and relative error.

Graphics format settings:

There are some problems with the graphics, such as no axis names, no ticks, and so on.

Open the design in the menu, click the Drop-down menu in the layout of the icon.

You will see icons with many layout types and choose what you need. For example, the layout selected in the figure is a common title, an axis name.

The axes also need to be set: Click on the area near the axis with the mouse, right-click, select Format axis.

This can be set in detail here. The specific operation according to own need to carry on.