Calculating Mean, Standard Deviation & Error In Excel

In this video, I will show you how to calculate the mean (average), standard deviation (SD) and standard error (SE) of the mean by using Microsoft Excel.
BREAKDOWN
Mean: 00:27
Standard deviation: 01:10
Standard error: 01:52
THE ONLINE GUIDE
toptipbio.com/mean-sd-se-excel/
HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Laptop amzn.to/38bB7JG
Microphone amzn.to/2OFn1sd
Screen recorder & editor techsmith.z6rjha.net/BQQkL
RUclips SEO www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website toptipbio.com/
Facebook / toptipbio
Twitter / toptipbio
AFFILIATE DISCLAIMER
Top Tip Bio is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to www.amazon.com. We will earn a commission from Amazon if a purchase is made through the affiliate links.

[@StevenBradburn]

THE ONLINE GUIDE
toptipbio.com/mean-sd-se-excel/

[@manghudart1329]

It's already 3 am and I haven't finished my assignment but with this. I can sleep now. Bro, I'm really thankful for your tutorial. Stay safe!

[@ian_millerrrr]

Felt that, except it’s 3 PM

[@christiancaldwell7991]

Felt that, except it's 12am

[@bigboyjavy1446]

Ngl, your videos are carrying me in my statistics class rn. I hope you know how much stress you have alleviated for thousands of people, thank you.

[@misssatinskin]

This was awsome, simple and to the point! Thank you for this. The formula I had was missing a factor and it was driving me insane.
Thanks for sharing.

[@raahim11]

This is damn useful for my Math and statistics exam in the morning tomorrow.
Excel is definitely one of the best skills a person can learn.

[@jerjc99]

Exceptionally helpful video. Very well thought out and presented with absolute clarity. Thank you very much indeed for posting.

[@geraldehannahcrisf.525]

AMONG ALL THE VIDEOS I WATCHED, I ONLY UNDERSTOOD YOURS!!! THANKYOUUUSOMUCHHHH!!!!

[@jawaher1122]

Cannot describe how much I thank you 🙏

[@JayGolsenMUNAM-od2hd]

Thank you this Tutorial is more helpful and brief. Great work and Happy to watch more from you!!

[@sheenamaealava5257]

thanks to you sir for sharing the idea on how to solve this,it really helps me

[@faizahmad6070]

So crisp and simple.. 😊

[@elainerau1891]

Thank you for the excellent directions and definitions!

[@StevenBradburn]

You're very welcome!

[@tramelparker2085]

Yes thank you ..: I’m working on a project for work 👏🏼👏🏼

[@jackj.4304]

The best. You are master of education.

[@369acon]

Very helpful.

[@kehindetijani2815]

Made it look very simple👍

[@swetashukla8234]

Thanks for this Video

[@Riti-vn6ip]

very helpful

[@rochgtv]

i love you. ty bro!

[@zalavijay9675]

Superb👍👍👏👏

[@_patience1001]

Thank you very much

[@juhikiran2468]

Nice explanation

[@sallouma5393]

Thank you

[@danijelavasilic5289]

Thank you very much! Simple and nice explained

[@StevenBradburn]

You are welcome!

[@MashanChaudhry]

Thanks mate

[@laurenshelley5113]

Thanks

[@dragongirl7473]

thank you :)

[@parimojesh1051]

Very nice

[@habibaabdulkadir1756]

About to watch, I hope it solves my problem

[@StevenBradburn]

Let me know if it helps :)

[@fasihakhan5319]

wao .. Its so simple

[@profmanjeet]

very useful,thank you so much

[@StevenBradburn]

Very welcome

[@ingyavivian2532]

Thank you sir. This was really helpful

[@StevenBradburn]

Glad it helped

[@shanequigley7552]

Legend

[@LuciaFinstra]

Thank you very much! :)

[@StevenBradburn]

You're welcome!

[@aishakhan4297]

Thank you sir for shearing this vedio. You solved my major problem.
Million of thanks 🌹🌹

[@StevenBradburn]

You are very welcome

[@aishakhan4297]

@@StevenBradburn
Thank you
Stay blessed always

[@ubuntujackson9133]

But what if we have frequencies? There are cases where we have table with the x and then the number of times x occurs. But I can't find any tutorials on how to do that.

[@meenakshisakthi5747]

Super u r god- like now...plz do more videos

[@StevenBradburn]

I have more videos coming up soon :)

[@zainsaeed147]

Whats the acceptable range for standard error ??

[@Noone-of-your-Business]

Thanks. But what do these _mean?_ How do you *interpret* these values?

[@lornacrean2136]

Thank you for this - so helpful! Do you know how to create a bar chart representation of this?

[@lornacrean2136]

Never mind, I was able to work out from your error bar video - for anyone else, just run the same procedure he uses with stds for standard errors!

[@zeeshanqasim8925]

Hy sir, I hope you will be good. Actually, I have an understanding of SD and ANOVA. However, I am dealing with a bit larger experimental data. At this instant, I am unable to ponder how I will apply SD and ANOVA on my entire data set. Whether I have to do both tests first between the groups (number of days) separately or I have to apply to the entire data set at once? Since most of the videos on youtube redundantly explained these methods. But, none of them focused to give an example dealing with a real-time data analysis in research. If you say, I can send you my data, So, you can show it on the video here.

[@ourmuse]

Sir, can i know how much data necessary/enough for me to conduct this analysis?

[@eloinzyy]

Hello! How about calculating the STDEV by each indicators? How to calculate that? Still the same? Like for instance, calculating all the STDEV on one indicator comprising of 6 questions. Should I calculate all of the STDEV of 6 questions then proceed to calculating all 6 STDEV to get the whole STDEV on one indicator? Is that how it works?

[@shafiqshakil-9477]

Thanks, very helpful. But I want to know, What difference Standard error and standard error mean?

[@StevenBradburn]

It depends on the context. If the statistic of interest is the mean, then it is more precise to say standard error of the mean. Some people just shorten this to standard error. Note, you can get he standard error of other statistics, such as the median.

[@lizliz5162]

Is this the same as error propogation?

[@jessamelendez393]

What if there is no STDEV alone in the option? What are there are STDEVA, STDEV.P, or STDEV.S? What should I click?

[@shathaomar1516]

How to convert from SEM to SD PLEASE?

[@nadanada-pk4bk]

Why I get this error Div/0!??

[@user-zj7cr2pg7c]

watched 2023.9.23

[@sonali917]

Thanks

[@StevenBradburn]

Welcome