Ask a new question

Excel 2nd degree polynomial trend line

X values: -100 thru 20

Y = x^2-160x

Add 2nd degree poly trend line

Displayed trend line equation: x^2 - 362x + 26361 with R^2 fit of 1

This is not an issue of number formatting that is corrected by extending the decimal positions as offered in other post solutions.

What  have I missed

Answer
Answer

Daniel wrote:

X values: -100 thru 20

Y = x^2-160x

Add 2nd degree poly trend line

Displayed trend line equation: x^2 - 362x + 26361 with R^2 fit of 1

It appears the you selected a Line chart.  Microsoft acknowledges that trendlines do not work as expected for Line charts.  See KB 211967 (https://support.microsoft.com/en-us/kb/211967).

Actually, the problem is not that trendlines "do not work".  Instead, the problem is:  Line chart trendlines always use 0, 1, 2 etc (or is it 1, 2, 3 etc?) for "x".

Use an XY Scatter chart instead.  You can use one of the line subtypes, if you want the equivalent of a Line chart.


Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated October 5, 2021 Views 885 Applies to: