software

I have to make a model Y=a*X1 b*X2 c with Solver when a, b and c are the
tuning parameters. And then make a figure which shows the values of Y and
the model values.

I have this data set, which have the values to Y, X1 and X2

YX1X2
2,305,98
2,1671,760,64
2,4840,826,16
2,8042,992,56
2,6820,34,19
0,3110,120,3
0,1470,110,14
1,3961,581,8
0,5160,60,41
0,6790,350,23
1,0381,450,76
1,3231,950,67
1,4911,771
2,5242,322,93
1,9062,340,54
0,1870,30,21
0,4010,530,22
0,1850,280,27
0,2340,250,16
0,3680,360,26

Anyone who could help me whit this?

Check out the XL help for the LINEST function. It contains an example of a
multi-variate regression very much like what you want.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article gt;,says...
gt; I have to make a model Y=a*X1 b*X2 c with Solver when a, b and c are the
gt; tuning parameters. And then make a figure which shows the values of Y and
gt; the model values.
gt;
gt; I have this data set, which have the values to Y, X1 and X2
gt;
gt; YX1X2
gt; 2,305,98
gt; 2,1671,760,64
gt; 2,4840,826,16
gt; 2,8042,992,56
gt; 2,6820,34,19
gt; 0,3110,120,3
gt; 0,1470,110,14
gt; 1,3961,581,8
gt; 0,5160,60,41
gt; 0,6790,350,23
gt; 1,0381,450,76
gt; 1,3231,950,67
gt; 1,4911,771
gt; 2,5242,322,93
gt; 1,9062,340,54
gt; 0,1870,30,21
gt; 0,4010,530,22
gt; 0,1850,280,27
gt; 0,2340,250,16
gt; 0,3680,360,26
gt;
gt; Anyone who could help me whit this?
gt;