Excel trendline

[Jason Kanter]

Ron, I believe the trendline feature uses the Trend() function, so maybe you
can do it on the worksheet instead of deriving from the chart. See the group
of Statistics functions/jason 

-----Original Message-----
From: pianotech-bounces at ptg.org [mailto:pianotech-bounces at ptg.org] On Behalf
Of Ron Nossaman
Sent: Sunday, May 14, 2006 11:25 AM
To: Pianotech
Subject: Excel trendline


Brain pool - help!

Excel has a trendline feature in it's charting system, to visually smooth
the data. Does anyone know a way to get the set of smoothed data point
values BACK from the second degree polynomial trendline routine, or how to
use the trendline's Y and R^2 formulas to reconstruct the smoothed set in a
column?

Yes, it's piano related.

Thanks,
Ron N