V
vijaya
Hi,
I use the trend function which returns values along a linear trend.
I read in the help aht we can use trend for polynomial curve fitting by
regressing against the same variable raised to different powers. it s given
in the example that, if column A contains y-values and columne b cotains
x-values, and we can enter x^2 in column C, x^3 in column D..and so on and
then regress columns B through D against Column A.
I am just wondering how does this do.. say for this example:
X Y
1 10
2 22
3 30
4 25
5 69
6 50
7 90
8 88
9 97
10 99
How can i regress this data using polynomial curve fitting using trend
formula in excel
Thanks
I use the trend function which returns values along a linear trend.
I read in the help aht we can use trend for polynomial curve fitting by
regressing against the same variable raised to different powers. it s given
in the example that, if column A contains y-values and columne b cotains
x-values, and we can enter x^2 in column C, x^3 in column D..and so on and
then regress columns B through D against Column A.
I am just wondering how does this do.. say for this example:
X Y
1 10
2 22
3 30
4 25
5 69
6 50
7 90
8 88
9 97
10 99
How can i regress this data using polynomial curve fitting using trend
formula in excel
Thanks