![]() ![]() 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). Now that you have the coefficients you can calculate the maximum. Steps: First, select the dataset with the help of the mouse. Let us see how to find the equation from a single trendline. This type of trendline is applicable to various real-life cases. The formula calculates the linear least squares regression and fills all selected cells simultaneously. Find Equation with Single Trendline in Excel For simple excel datasets, you can use a single trendline to fit your data and then find its equation. 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. ![]() Use the LINEST function which calculates a linear regression. To do something with the coefficients, you will have to calculate them yourself. The trendline generated automatically by Excel only draws the line and prints the calculated coefficients. Looking at your picture, it seems that you have very few points and finding the largest of them is not enough. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |