Standard Error of the Mean in Excel

[@Steelxfaze]

man's unknowingly saving students' research time

[@VivoPhys]

Happy to help.

[@lc4979q]

PERFECT example of how you make a tutorial. Thankytou

[@VivoPhys]

You are welcome.

[@chae5833]

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

[@VivoPhys]

Glad it helped

[@roryjamieson60]

If I could like this twice I would - thanks!

[@VivoPhys]

I'm glad it was helpful.

[@pulikasapha2459]

Perfection. Straight to the point

[@VivoPhys]

Thank you!

[@natizur]

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

[@o.n.e-onlinenaturaleducati5597]

You have just saved my life, thank you!

[@VivoPhys]

I'm glad it helped.

[@koushalyadangwal9981]

Thank you for simplest explanation.

[@VivoPhys]

I'm glad it helped!

[@user-cq6zt1zi5r]

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

[@VivoPhys]

I'm glad you're finding it useful.

[@shailashinde7187]

Thank You, Sir, for short and Simple explanation.

[@Roobivanz]

You hit the point, Dr. Thanks a ton

[@VivoPhys]

You are welcome.

[@sunkumargurung1172]

Greatly appreciate it

[@VivoPhys]

You are welcome.

[@laurenardoin]

You are a lifesaver!

[@VivoPhys]

I'm glad it helped.

[@davidm4356]

Thank you prof 👨‍🏫

[@VivoPhys]

Happy to help.

[@davidm4356]

@@VivoPhys you truly did sir . My first year in college and prof’rs don’t even explain the content .

[@chamithulani225]

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

[@VivoPhys]

I'm glad it helped.

[@sotadeayopo4597]

Thank you so much for this video

[@VivoPhys]

You are very welcome.

[@mountcarmel7116]

Thank you so much! absolutely fantastic!!!

[@VivoPhys]

You are welcome.

[@sanaarshadt]

Thank you. Thank you. Thank you.

[@VivoPhys]

You are welcome!

[@leeotoo393]

Thanks

[@VivoPhys]

You are welcome.

[@varsamiamanolopoulou3286]

ευχαριστωωω ρε αλανι με εσωσεςςςςς

[@VivoPhys]

I'm glad it helped.

[@dedgar6161]

your a life saver

[@VivoPhys]

I'm glad it helped.

[@parisajabari3667]

Perfect Thank you so much 👌👌

[@VivoPhys]

You are welcome.

[@parisajabari3667]

@@VivoPhys Thank you

[@falah70hasan44]

THANK YOU IT WAS REALLY GOOD

[@VivoPhys]

Glad you found it helpful!

[@konan8353]

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

[@anuradhapandit9824]

thank you!

[@Jasmine-ou2ig]

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.

[@VivoPhys]

I'm unfamiliar with this, so I don't think I can be much help. Sorry.

[@lazarus8011]

Many thanks

[@VivoPhys]

I'm glad it was helpful.

[@FioraLeeMcDaidMecale]

Thank you! this was a great help

[@VivoPhys]

You are welcome!

[@ashleighdrake1621]

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

[@VivoPhys]

I'm glad it helped!

[@hussainyasin7239]

thx blood

[@danielstacey2660]

Brilliant, thanks

[@VivoPhys]

I hope it helped.

[@throxlol8107]

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!

[@VivoPhys]

Hi ThroxLoL. The standard error of the mean is essentially a measurement of the accuracy of the mean value calculated. So the SEM value should be calculated using the same data as the mean (i.e., the group data for a group mean and the full sample data for a full sample mean). Whether or not to include potential "outliers" in your data or remove them is a tricky topic. People do not always agree. If you are removing them from your mean calculations you should do the same for your SEM calculation. I will have a video coming out soon talking about one method of detecting potential outliers soon.

[@fatimaothman1241]

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

[@VivoPhys]

Hi @fatimaothman1241. Best practice is to always do a normality test when doing parametric statistics. This is because parametric inferential statistics tests assume a normal distribution of the data. I do not believe SEM relies on a normal distribution, but I could be wrong. I'm not a statistician. Hopefully someone else well answer. If you find a definitive answer please respond back to this comment so I know too. Thanks.

[@davidngenda5019]

Any ebook one can recommend for the SEM?

[@VivoPhys]

Not that I know of sorry.

[@anthonyvillarama6806]

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

[@VivoPhys]

Hi Anthony. On a quick search of standard error of the mean equations online, I see the same equation you are citing here (using the population standard deviation equation instead of the sample standard deviation equation within SEM calculations). I am not a statistician. I am an end user of stats, so I am not 100% sure which is best. My rationale for using the standard deviation of the sample instead of standard deviation of the population within the SEM equation is because I have a sample that I am attempting to generalize to the population. Generally speaking, using the standard deviation of the population equation when you are inferring information about the population based on a sample will result in a smaller estimate of SEM. For the rest time point in the video above you would get a SEM using the standard deviation of the population of 3.48. Using the sample standard deviation equation gives a more conservative (larger value) for SEM. See the websites below for additional details. I also reached out to a biostatistician from my university to double check my thought process here. She said, "What you did is correct. The population standard deviation is usually unknown, the sample standard deviation is an estimate of it." If you have some quality resources on this topic or a counter argument please share them here. Thanks for the thought provoking comment. statistics.laerd.com/statistical-guides/measures-of-spread-standard-deviation.php www.graphpad.com/support/faqid/1383/

[@mahalakshmirajendran7494]

Thank you so much yar

[@VivoPhys]

Your welcome

[@mmoney1712]

Perfect

[@VivoPhys]

I'm happy it helped!

[@mukhriz195]

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?

[@VivoPhys]

I guess you would need to include all the values in the array used in the formula.

[@eveberry9215]

sir, why is my SEM range from 0-0.1?

[@VivoPhys]

If you did it correctly your data must be very close together.

[@SubatomicStrangelet]

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

[@VivoPhys]

I think you might be mixing concepts. Look up standard deviation of a sample vs population. I think that's what you are thinking about.

[@mohitkarmavat4979]

JALDI BOL,SUBAH PANVEL NIKALNA HAI BHAI

[@VivoPhys]

Please translate to English if possible.

[@user-ff2gc4xy2o]

Thanks

[@VivoPhys]

You are very welcome.