How To... Calculate Mean and Standard Deviation in Excel 2010

Learn how to use Excel 2010 to calculate the mean (or average) and standard deviation of a range of data. You can do this for two sets of data so that you can compare them to see if they are similar or different.

[@TheElectricBuddha]

I love you. Thank you. Sincerely, an exhausted grad student whose life you just made easier.

[@monicagupta4514]

Thank you! The explanation was short and crisp.

[@tamarastallings1648]

My Lord! Thanks so much for explaining where I can finally understand.

[@rhondaj3117]

Thank you Mr. Loughlin, this is my first time using excel and I really needed a step by step procedure. It was well explained and I was able to complete the question for class.

[@animefan320]

You just saved me a ton of time. This is way quicker than going through all those mathematical formulas myself by hand. Thanks a lot! :D

[@suzu_yuuki]

a 10yr old video helping mw with my engineering data analysis homework in 2022!!
Sir!! Thank you so much for the brief but informative lecture!

[@fumaninjaknownoequal]

Thanks Eugene - really good demo. Needed this for a legal matter - you cant argue with science!

[@EugeneOLoughlin]

Hi "jwheyer" - first, many thanks for watching my video, I hope that some of it was of use to you.
Of course there is more than one way to calculate a mean, and I show both the SUM method (which helps beginners understand what a mean is) and the AVERAGE method. Viewers can choose what ever method they want to use.
Dr. E.

[@thegood_nurse4533]

This video was very helpful. I was drowning in statistics but thanks to you professor I get it now. so simple, easy to follow and on point. :)

[@safderkaplan2200]

Thank you for the video. can I ask a Statistic question (basic) ? could you please help me about it?

[@emanuelrodriguez4566]

Man thanks so much it really helped me finish my lab report.

[@KimAtkins60]

Thank you Mr. O'Loughlin! This has been the most helpful video, very clear and easy to follow. You are a very, very good instructor!

[@charnelee6571]

Thanks so much, i fear if i had not found this i would have failed this section of my units, you are a total gem.

[@trellikardia]

Thank you so much for posting this! It makes it easy to comprehend and doesn't beat around the bush!

[@InsanePanda08]

the best video i have seen related to this topic its quick easy and to the point thanks mate and well done

[@alfredowong2300]

Thank you Mr. O'Loughlin. I just got back in school and could not remember how to calculate average and STD in excel, your video was great! Thank you for taking the time to make it.

[@zenscapemusic18]

omg. this is so helpful for a slow student like me. you explained that very clear and thank you thank you thank you thank you!

[@jonqn07]

Thank you Eugene! Your video is VERY CLEAR and SUPER HELPFUL. Thank you so much for putting out your time to help us all.

[@iTand]

Very helpful. The accent it makes it a lot more pleasant

[@celtic13dandamc]

Thank you very much for this excellent tutorial. Thoroughly helpful, very clear and concise. Made my report far easier!

[@katharinemason9475]

Thank you for the clear explanations and the various methods! Incredibly helpful.

[@victorgalindo2494]

A master teacher! Beautifully explained, thank you.

[@K8WMusic]

I am 26 years old and always struggled with math. I am in grad school using this for a course. I actually cried for three hours. I stumbled upon this video and was able to solve my homework in 15 minutes. You have worked wonders with this video and I hope you realize how much of an impact you just made in my whole life. THANK YOU.

[@EugeneOLoughlin]

:-)

[@theduyendingdongdo]

I really appreciate your information, sir! I used to dislike Excel before, but now you changed my view about it! I was doing my Uni assignment and got stack on my very first question, thank God I found your video! well explained!

[@israamulla6939]

THANK YOU ! 🙏🏻😭❤️ U relieved so much of my SD calculating anxiety. I did not know it was this simple.... !

[@petqueen2]

Your explanations are extremely helpful. You keep it simple which makes it easy to follow. Thank you!

[@hkdoycle]

thank you very much! my stress levels are reduced thanks to your helpful vids but also your extremely calming voice. from a uni student trying to get her maths a level.

[@tinaleonard4568]

Wow, the best video I have seen on doing the standard deviation on Excel. This is the only one that actually makes the task as SIMPLE as it really is! The others really had me overthinking it! Thank you so very much!

[@reaceoneil5699]

Hi, how much to do my homework? I have watched 4 videos today and failed 4 assignments trying to figure out these quantitative problems.

[@kellythompson9714]

Thank you so much for your clear explanation, you have just helped make my life a lot easier.

[@oxXTheMadHattressXxo]

You just made my bio homework so much easier. Thank you!

[@derrickknows6609]

Thank you for this crystal clear explanation

[@damonwilliams4688]

Excellent, your teaching still is perfect for me. Thank you!

[@KO-zf4kp]

Thank you so, so much!!! You are a lifesaver! Your explanations and examples are easy to follow and understand. I am very grateful for the assistance. Thank you for making and sharing this video! :)

[@thelemonones_band]

you have saved my life, thankyou

[@uniquelyleira]

Sir, I couldn't thank you enough... This is very helpful.

[@amleininger]

Thank you very much for your video. I thought you gave just the right amount of information. And the Irish accent gave it a really enjoyable. touch. Thank you for being straight to the point, and knowledgeable in the excel and statistics field.

[@EugeneOLoughlin]

