how to find the equation of trendline in excel

A linear trendline usually shows that something is increasing or decreasing at a steady rate. Your data is linear if the pattern in its data points looks like a line. Though, to find the maximum of a fourth-order polynomial, you will have to solve a cubic equation which is not that easy.Ī possible approximation is to calculate the trendline values for many X values in some predefined range (my green line) and then to select the largest one using the MAX function (or, since the fourth-order polynomial's tails can rise high, by comparing each value with its neighbors). Use this type of trendline to create a best-fit straight line for simple linear data sets. Now that you have the coefficients you can calculate the maximum. To find the slope of the trendline, click the right arrow next to Trendline and click More Options: In the window that appears on the right side of the screen, check the box next to Display Equation on chart: The trendline equation will automatically appear on the scatterplot: The trendline equation turns out to be y 2.4585x 1.3553.

The formula calculates the linear least squares regression and fills all selected cells simultaneously. It's an array function which means that you select several cells, enter the formula and press Ctrl+Shift+Enter to enter it simultaneously into all cells. We can also see the relationship between x and y by creating a scatter chart for the original data and choosing Layout > AnalysisTrendline in Excel and then. Use the LINEST function which calculates a linear regression. To do something with the coefficients, you will have to calculate them yourself. Then use Excel to find the equation of the appropriate trendline. The trendline generated automatically by Excel only draws the line and prints the calculated coefficients. For j 1 To UBound (SelectedSheets) TLEq (j).Trendlines (1).DataLabel.

Looking at your picture, it seems that you have very few points and finding the largest of them is not enough.

How to find the equation of trendline in excel