LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Darius Blaszijk
 
Posts: n/a
Default performing least squares

Hello,

I have the following data;

y x1 x2
12 1 10
23 2 20
34 3 30
45 4 40
56 5 50


And I would like to fit the following formula to this dataset; "x1^2 + x2 *
x1 = y"

Can anybody give me a pointer on how to do this, preferebly without having
to linearize the dataset first? The "algorithm" proposed should however be
able to fit any formula / model to the dataset, eg be general about this.

Kind regards, Darius Blaszijk


 
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
Macros not performing correctly fabulousk Excel Discussion (Misc queries) 4 March 7th 05 04:25 PM
removing squares and lines in squares that really should be paragr finnadat Excel Discussion (Misc queries) 5 February 10th 05 11:12 PM
Least Squares Analysis TNMAN Excel Worksheet Functions 2 February 8th 05 03:09 PM
How do I find template with tiny squares on the entire page kathiejo53 New Users to Excel 1 January 3rd 05 05:54 PM


All times are GMT +1. The time now is 10:13 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"