Monday, August 13, 2012

How To... Calculate Data Mean, Median, and Mode in Excel 2010

It's been a while since I created a new video for YouTube, and this new Statistics using Excel video is the first of what I hope are several videos on this subject that I am teaching for the first time in the upcoming semester. The videos will be primarily for my own students in a Business Data Analysis module for a class of 4th year students - but of course I hope that the videos will also be usefull to others as well.

The subject of this video is how to calculate the mean, median, and mode of a set of data using Excel Functions. They are relatively easy to calculate manually, but Excel makes the job even easier.


In making this video I am using my new work laptop for the first time to do so, and I have also switched from Camstudio to Snagit as a screen capturing tool. Both are easy to use, but there are problems with installing Camstudio that I do not wish to try on my new laptop. For the moment I am using the trial version of Snagit.

No comments:

Post a comment