Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
best curve fitting | Charts and Charting in Excel | |||
curve fitting to a sine function | Charts and Charting in Excel | |||
watch a curve change over time like a movie | Charts and Charting in Excel |