🔹 Excel Statistical & Math Formulas for Beginners (With Easy Examples)

Excel can do more than sums — it’s great for statistics and math analysis too! These formulas help you analyze data, find trends, and calculate key numbers quickly.

45. RANK – Find a Number’s Rank

Shows a number’s position in a list (highest to lowest).
Formula: =RANK(A1, A1:A10)
👉 Example: If A1 = 95 in a list of scores, RANK tells you it’s 1st, 2nd, etc.

46. MEDIAN – Find the Middle Value

Returns the value in the middle of a range.
Formula: =MEDIAN(A1:A10)
👉 Example: For scores 70, 80, 90 → MEDIAN = 80

47. MODE – Find the Most Frequent Value

Shows the number that appears most often.
Formula: =MODE(A1:A10)
👉 Example: In 5, 5, 7, 8 → MODE = 5

48. STDEV – Calculate Standard Deviation

Measures how spread out numbers are.
Formula: =STDEV(A1:A10)
👉 Example: Higher STDEV → more variation in your data.

49. VAR – Calculate Variance

Shows how much values vary from the average.
Formula: =VAR(A1:A10)
👉 Example: Used with STDEV for deeper statistical analysis.

50. SUBTOTAL – Calculate on Filtered Data

Performs calculations (SUM, AVERAGE, etc.) only on visible rows after filtering.
Formula: =SUBTOTAL(9, A1:A10)
👉 Example: 9 = SUM, 1 = AVERAGE. Perfect for filtered lists.

💡 Quick Tip:

• Use RANK, MEDIAN, and MODE to quickly understand trends.
• Use SUBTOTAL when working with filtered tables — it ignores hidden rows!

stay tuned to ITinsite.in — your trusted source to get more excel formula’s in easy way