Standard Deviation in Excel (NEW VERSION IN DESCRIPTION)

Published 2020-03-10
NEW VERSION - Standard Deviation of a Data Set in Excel
   • Standard Deviation of a Data Set in E...  


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
   • Standard Error of the Mean in Excel  

Link to video of how to calculate an average in Excel.
   • Calculating Averages in Excel (UPDATE...  


Excel Skills Playlist
   • Excel Microsoft Office  


-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.
sites.google.com/site/evanmatthewseportfolio/home

All Comments (21)
  • @rigodiego2753
    Learned more in under 5 mins than in a 2 hour lecture
  • 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.
  • @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.
  • @bianca3201
    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.
  • Very helpful for my M.Sc assignment. Gotta finish it In 4 days so this is terrific
  • @Marta-to1mf
    Im taking statistics lass and I wanted to thank yiu very much. Your video is a life saver !
  • @CMeds
    THANK YOU SO MUCH, SIR! YOU MADE IT EASIER FOR EVERYONE TO SOLVE THIS!
  • @hannahs4766
    This was an excellent demonstration thank you so much
  • @penguinminari3309
    thank you so much, you've save us so much time for our school project
  • 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.
  • @aronkay5274
    Great Video Vivo Phys!! Keep up the great work!