S
simal
The following text can be found in the help for the TREND workshee
function:
You can use TREND for polynomial curve fitting by regressing agains
the same variable raised to different powers. For example, suppos
column A contains y-values and column B contains x-values. You ca
enter x^2 in column C, x^3 in column D, and so on, and then regres
columns B through D against column A.
Can anyone shed any light on how to actually use this information on
worksheet?
I have tried a number of interpretations and cannot get the function t
return a predicted y value for a new input x value with a polynomia
function higher than order 1.
I would be chuffed if someone could send me a worksheet with a
example.
Thanks,
S
function:
You can use TREND for polynomial curve fitting by regressing agains
the same variable raised to different powers. For example, suppos
column A contains y-values and column B contains x-values. You ca
enter x^2 in column C, x^3 in column D, and so on, and then regres
columns B through D against column A.
Can anyone shed any light on how to actually use this information on
worksheet?
I have tried a number of interpretations and cannot get the function t
return a predicted y value for a new input x value with a polynomia
function higher than order 1.
I would be chuffed if someone could send me a worksheet with a
example.
Thanks,
S