ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   create a multivariable regression in excel without using array (https://www.excelbanter.com/excel-worksheet-functions/41857-create-multivariable-regression-excel-without-using-array.html)

dls

create a multivariable regression in excel without using array
 


Conrad Carlberg

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