Page 331 - Excel for Scientists and Engineers: Numerical Methods
P. 331
308 EXCEL: NUMERICAL METHODS
Figure 13-18. The new menu command in the Chart menu.
To use the utility, you first must select a Trendline equation in a chart. Then
choose the Copy Trendline to Cell.. . command. Two dialog boxes direct you
to, first, select the destination cell for the formula, and second, select the cell for
the independent variable x. The utility converts a trendline equation such as
y = 3x3 + 25x2 - 5x - 11
into the corresponding Excel formula
= 3*A9"3 + 2.5*A9"2 - 5*A9 - 11
The utility can handle linear, logarithmic, polynomial, power and exponential
Trendline equations.
