Subscriber only lesson.

Sign up to the Microsoft Excel for Mac - Basic course to view this 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.xlsx15.5 KB Basic Statistics - Completed.xlsx

15.9 KB

## Quick reference

### Topic

Basic statistics.

### Description

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

### Where/when to use the technique

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

Lesson notes are only available for subscribers.