Standard Deviation in Excel (NEW VERSION IN DESCRIPTION)

NEW VERSION - Standard Deviation of a Data Set in Excel

This video shows Dr. Evan Matthews explaining how to calculate a standard deviation in Excel. The sample data in this video represents the 1 repetition maximum (1RM) of the biceps curl for women and men.

Standard Error in Excel

Link to video of how to calculate an average in Excel.

Excel Skills Playlist

--Correction--
The data headers in the excel file state that the units are pounds. They are actually kilograms that were converted from pounds. This is the reason for the decimal values seen in the spreadsheet.

Link to Dr. Evan Matthews website.

[thelmasantos]

Thank you for the very clear demonstration of calculating the standard deviation using Excel May I share this with my students. Your work will be acknowledged.

[rigodiego]

Learned more in under 5 mins than in a 2 hour lecture

[SadlySorrowful]

My statistics professor doesn't explain how to do this and you clearly made it easier for me to know how to find the standard deviation of a sample, thank you.

[dakotaduffina]

I literally tried doing this by hand. No wonder I hate this class. My professor should’ve just taught us this. Thank you.

[bianca]

super clear and easy to understand! thanks wish i would've found you last semester!

[himelu]

Thank you!!! You are an awesome person. My life just got a lot easier.

[Marta-tomf]

Im taking statistics lass and I wanted to thank yiu very much. Your video is a life saver !

[martinsorenson]

Very helpful for my M.Sc assignment. Gotta finish it In 4 days so this is terrific

[BitsAsLiga]

thank you so much, you've save us so much time for our school project

[therankingworld]

SIMPLE AND STRAIGHT TO THE POINT LOVELY TUTORIAL

[blip_bob_bobert]

You are a lifesaver. I tried doing this by hand and constantly kept getting the wrong answer. Thank you.

[bellaendale]

Where were you when I took statistics? Hm hm hm.. I would have enjoyed and loved it so much more. I never realized it was this easy. Many thanks for calmy and clearly explaining this concept.

[CMeds]

THANK YOU SO MUCH, SIR! YOU MADE IT EASIER FOR EVERYONE TO SOLVE THIS!

[aronkay]

Great Video Vivo Phys!! Keep up the great work!

[hannahs]

This was an excellent demonstration thank you so much

[sirbrad]

Thank you so much for the great tutorial! Merci Beaucoup!

[joyceeverpantulia]

Thank you so much! It helps me big time. 😊

[rowenageneralle]

Thank you so much...sir for a clear explaination.

[tp]

Excellent video thanks. How would you calculate std dev excluding zeros?

[jboy]

What if I want STDev for both men & women, and do not want to alter the columns; what does the formula look like?