Care when using Statistical Functions in Excel (Part 1)

Excel is a powerful tool for analysing data, and as part of that has a wide range of statistical functions.

However these must be used with care: the fact that Excel allows you to do something doesn’t mean it is statistically valid (which may appear to make sense). It may even be obvious nonsense.

For example if you’ve entered telephone numbers as numbers (not a good idea anyway, because you’ll lose the leading zero, making the number even more difficult to read) Excel can calculate the average number you’ve called to 4 decimal places!

Note that AVERAGE in Excel is the mean. Of the other two kinds of arithmetic average, MODE and MEDIAN, MODE could produce a valid result because it would show which numbers you have called most. While MEDIAN would merely return the middle value.

About spreadsheetexpertblog

Working as a computer professional since 1983, on projects varying in size from one person to multi-million pounds. Working on Excel projects since the mid 1990s.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s