How do Excel tables draw trendlines and display trendline formulas?

First, in the age of big data, data analysis becomes more and more important, the trend line added in Excel is an extension line in the chart, it can intuitively see the trend of the data, according to the actual data forecast future data, processing millions of data when the effect is particularly prominent, can also add formulas, give people the most intuitive conclusions, The following is the effect chart, the polyline is the data display, the circular arc is the trend line, this data takes the wind energy test data as an example

1, the following figure is the data we want to insert the chart, the turbulence value as the horizontal axis, the load value as the ordinate

2, according to the order in the picture, click Insert-Line chart-select line chart style, I used to use the first, you can in the future work to choose their favorite format

3, as shown in the following figure, there will be a blank chart, right click on the chart, click to select Data, jump out of the interface as shown in the picture, we need to put the data in these three circles are selected

4, click "Add" Out of the series name and select Data dialog box, in the name of the series you want to enter the name, such as "turbulence and blade load relationship", the data we select "Blade Load Column", this is the y-axis value

5. To complete the 4th step, we begin to edit the x-axis data and click "Edit" as shown in the figure

6, select the turbulent region, directly with the mouse drag and drop can be

7, the chart of the data have been selected successfully, we right-click on the chart, select Add Trend Line

8, Excel will be based on your numerical, give the recommended formula, we can choose according to the direction of the curve linear-exponential-polynomial, and so on, here we select the polynomial

9, we drag down, click the display formula, in the chart, will show the trend formula

10, click the Circle of the place, select the background of the chart, so that the chart better look, do the report can be used

Note:

1, according to the more, the trend line formula more accurate

2, axis and y-axis data don't mix

3, is a very practical and very simple function, in the use of the process can be adjusted according to personal circumstances