Count above average

Intermediate← PreviousSkip →
Exercise 9 of 12 Premium

How many stores have weekly sales above the average?

Checking your plan…

store-performance.xlsx

ABCDE
1StoreRegionWeekly salesCustomersStaff
2
3
4
5
6
7
8

About statistics in Excel

An average only tells part of the story. Using a table of weekly sales from ten stores, practice finding the median, the top and bottom values, a store's rank, the most common value, percentiles and the standard deviation.

GuideHow to Use COUNTIF in Excel (and COUNTIFS)→

Functions you can use here

  • MEDIAN(number1, [number2], …)
  • LARGE(array, k)
  • RANK.EQ(number, ref, [order])
  • MODE.SNGL(number1, [number2], …)
  • STDEV.S(number1, [number2], …)

More statistics exercises

  1. 1.Median
  2. 2.Range
  3. 3.Second largestPremium
  4. 4.Third smallestPremium
  5. 5.Round a resultPremium
  6. 6.Round upPremium
  7. 7.Most common valuePremium
  8. 8.Rank a valuePremium
  9. 9.Count above averagePremium
  10. 10.Largest in a groupPremium
  11. 11.PercentilesPremium
  12. 12.Standard deviationPremium
See the whole topic →