View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Douglas Eckert Douglas Eckert is offline
external usenet poster
 
Posts: 32
Default Linear Trendline Vs Common Sense

Thank you very much, James Silverton!

"James Silverton" wrote:

Douglas wrote on Thu, 7 Jun 2007 07:10:00 -0700:

DE I need to know why the amount of workload this year is down
DE 9% so far, but the linear trend line is up. True, work has
DE increased in recent months, but it is down for the fiscal
DE year-to-date. The linear trend accounts for the recent
DE increases, but not for the fact that the total amount of
DE workload this year has declined when compared to the same
DE time period last year. €˜Any thoughts?

The trendline is a mathematical determination from the data and
essentially there would be roughly as many values below as above
the line, I guess. Perhaps a moving average might be more
helpful to you.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not