Using Microsoft Excel for Simple Linear Regression - Analytics

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

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

  • @TheLuqmanhalim
    @TheLuqmanhalim 4 года назад +2

    Great explanation and very helpful. May sir make a fortune

  • @adiilahrawi4245
    @adiilahrawi4245 4 года назад

    Hi sir. I got a question regarding to the Confidence Interval. What is the conclusion can be made if there is 0 in between the lower 95% and the upper 95% ? 😅 For example Lower 95% = -20.432 and the Upper 95% = 4.105

  • @pabloexgf
    @pabloexgf 4 года назад

    Sir, what if my regression equation from scattered plot and the coefficient is not significant? my beta 1 is different. which one to follow to do hypothesis?

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

      Your equation from the scatter plot and the simple linear regression must be the same. Check if you are placing you independent and dependent variable correctly when running simple linear regression or either when doing scatter plot. I think that is the problem.

    • @pabloexgf
      @pabloexgf 4 года назад

      @@jskeshminder4627 ohh i see. sir, is it okay if my regression result is not the same like others? the data is still the same but mine is differ than others. and one more question sir, why on 4:52 your regression result is different, but then suddenly it seems like you made some amendments there? like your significance F you've highlighted is different than before.

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

      @@pabloexgf The results are the same i have round up the figures to three decimal points. The F value is the same. Is almost zero (E-13). You results should not differ from others.

    • @pabloexgf
      @pabloexgf 4 года назад

      @@jskeshminder4627 i see alright, thank you so much sir! :)