Hi Arizona,
First - many thanks for checking out my video, I hope you found it useful.
The Mean Deviation is not a commonly used statistic (at least I don't teach it in class). However, it is easy to do in Excel - use the AVEDEV function (Foumulas -> More Functions -> Statistical). All you need to do is select the data range and Excel will calculate the Mean Dev for your.
Try it out with these data: 92, 97, 95, 90, 98. the Mean Dev should work out as 6.
Hope this helps,
Dr E.

[@elseschaap5496]

Great video, so simple and well explained, thank you so much!

[@lisaroth4621]

thank you so much for your clear, easy to understand explanation and demonstration!

[@Ptarmigan2]

Thanks much. Quite helpful, just when I needed it.

[@Limeom]

Thank you so much that Dr. You explained perfectly. And I see that you answer your subscribers. perfect!

[@gracebagas7894]

Thank you very much sir been watching plenty of videos but only yours that i was able to understand fast.

[@reaceoneil5699]

How did you do?

[@Champmeister91]

Love the accent! Had to watch it twice because I literally just listened to you talking haha

[@julinricketts1669]

Thank you for sharing your knowledge. I am much clearer with mean

[@AkampumuzaObed]

Wow, the sound is great, voice superb and content is straight to the point

[@simonbee5959]

This video was a great help, thanks very much!

[@danielbright2916]

Thank you so much for uploading this. Instead of me taking about 5mins, it takes me a matter of seconds.

[@kerrilynjackson7318]

This was incredibly helpful! Thank you :)

[@ceslou]

This is really good. It explains a lot better.

[@ntombikayisemahaye6837]

Thank you. This is what I have been looking for.

[@matildebarrote8843]

Just what i was looking for!
thank you so much!

[@undercover004]

Very informative & nicely explained. Kept it short and precise at the same time.
Keep the good work up Doc E.

[@naomijones8796]

This was extremely helpful thank you . It was easily set out and easy to understand. Great accent to listen to as well!

[@punkkimiko]

Ty you're such a lifesaver. Your accent is cool btw!

[@ResRevolution]

Thank you so much. This was so incredibly helpful.

[@tandy174]

This was so helpful and easy to follow. Thankyou so much :D

[@piffanyortega]

thank you thank you thank you!! my assignment is due today... in one hour (procrastination at its finest) & I was able to complete it easily thanks to you!!!!!!!

[@reaceoneil5699]

Hi, how did you do?

[@22987369]

This man is a legend

[@willarnesen8415]

Thank you very much! Great teaching and presentation style :)

[@pesalepita6927]

Excellent lesson and made easy to understand.

[@dr.priyankaborhade6195]

Tooooo good Sir, thnk you so much. I feel... you should be my coach at some point of my time.

[@sarahkate4841]

Bless you. Thanks for making this so easy.

[@debbiedower6564]

This video was very helpful!! Thank you!

[@jbj03097]

This video presentation on the computation of mean and sd using excel is so clear and easy to understand. Thanks Prof Eugene💖

[@EugeneOLoughlin]

Glad it was helpful!

[@SageAwakens]

You explained it perfectly, how i wish you were my lecturer...

[@Kitana68]

Thanks for the best quick tip!

[@Chiodi4real]

Thanks for your great help Professor, I appreciate it.

[@atopchyan]

Thank you very much. It was really helpful for me!!!

[@missbabybrii]

Thank you, this was very helpful! :)

[@TrivikramBhat-xc2dx]

thanks a lot sir, this was very helpful. helped me calculate sd of 904 variables with ease on excel sheet.

[@iluvemehhh]

That was so helpful thank you for clear explanation!

[@deshn21]

Great video! Thanks a lot!!

[@TheMilkymango]

Thank you so very much for sharing this. I've been trying to work on the spss software and got a little confused. Your tutorial is so simple to understand. Graciasssssssssssssssss.. ^___^

[@robertarnott3103]

Superb, so simple to follow, thank you !!

[@rhyssavage1103]

thanks for this as it was a lot easier

[@KhalidMahida]

Thanks for the video , very simple explanation.

[@juliehenderson1705]

Thank you, thank you - finally I understand standard deviation....t test next.....

[@amyloder8828]

Great video thanks! You just saved me a trip to a lab with SPSS.

[@FieldGamers]

Thank You. This helped me ALOT

[@Tranay90]

You sir are awesome!!! Thank you so much this video helped me out a lot.

[@mary700070]

Thanx a lot! I'm complete stupido in excel but you saved me!!

[@BejaeIngate]

This was really helpful thanks!! Your accent is wonderful too just saying : )

[@UnderstandingChildren]

Just so clear sir !!

[@rahman1314]

This so well explained!

[@ahmedessam5424]

Thank you very much for this excellent tutorial

[@pratikshathapa924]

It was very helpful, thank you so much :)

[@LexiLynn80]

Great video! Thank you so much!

[@anandavandijk6531]

Thank you so much, way better than my own teacher!

[@np814]

THANK YOU! SAVED ME TIME :)

[@jasonwright235]

Excellent presentation. I have learnt alot.

[@annageber4954]

Thank you for explanations.

[@michaeldelterzo4687]

Great help! Thanks!

[@ILDANACHDEDALUS]

Thank you very much, very useful

[@DrScully25]

Such A Gentleman

[@Alex19a83ndra]

Sir, thank you! this is a great tutorial.

[@Hammeroftheirish]

Thank you much, saving my ass out here in California.

[@khobaoren8412]

oh my god..you have really helped me..u are awesome!

[@georgesamaniego6176]

Good work! Thank you very much!

[@alliegirmus2684]

thank you so much this was so helpful!

[@fazalnm48]

Thank you sir .....its nice explanation about the subject

[@khyamangos9585]

This helps a lot. Thanks