Locked lesson.

## About this lesson

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

## Exercise files

Download this lesson’s related exercise files.

Basic Statistics - Begin.xlsx27.2 KB Basic Statistics - Complete.xlsx

27.5 KB

## Quick reference

### Basic Statistics

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

#### 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. |

### Hints & tips

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

Login to downloadLesson notes are only available for subscribers.