Tutorvo

Capstone: Outlier Flags and a Summary Statistics Table

Lesson 8 of 825 minLab

This lesson is part of the course

In this lesson

You flag outliers in Orchard Row's revenue with the 1.5 × IQR rule and complete a summary table that compares all reps with the team without outliers.

Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.

Lessons in this course

  1. AVERAGE vs MEDIAN vs MODE.SNGL and a Trimmed MeanLab15 min Locked
  2. Conditional Statistics: AVERAGEIFS, MAXIFS, MINIFS and COUNTIFSLab15 min Locked
  3. Spread: Range, STDEV.S vs STDEV.P, VAR and the IQRLab15 min Locked
  4. PERCENTILE, PERCENTRANK and Quartile BandsLab20 min Locked
  5. RANK.EQ vs RANK.AVG and Top-N with LARGE and SMALLLab15 min Locked
  6. Frequency Tables and Histograms with COUNTIFSLab20 min Locked
  7. CORREL, COVARIANCE and STANDARDIZE z-ScoresLab20 min Locked
  8. Capstone: Outlier Flags and a Summary Statistics TableLab25 min Locked