Dear junk,
Such a task is indeed accomplished in Excel easily. You have to just
remember that it's a spreadsheet, and there are certain ways that
spreadsheets operate, and that's the key to the solution. I would tell you
more, but it would be horrible if by doing so I facilitated a student's
cheating.
Identify yourself, sir/madame, and if yours is a legitimate request, I'll
write more.
ZT
----- Original Message -----
From: junk <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 13, 2000 1:29 AM
Subject: Multivariable regression
> Can anyone direct me to an Excel wizard or, if none is available, a
formula
> to do the following. Note I do not have access to Maple, Matlab,
> Mathematica or any other statical or engineering software.
>
> Why I am trying to do is come up with a simple method of doing a
> multivariable (multidimensional ?) least squares approximation.
>
> How could I easily create:
> Y = (a1*A^4 + b1*A^3 . e1*A + f1) + (a2*B^4 .. + f2) + (a3*C^4 +.+f3)
>
>
> ****Note that basic regression will not work in the real problem. Need
> multiple exponents*****
>
>
> from the data below:
>
>
> A B C Y
> paint engine amenities price
> 0.1 1 6 $1000
> 0.11 2 5 1200
> 0.14 1 3 1150
> 0.16 2 5 1200
> 0.2 1 4 3000
> 0.201 4 5 2700
> 0.3 2 3 4000
> 0.33 4 7 3500
> 0.35 1 4 6000
> 0.4 2 6 4650
> 0.41 3 4 4400
> 0.42 4 3 4750
> 0.44 1 5 5360
> 0.45 1 3 7500
> 0.6 3 3 7400
> 0.8 2 5 7700
> 0.87 2 6 8500
> 0.88 3 5 9000
>
>
>
> Basically, I would like to create a formula for a price estimator based on
> three input variables and one output (price). I am hoping to do something
> quick and simple in Excel.
>
> Any help would be appreciated.
>
> thanks,
>
> Nathan
>
>
>
>
>
>
> =================================================================
> Instructions for joining and leaving this list and remarks about
> the problem of INAPPROPRIATE MESSAGES are available at
> http://jse.stat.ncsu.edu/
> =================================================================
=================================================================
Instructions for joining and leaving this list and remarks about
the problem of INAPPROPRIATE MESSAGES are available at
http://jse.stat.ncsu.edu/
=================================================================