Calculating the Standard Error of the Mean in Excel

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

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

  • @thecorgisquad9861
    @thecorgisquad9861 8 лет назад +2

    Nice, simple explanation. Standard error of the mean is calculated by dividing the standard deviation by the square root of the sample size.

    • @melissaclendaniel9811
      @melissaclendaniel9811 8 лет назад

      Now this is a concept that I am familiar with- calculating the range of error by dividing the standard deviation by the square root of the sample size

  • @lelksldfsjwjdo
    @lelksldfsjwjdo 6 лет назад

    At 3:02 to 3:27, 25 seconds, Dr. Grande explained the concept of standard error, and how it differs from standard deviation, which I could not find in five hours of googling the internet. This highlights the well-known problem in science writing, and Grande has defeated it with his own style. Sir, if I could give you 100 thumbs-up I would. Thank you.

    • @DrGrande
      @DrGrande  6 лет назад

      You're welcome - I'm so glad you found this explanation of the standard error to be helpful -

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

    😮😮😮😮😮😮😮😮😮😮😮😮😮😮😮😮😮😮😮😮
    Dr. Grande!!!!!!!!!!!
    I know you from 2023 True Crime/News Analysis!!!
    My mind is blown that you came up when I googled this topic😮😮😮😮😮😮😮!!!!!!!

  • @n-sh2014
    @n-sh2014 4 года назад

    Hi Dr. Todd. Many thanks for such an informative and easy to understand tutorial.

  • @thomasstarr6433
    @thomasstarr6433 9 лет назад

    Yet again, very clear on the steps and the reasoning behind the process. The clarification with Gregory below was also helpful.

  • @johnnysturgis6904
    @johnnysturgis6904 8 лет назад

    Thanks so much for this Todd! Needed SEM for my anthropometry assessment measures.

  • @jrlemony
    @jrlemony 6 лет назад +1

    You should write out the formulas in the information section. Makes it easier than hitting rewind a dozen times if we can't understand you.

  • @melissaclendaniel9811
    @melissaclendaniel9811 8 лет назад

    This video is easy to follow- mostly because I am familiar with this concept.

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

    where did u get 1.96 from sir?

  • @fatimaothman1241
    @fatimaothman1241 11 месяцев назад

    Why SEM is high in some studies? What may cause that?

  • @Rashhey
    @Rashhey 8 лет назад

    SEM and SE of mean are two different thing.
    SEM - Standard Error of Measurement
    SE of Mean - Standard Error of Mean

  • @hrsdarwish306
    @hrsdarwish306 5 лет назад

    Isn't SEM the SD of the population divided by the square root of the sample size? Why are we using the SD of the sample in this case?

  • @TiffGrigg
    @TiffGrigg 6 лет назад

    Thanks for your help!

    • @DrGrande
      @DrGrande  6 лет назад

      You're welcome!

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

      @@DrGrande
      Mr Todd you explain nicely.
      Thank you sir

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

    Sir can you please explain how you got 1.96?

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

      I think the 1.96 has to do with the “n” sample size of 20. If you have a sample size of 25, then the 1.96 would be increased to 2 and if you wanted to increase the confidence interval of that same 25 sample size up to 99.7 confidence interval then you’d use a 3 instead of the 1.96

  • @emmanuelk-amoah698
    @emmanuelk-amoah698 7 лет назад

    Thank you very much!

    • @DrGrande
      @DrGrande  7 лет назад

      You're welcome, thanks for watching -

  • @Rashhey
    @Rashhey 8 лет назад +1

    I am afraid you're incorrectly calculating 95% confidence intervals.
    95% Confidence Interval = mean (-/+)1.96 * SD.
    You are effectively calculating Margins of Error = (-/+)1.96 SE * mean.
    They are useful especially for Bland Altman (measurement of agreement)
    Regarding the value of 1.96
    if you plot random sample which should give you a graph of normal distribution and calculate SD and mean. You can mark those intervals on both ends and visually check if the 95% of your data lies within these limits.

    • @DrGrande
      @DrGrande  8 лет назад

      +Peter R. The calculation (Mean +/- (SE * 1.96)) is for the 95% CI of the mean. It is to estimate the true population mean based on a sample.

    • @juded14
      @juded14 7 лет назад

      Peter R. Can I ask where 1.96 comes from? what is it exactly?