I want to run a multiple regression in EXCEL with constraints (all coefficients >= 0 and sum of all coefficients =1). Want to find the best fit regression line equation with the mentioned constraints.
I would like to know different options to achieve my objective and which one would be quick and easy.
I have around 230 rows of data with 10 independent variables.
I am attaching data file.
I am new to EXCEL.
Things I am contemplating about are: Using LineST function, using solver etc.
Is it possible to club the constraints with LineST function?
Is it possible to use Solver for achieving my objective?
Can I do it through macro using LineST?
Please guide. Your help is very much appreciated.
Note: No constraints on intercept in the regression equation.
Bookmarks