Without being pessimistic I think you'll struggle to do this mutlivariate
regression in excel. There may be a way but it will be long-winded I am sure.

As a suggestion, stats websites often allow you to input data and see the
output running off Javascript as an example. Try and find a website that you
can cut and paste your data to and crank the analysis...

SAS could do it easily. The R project (google it to find it) offers a free
stats package. It is the update of S and is pretty much as good as it gets.
Upside is that it is free, downside is that it is not user friendly in that
you would have to put some hours in before you got around to doing your
multivariate regression.

Sorry to be a naysayer....


Alex

"showcase48" wrote:

I noticed linest and the regrssion tool doesn't allow more than 16 variables.
Does anyone know the most convenient way to do this? I currently don't have
SAS. Is it possible in Access or anything else?