## About this lesson

Learn basic statistical functions including COUNT, COUNTA, AVERAGE, MAX, MIN, MEDIAN and MODE.

## Lesson versions

Multiple versions of this lesson are available, choose the appropriate version for you:

2013, **2016**.

## Exercise files

Download the ‘before’ and ‘after’ Excel workbooks from the video tutorial and try the lesson yourself.

Basic Statistics.xlsx15.8 KB Basic Statistics - Completed.xlsx

15.7 KB

## Quick reference

### Topic

Basic statistical functions including COUNT, COUNTA, AVERAGE, MAX, MIN, MEDIAN and MODE.

### When to use

Determining basic statistics about the values that are in a range of data.

### Instructions

#### Sample data

- Create a new worksheet

#### COUNT vs COUNTA

=COUNT(A1:A10) |
Counts all numerical entries from A1 through A10. (Ignores text). |

=COUNTA(A1:A10) |
Counts all entries (including text) from A1 through A10. |

#### HIGH vs LOW values

=MAX(A1:A10) |
Returns the highest value in the provided range. |

=MIN(A1:A10) |
Returns the lowest value in the provided range. |

#### AVERAGES

=AVERAGE(A1:A10) |
Returns the mathematical average (mean) for the provided range. |

=MEDIAN(A1:A10) |
Returns the value of the number in the middle of your sorted data (or the value halfway between the two middle values if an even number of values is provided). |

=MODE(A1:A10) |
Returns the most frequently occurring value in your data set, or #N/A if no value occurs more frequently than any other. |

*Note: In addition to the ones covered here, there are many other statistical functions available in Excel.*

Lesson notes are only available for subscribers.