Excel trendline

[David Love]

Yes.  First click on the trendline itself.  Then go to Format menu and click
on "Selected Trendline", then go to the options tab and click "Display
Equation on Chart".  It will show on the chart a quadratic equation like 
y = -.036*x^2 + .0399*x + 3.065.  Or something like that.  Set up a column
in your spreadsheet which inputs your x values (in this case perhaps a rib
number) and it will calculate the trendline value (y) at each point.  If
that's what you mean.

David Love
davidlovepianos at comcast.net 

-----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