Why statistical functions summarize data in Excel - Dashboard Impact

Dashboard Mode - Why statistical functions summarize data

Dashboard Goal

Understand how statistical functions like AVERAGE, MEDIAN, and STDEV summarize sales data to give quick insights.

Sample Data

Salesperson	Region	Sales Amount
Alice	East	120
Bob	West	150
Charlie	East	100
Diana	West	130
Eva	East	170
Frank	West	160

Dashboard Components

• KPI Card: Average Sales
  Formula: =AVERAGE(C2:C7)
  Result: 138.33
• KPI Card: Median Sales
  Formula: =MEDIAN(C2:C7)
  Result: 140
• KPI Card: Sales Standard Deviation
  Formula: =STDEV.S(C2:C7)
  Result: 26.46
• Table: Sales by Region
  Formula for East Total: =SUMIF(B2:B7,"East",C2:C7) Result: 390
  Formula for West Total: =SUMIF(B2:B7,"West",C2:C7) Result: 440

Dashboard Layout

+----------------------+----------------------+----------------------+
| Average Sales (138.33)| Median Sales (140)   | Std Dev Sales (26.46) |
+----------------------+----------------------+----------------------+
|                      Sales by Region Table                      |
|  East: 390          West: 440                                |
+----------------------------------------------------------------+

Interactivity

Add a filter for Region (East or West). When you select a region, the KPI cards and Sales by Region table update to show statistics only for that region's sales.

Self Check

If you filter the data to show only the East region, what is the new Average Sales value? (Answer: 130)

Key Result

Dashboard shows how average, median, and standard deviation summarize sales data overall and by region.