Thread
:
Trendline equation calculation
View Single Post
#
2
Posted to microsoft.public.excel.charting
Tushar Mehta[_3_]
external usenet poster
Posts: 37
Trendline equation calculation
Right click on the equation in the chart, select 'Format Data
Labels...' then the Numbers tab. From the Category list select
'Number' and in the Decimal places field enter 15. This will give you a
much more accurate trendline equation.
In article ,
says...
Equations generated by Excel for trendlines do not seem to match those
derived from the coeffiecients of a regression analysis.
And, when re-plotting data recalculated from the trendline equation for
original data, it is not the same - however when fitting a trendline to this
re-plotted data the same equation as the oringinal data is displayed!
Am I not writing the equation correctly, is this a genuine discrepency? Am
especially interested in polynomial fitted trendlines.
Many Thanks
Reply With Quote
Tushar Mehta[_3_]
View Public Profile
Find all posts by Tushar Mehta[_3_]