CORREL, COVARIANCE and STANDARDIZE z-Scores
This lesson is part of the course
In this lesson
You measure how strongly deals and revenue move together, turn every revenue into a z-score and draw a scatter chart with a trendline.
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
- AVERAGE vs MEDIAN vs MODE.SNGL and a Trimmed Mean Locked
- Conditional Statistics: AVERAGEIFS, MAXIFS, MINIFS and COUNTIFS Locked
- Spread: Range, STDEV.S vs STDEV.P, VAR and the IQR Locked
- PERCENTILE, PERCENTRANK and Quartile Bands Locked
- RANK.EQ vs RANK.AVG and Top-N with LARGE and SMALL Locked
- Frequency Tables and Histograms with COUNTIFS Locked
- CORREL, COVARIANCE and STANDARDIZE z-Scores Locked
- Capstone: Outlier Flags and a Summary Statistics Table Locked