Median

IntermediateSkip →
Exercise 1 of 12MEDIAN

What are the median weekly sales across the ten stores?

Write your formula in the green cell, H2.

Statistics

MedianRangeSecond largestThird smallestRound a resultRound upMost common valueRank a valueCount above averageLargest in a groupPercentilesStandard deviation
store-performance.xlsx
fx
1StoreRegionWeekly salesCustomersStaff
2DowntownNorth$48,200.001,6109Median sales
3RiversideSouth$35,750.001,2406
4HarborEast$52,900.001,78510
5HillcrestWest$29,400.001,0205
6LakesideNorth$41,300.001,3957
7Old TownSouth$38,650.001,3107
8AirportEast$61,200.001,95011
9ParkviewWest$33,100.001,1506
10Market StNorth$44,800.001,5007
11WestgateSouth$27,900.009805
12
13

Click a cell to add it to your formula, drag to select a range, or click a column letter for the whole column.

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.

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 →