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

2 Replies

  • 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