ufhorizon.blogg.se

PS Here is the equation that Excel displays on my chart

I can make it calculate, but the values don't match data.Īny help with this problem would be appreciated. Liengme's website ( ), however, I can't seem to make this work properly. I also tried using the "linest" function as described in Mr. I am trying to fit a polynomial regression (trendline) to a X, Y scatterplot I have created.Įxcel's built-in trendline function shows a good fit (R2=0.9999) for a 6th order polynomial, however, If I re-plot the data using the coefficients from the "Display equation" option, the data diverge significantly.Īpparently, for high order polynomials, you need to have a high level of precision in your coefficients (many decimal places accurate) in order to actually re-plot the same curve. How can I increase the precision in Excel's "Display Equation" option for trendlines?