Thread: trendlines
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
agmoore
 
Posts: n/a
Default trendlines

I am fairly new at this. When plotting fairly simple XY scattergrams I have
noticed that when y decreases at an increasing rate, the Power trendline
Excel yields fits the data with a very high r-square. But when y decreases
at a decreasing rate, the resulting trendline fits poorly and the r-square is
low. How do I get the trendline (and resulting formula) to "invert" to
better fit the data? Thanks.