Excel in Percentile & STDEV & Variance & Large SMALL & RANK Video 15

PERCENTILE returns the value at a specified percentage of a dataset. Data: 10, 20, 30, 40, 50 Excel 1 =PERCENTILE.INC(A1:A5,0.5) Show more lines Result: 30 (50th percentile or median) ✅ STDEV (Standard Deviation) Measures how much values vary from the average. Data: 10, 12, 11, 13, 14 Excel 1 =STDEV.S(A1:A5) Show more lines Result: Low value = data is consistent ✅ VARIANCE Measures the spread of data. It is the square of Standard Deviation. Data: 10, 12, 11, 13, 14 Excel 1 =VAR.S(A1:A5) Show more lines Result: Shows how dispersed the values are. ✅ LARGE Returns the nth largest value. Data: 10, 50, 30, 80, 20 Excel 1 =LARGE(A1:A5,1) Show more lines Result: 80 (largest value) Excel 1 =LARGE(A1:A5,2) Show more lines Result: 50 (2nd largest value) ✅ SMALL Returns the nth smallest value. Data: 10, 50, 30, 80, 20 Excel 1 =SMALL(A1:A5,1) Show more lines Result: 10 (smallest value) Excel 1 =SMALL(A1:A5,2) Show more lines Result: 20 (2nd smallest value) ✅ RANK Returns the rank of a number in a list. Data: 90, 80, 70, 60 Excel 1 =RANK(90,A1:A4,0) Show more lines Result: 1 (Highest value gets Rank 1) Excel 1 =RANK(60,A1:A4,1) Show more lines Result: 1 (Lowest value gets Rank 1)