Excel polynomial trendline equation

broken image

Use the LINEST function which calculates a linear regression.

broken image

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.

broken image

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

broken image