the easiest way I know is to plot the values on an XY chart then add a
trendline - right click on the series, click Add Tendline then select
Polynomial and go to the Options and click Display equation on chart.

Or, you could use the Solver to calculate the coefficients of each power of
X that would minimize the sum of the squares between calculated and actual
values of Y for each known X, but that is a little harder. However, see

http://archives.math.utk.edu/ICTCM/E...tml/paper.html


"vijaya" wrote:

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