LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 9
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
Least Squares Regression ST. Dev. Kris@CEC Excel Worksheet Functions 5 August 24th 07 02:42 PM
chi squares Rozie Excel Discussion (Misc queries) 1 June 29th 06 09:52 PM
blue squares blue New Users to Excel 1 February 14th 06 09:46 AM
performing least squares Darius Blaszijk Excel Discussion (Misc queries) 5 March 19th 05 07: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


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