To get the results of a chart's trendline result into a Excel worksheet Possible you are doing something wrong though I cannot of think of Maybe, XL2004 hasn't caught up with XL2003? Of course, it is Select a block 7 columns wide, 5 rows deepĮnter =LINEST(y-range, x-range^). I am using Excel 2004 for Mac (OSX) Ver11.2 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?
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |