A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Trendline Equation Accuracy



 
 
Thread Tools Display Modes
  #1  
Old March 5th, 2004, 12:56 PM
Jerry W. Lewis
external usenet poster
 
Posts: n/a
Default Trendline Equation Accuracy

You gave too little information for anyone to do more than guess.

The usual problems people have with Excel chart trendlines are

- Trying to calculate with the heavily rounded coefficients of the
default display - right click on the equation and format for scientific
notation with 14 decimal places, or use David Braden's VBA code to
extract the coefficients directly from the chart into cells

http://groups.google.com/groups?selm....microsoft.com

- Using a "Line" chart instead of an "XY (Scatter)" chart. "Line" chart
is a misnomer; it has nothing to do with whether you want lines
connecting your data or not, what distinguishes it from an "XY (Scatter)
chart is that the "Line" chart ignores your x-data (except for
labeling purposes) and computes as though the x data was 1,2,3,...

Jerry

Marcus wrote:

Hi.

I'm having some difficulty with the equation predictor on
my charts.

I've used "trendline" to give me an equation to predict
points along a set of data I have plotted.

This gives me an accurate equation, and hence prediction,
for one plot but for my second data series the accuracy of
the equation is awful, even though the trendline closely
follows the original data series.

Does anyone know how I can get an accurate equation
prediction for all my plots?


Thanks in advance.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:02 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.