Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default performing least squares

Darius,

If you want a "general" method then why not use solver? I've used this
in the past when fitting a dataset (assuming this is experimental
data) to one or more models. Works fine.

Tim


"Jay Somerset" wrote in message
...
On Thu, 17 Mar 2005 09:48:39 +0100, "Darius Blaszijk"
wrote:

Jay,

What I meant was the following; y = a*x1^2 b*x1*x2. But in fact it
does not
matter as I need a general method.


It certainly does matter. But if you have already decided that you
don't
need a definitive expression with coefficients, then no amount of
advice is
going to help you. Sad to say, it seems as though you do not
understand
least squares fits.


Kind regards, Darius Blaszijk




"Jay Somerset" schreef in bericht
...
On Thu, 17 Mar 2005 00:25:44 +0100, "Darius Blaszijk"
wrote:

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


You seem to be missing something. You can't fit the formula as
you wrote

it.

What coefficients are you trying to determine? Do you really
mean you

are
trying to find "a" and "b" that best fit the equation y = a*x1^2
b*x1*x2,
or y= a*x1*(x1 + b*x2) or y= x1*(a*x1+b*x2), or something else?

--
Jay.
(remove dashes for legal email address)



--
Jay.
(remove dashes for legal email address)



Reply
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 09:23 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"