Wednesday, January 11, 2012

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

My first YouTube video of 2012 is a simple one - it shows how to calculate a simple mean (average) and standard deviation. These are quite easy to do (if you know how) - so this video shows some basic use of the Excel AVERAGE and STDEV functions. I spotted another video doing the same in Excel 2003 in preparation for a Student's t test, and thought it might make a nice simple video for my channel. I'm not good at statistics, but am considering some basic stats videos for the channel.


9 comments:

  1. Thanks, this helped me alot.

    ReplyDelete
  2. can i calculate the coefficient of a variation with excell
    Ray

    ReplyDelete
    Replies
    1. Hi Ray - I've never tried this, but will check it out some time soon.

      Dr. E.

      Delete
  3. Thanks Eugene, v helpful

    ReplyDelete
  4. Great video Eugene. Thank You.

    ReplyDelete
  5. Great video, thank you

    ReplyDelete
  6. Thank you, Eugene. I liked the simple definitions, which are much easier to understand than those given in my statistics class! Very nice video

    ReplyDelete