Standard Error of the Mean in Excel

This video shows Dr. Evan Matthews explaining how to calculate a standard error of the mean in Excel. The sample data in this video represents the heart rate of several participants at rest and during increasing levels of exercise intensity.

Calculate an average in Excel.

Standard Deviation in Excel

Excel Skills Playlist

Link to Dr. Evan Matthews website.

[Steelxfaze]

man's unknowingly saving students' research time

[chae]

Fantastic, exactly what I was looking for. Short and to the point. You rock!

[natizur]

Omg, thank you so much! It helped me A LOT! best video, direct to the point and easy to understand! Thank you, really! :)

[roryjamieson]

If I could like this twice I would - thanks!

[shailashinde]

Thank You, Sir, for short and Simple explanation.

[lcq]

PERFECT example of how you make a tutorial. Thankytou

[o.n.e-onlinenaturaleducati]

You have just saved my life, thank you!

[mountcarmel]

Thank you so much! absolutely fantastic!!!

[cqztzir]

thank you very much sir, you are a true life saver i have subscribed to your channel and i am going to share it right away

[chamithulani]

thank you very much... its short and good.its very helpful me

[Jasmine-ouig]

Hi Evan, thank you for the explanation. I have seen some of your other videos about how to present data like in research papers and it was really a great help!
I have a question concerning the calculation of SEM when I want to transfer my raw data to % normalized to control, but I don't know how to convert the SEM so that it matches the figure. I have seen it on other papers, where SEM or SD values were depicted on the %normalized bar.

[throxlol]

Hi Evan. Great video! I had a quick question about what to do for calculating the SEM in a different circumstance in regard to the sample. So I have my total sample (n = 71); however this sample has been split into 5 different groups (n = 15, 14, 15, 13, 14) respectively. When calculating SEM for the n=15 group for example, do I use the total sample (stdv(of each group)/'root'71) ) or (stdv(ofeachgroup)/'root'15). I'm really confused what to use!

Also, if there are outliers/anomolous results in my data, do I discount these from my calculation of my mean, and subsequent SEM?

Just trying to get my dissertation finished and it's stressing me out! Hope you can help. Thank you for the video!

[konan]

Idk why it's so difficult to find a simple answer to a question on Google, this is exactly what I was looking for. So much other incorrect bullshit for some reason

[ashleighdrake]

Thank you so much!! You deserve my professors salary lol

[davidngenda]

Any ebook one can recommend for the SEM?

[fatimaothman]

If my sample size is small, should i do normality test, why?

[mukhriz]

I have 2 sets of data so i need to find SEM between the data so i just get one value of SEM how to calculate it?

[SubatomicStrangelet]

I thought it was Standard Deviation/sqet(sample count -1), not Standard Deviation/sqrt(sample count)?

[anthonyvillarama]

I think it is wrong. Standard error of the mean is Std.population/Sqrt(n).