create a multivariable regression in excel without using array
|
The description of your problem is a little terse. First, do you mean a
regression equation with multiple predictor variables? Then, functions such as LINEST might be appropriate. Or second, with multiple outcome variables? In that case, you'll have to code your own Householder macro, although the Householder/Ortega/Wilkinson code (which rips, BTW) in VBA is Web-available -- at least, it used to be. And third, it's not clear what you mean by "without using array." C^2 Conrad Carlberg Excel Sales Forecasting for Dummies, Wiley, 2005 "dls" wrote in message ... |
All times are GMT +1. The time now is 03:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com