Excel Statistical Functions: AVERAGEIFS, MEDIAN, PERCENTILE, RANK & FREQUENCY
Mean, median and mode, AVERAGEIFS/MAXIFS/MINIFS, STDEV and IQR, percentiles and quartile bands, RANK and top-N, frequency histograms, correlation and z-scores, outlier flags: 8 hands-on labs on one sales team, every cell checked instantly.
The first lesson is free — no account needed.
About this course
An Excel statistical functions course that describes one fictional sales team's numbers with the functions analysts use every day, for office staff, analysts, students and anyone who reports averages. You compare AVERAGE, MEDIAN, MODE.SNGL and a trimmed mean and see how one star rep pulls the mean, build a region summary with AVERAGEIFS, MAXIFS, MINIFS and COUNTIFS, measure spread with the range, STDEV.S versus STDEV.P, VAR and the interquartile range, set a bonus threshold with PERCENTILE.INC and sort reps into quartile bands, rank them with RANK.EQ and RANK.AVG and list the top three with LARGE and SMALL, group 40 orders into a frequency table and histogram, measure correlation and covariance and turn revenue into z-scores, and flag outliers with the 1.5 × IQR rule in a summary statistics table. The first lab is free.
Lessons
- AVERAGE vs MEDIAN vs MODE.SNGL and a Trimmed MeanFree
- Conditional Statistics: AVERAGEIFS, MAXIFS, MINIFS and COUNTIFS Pro
- Spread: Range, STDEV.S vs STDEV.P, VAR and the IQR Pro
- PERCENTILE, PERCENTRANK and Quartile Bands Pro
- RANK.EQ vs RANK.AVG and Top-N with LARGE and SMALL Pro
- Frequency Tables and Histograms with COUNTIFS Pro
- CORREL, COVARIANCE and STANDARDIZE z-Scores Pro
- Capstone: Outlier Flags and a Summary Statistics Table Pro