Using Microsoft Excel to check for Multicollinearity

Поделиться
HTML-код
  • Опубликовано: 11 сен 2024

Комментарии • 8

  • @zer0ix956
    @zer0ix956 3 года назад +1

    If I want to remove the multicollinearity, which variable that I should remove? x1 or x2?

  • @azizanhamid4447
    @azizanhamid4447 3 года назад +1

    Hello sir. Is it possible for the data to have 2 dependant variables? For example bowling games; the labels are won, lost, strike, spare, 1 pins, 2 pins, etc. So the dependant variables are both won and lost? Or multicollinearity only have 1 y and all the other is x?

    • @jskeshminder4627
      @jskeshminder4627  3 года назад +1

      Speaking about regression there is only one dependent variable.
      You can have two models each with a different dependent variable

    • @azizanhamid4447
      @azizanhamid4447 3 года назад

      @@jskeshminder4627 noted Dr. Thank you for your respond👍

  • @josephdaquila2479
    @josephdaquila2479 Год назад

    Why is it compared to the value of 0.7?
    Also when you compare the negative value to 0.7 I'm assuming you're actually looking more at the absolute value?

  • @jeanmarcwade1260
    @jeanmarcwade1260 3 года назад

    According to which rule one can assume that there is or no collinearity between independent variables? can't hear well.

    • @jskeshminder4627
      @jskeshminder4627  3 года назад

      You have to check for multicollinearity

    • @jskeshminder4627
      @jskeshminder4627  3 года назад

      Watch 2:47 - Value > 0.7,. However, there a various thresholds - read on VIF