Forum Discussion

hsnady's avatar
hsnady
Copper Contributor
Jan 29, 2020

linear multivarient regression analysis

How to perform linear multi variant regression analysis on excel. need to compare 4 variables to one independent variable.
excel
PReagan's avatar
PReagan
Bronze Contributor
Jan 29, 2020

Hello hsnady,

 

That could be with the Solver Add-in or LINEST() function. Refer here:

https://www.ablebits.com/office-addins-blog/2018/08/01/linear-regression-analysis-excel/

hsnady's avatar
hsnady
Copper Contributor
Feb 02, 2020

PReagan 

 

Found simple linear regression analysis but not for multiple variables i.e., one independent and 5 dependent variables.  Any more suggestions?

Resources