![]() ![]() 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. 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. ![]() 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 |