Hypothesis t-test Template for mean in Excel/Google Sheets | Critical & P-values

Поділитися
Вставка
  • Опубліковано 1 жов 2024
  • This video shows examples of how to use provided Google Sheets/Excel template to conduct significance tests for one population/sample mean, using both critical region and p-value approaches.
    Google Sheets/Excel Template: tinyurl.com/4p...
    z-test template: • Hypothesis Z-test for ...
    proportion (p) template: • Hypothesis Test for Pr...

КОМЕНТАРІ • 7

  • @joshemman
    @joshemman  9 місяців тому

    Excel Template direct download link: drive.google.com/uc?export=download&id=1zPpIRXYrWDnDnZ8z2adKGiq379c_Y4aw

  • @Kim-ej2xm
    @Kim-ej2xm 10 місяців тому +2

    I am finding it difficult to understand inference statistics and it is the hardest portion for me to cover.

    • @joshemman
      @joshemman  10 місяців тому

      Try watching a few videos in this playlist. It should help. ua-cam.com/play/PLD3fYc0bAjC-TuLdj2rQ7mOw_KfcQkvK3.html

    • @Kim-ej2xm
      @Kim-ej2xm 10 місяців тому +1

      @@joshemman 👍 thanks

  • @hectornetdev
    @hectornetdev 6 місяців тому

    Hello, the template on the link is not the same as the video. Otherwise great content and thanks. I learned a lot more from you than Pearson.

    • @joshemman
      @joshemman  6 місяців тому

      The template for the t-test is in the third sheet.

  • @mavi409
    @mavi409 10 місяців тому

    I have an assignment that asks : FIND A SERVICE MANAGEMENT PROBLEM SOLVED USING LINEAR PROGRAMMING AND EXCEL SOLVER AT LEAST (lindo/lingo ,gams as well )please any suggestions on what kind of service i can choose to work with!