Multiple Regression: How to Test the Significance of the Coefficients in Excel 2016

แชร์
ฝัง
  • เผยแพร่เมื่อ 22 ธ.ค. 2024

ความคิดเห็น • 27

  • @alishastory2591
    @alishastory2591 5 ปีที่แล้ว +6

    Seriously! This lecture has saved my semester! THANK YOU for providing an intuitive and thorough explanation of these concepts.

  • @d.263
    @d.263 5 ปีที่แล้ว +2

    THANK YOU!!! You just literally changed my life, and saved me from going insane. I've been doing problems by hand all semester. I used to hate Excel but now I'm its biggest fan. Thank you!

  • @darkovulin1114
    @darkovulin1114 4 ปีที่แล้ว +2

    Finaly I found solution to my problems. Greetings from Croatia. Thanks

  • @relaxbro5605
    @relaxbro5605 5 ปีที่แล้ว +1

    I just stumbled upon this channel and I am so amazed and grateful! Thank you so much for sharing your knowledge! I wish there were more people like you! THANK YOU SO MUCH

  • @SherynD43
    @SherynD43 4 ปีที่แล้ว +2

    Your videos are extremely helpful and you have a gift of teaching. Thank you for posting this!

    • @DavidDunaetz
      @DavidDunaetz  4 ปีที่แล้ว

      Thank you. That's very encouraging!

  • @madelinerose-m4q
    @madelinerose-m4q 2 ปีที่แล้ว

    Thank you! You are a great teacher. I have a question on my homework about the degrees of freedom for the t test of the regression coefficients. I’m still unsure of that

    • @DavidDunaetz
      @DavidDunaetz  2 ปีที่แล้ว +1

      The degrees of freedom for the t is N - # of predictors - 1.

    • @madelinerose-m4q
      @madelinerose-m4q 2 ปีที่แล้ว +1

      @@DavidDunaetz You’re a god send haha. I have to submit it today 💜

  • @claireli5044
    @claireli5044 4 ปีที่แล้ว +1

    Should it be the older the people, the fewer people like Justin B. since the slope coefficient is minus?

    • @DavidDunaetz
      @DavidDunaetz  4 ปีที่แล้ว

      More precisely, we should say that the negative coefficient indicates that the older the people in the sample were, the less they liked Justin Bieber.

  • @rosaliaagioutanti2768
    @rosaliaagioutanti2768 5 ปีที่แล้ว +1

    Thank you so much for this lecture!

  • @nwanerichidinma6666
    @nwanerichidinma6666 3 ปีที่แล้ว +1

    needed this, thanks

  • @izzatijamil118
    @izzatijamil118 3 ปีที่แล้ว

    Thank you, Sir 👍 good lecture & really helpful 😍

    • @DavidDunaetz
      @DavidDunaetz  3 ปีที่แล้ว +1

      I'm glad you found it useful.

  • @sineeeeeem
    @sineeeeeem 4 ปีที่แล้ว

    Hi, thanks for the video, it is very helpful. I have question regarding the t-stat. So it is not important that the t-stat is positive or negative, because excel is using a two tailed t-test in the regression? so as long the p value is under 0.05 for alpha = 5% then the coeff. is significant right?

    • @DavidDunaetz
      @DavidDunaetz  4 ปีที่แล้ว +1

      That is correct. We don't pay attention to the sign of the t-stat. If p < .05, the coefficient is significant in the regression analysis. The sign of the coefficient, on the other hand, is very important.

    • @sineeeeeem
      @sineeeeeem 4 ปีที่แล้ว +1

      @@DavidDunaetz thanks a lot for your fast reply David!

  • @SMGNAVEEN
    @SMGNAVEEN 5 ปีที่แล้ว

    where do i get that excel file (data-chapter supplement multiple regression salaries. xlxs) sir

    • @DavidDunaetz
      @DavidDunaetz  5 ปีที่แล้ว +1

      The link is in the description of the video. Expand it so that you can see all the links. The file's address is: www.dropbox.com/s/jga1j4tshqkwej3/Chapter Supplemental Multiple Regression Salaries.xlsx?dl=0

    • @SMGNAVEEN
      @SMGNAVEEN 5 ปีที่แล้ว +1

      @@DavidDunaetz thank you so much sir

  • @nickfleming3719
    @nickfleming3719 4 ปีที่แล้ว +1

    talk about the t-stat!

    • @DavidDunaetz
      @DavidDunaetz  4 ปีที่แล้ว

      The t stat is calculated from the standard error. It's the statistic that it used to determine if the coefficient is significant or not.

    • @madelinerose-m4q
      @madelinerose-m4q 2 ปีที่แล้ว

      @@DavidDunaetz what would the degrees of freedom for it be?

    • @DavidDunaetz
      @DavidDunaetz  2 ปีที่แล้ว

      The degrees of freedom for the t is N - # of predictors - 1.

  • @mohammedbinabdullah6869
    @mohammedbinabdullah6869 6 ปีที่แล้ว +1

    Thank you