Calculating the Standard Error of the Mean in Excel

This video explains how to calculate the standard error of the mean (SEM) and the 95% confidence interval in Microsoft Excel. The differences between the standard error of the mean and the standard deviation are explained.

[lelksldfsjwjdo]

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.

[thecorgisquad]

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

[n-sh]

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

[thomasstarr]

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

[drkarenswrld]

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

[johnnysturgis]

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

[jrlemony]

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.

[fatimaothman]

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

[hrsdarwish]

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?

[Rashhey]

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

[maxwelltchoffo]

Sir can you please explain how you got 1.96?

[Pixieburglar]

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

[Rashhey]

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.