How to use excel to do forward selection

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

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

  • @vadimpavlov6037
    @vadimpavlov6037 8 месяцев назад

    This helped me immensely. Thanks!

  • @Dr.MallikarjunaHBKSNUAHSShivam
    @Dr.MallikarjunaHBKSNUAHSShivam 3 месяца назад

    thank you very much......explained systematically........really superb...

  • @AbenezerBamlakuAssamnew-qb5zi
    @AbenezerBamlakuAssamnew-qb5zi 8 месяцев назад +1

    Thanks a lot doctor

    • @DrJiangJingze
      @DrJiangJingze  8 месяцев назад

      I am glad it's helpful! You are welcome!

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

    nicely explained

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

    Thank you for teaching, really helpful

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

      You are very welcome! I am glad it is helpful.

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

    GREAT VIDEO, it helped me a lot for my college homework, thank you so much

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

    Thank you teacher

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

    Thank You Doctor

  • @vaquita7118
    @vaquita7118 2 года назад +1

    Thank you for this great video. I have a question: When should one use the T stat or r2 among the statistically significant items to determine the next item to add to the model instead of the lowest p among those statistically significant?

    • @DrJiangJingze
      @DrJiangJingze  2 года назад +1

      Hi Isaac, I am glad you liked the video. For T-stats and P-value, they are like two-side of the same coin. P-value and T-stats just have different threshold, but the variables selected under the P-value should also be selected by using T-stats. We prefer the P-value, because the P-value threshold (0.05, or 0.01)is always the same regardless what kind of test you are performing in any situation (F-test, T-test etc.).
      Regarding R2, we have different selection method, called stepwise selection, we will use R2 to form a F-test. However, it will be computation intensive, if you only have excel. If you have other software, such as SAS, MATLAB, STATA, they have pre-built functions allowing you to construct F-test to do the model selection. If you only have excel, Forward-selection using P-value is preferred.
      Please let me know if this is helpful. Good luck!

    • @vaquita7118
      @vaquita7118 2 года назад +1

      @DrJiang Jingze your response was very clear and helpful!! Thank you for your help, doctor. Your videos are very educational and a blessing.