LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
vijaya
 
Posts: n/a
Default trend for polynomial curve fitting by regressing

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
best curve fitting ladee_bird Charts and Charting in Excel 1 September 20th 05 07:25 AM
curve fitting to a sine function Tenarife Charts and Charting in Excel 2 August 13th 05 08:23 PM
watch a curve change over time like a movie RandyBarrett Charts and Charting in Excel 6 February 19th 05 05:00 AM


All times are GMT +1. The time now is 01:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"