linear model with solver

V

vert

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

Y X1 X2
2,3 0 5,98
2,167 1,76 0,64
2,484 0,82 6,16
2,804 2,99 2,56
2,682 0,3 4,19
0,311 0,12 0,3
0,147 0,11 0,14
1,396 1,58 1,8
0,516 0,6 0,41
0,679 0,35 0,23
1,038 1,45 0,76
1,323 1,95 0,67
1,491 1,77 1
2,524 2,32 2,93
1,906 2,34 0,54
0,187 0,3 0,21
0,401 0,53 0,22
0,185 0,28 0,27
0,234 0,25 0,16
0,368 0,36 0,26

Anyone who could help me whit this?
 
T

Tushar Mehta

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
 
Top