Multiple regression in Excel using the Data Analysis add-in

The Data Analysis add-in gives you a lot more information than using =LINREG() by hand, and does not require using an array formula, but does not update the results if the data changes.

To see how to add in the Data Analysis pack, see

This video used to be titled "Multivariate Regression...", but technically that refers to having more than one "Y" or output variable, while "Multiple Regression" refers to having more than one "X" or input or predictor variable. But many people confuse the two terms.

[loopooillohg]

thanks for this mate, really loud and easy to hear! doesn't sound like you recorded this through your desk fan at all!

[skifri]

thanks for the video - as Philip Chang pointed out below this is multi-variable regression analysis, not multivariate. might want to change the title.

[MeMeow]

how the hell is this a multivariate regression. you mean multi variable?

[pegz]

You really have to check if you're doing the right thing before uploading "tutorials" This will confuse beginners like me. Luckily I saw the Philip Chang's comment