Excel Formula Directory
Explore our comprehensive library of spreadsheet formulas with examples, use cases, and our interactive formula generator.
Showing 4 formulas in Statistical
MEDIAN
=MEDIAN(A1:A5)Finding the middle value in a range for central tendency
View formula detailsMODE
=MODE(A1:A5)Finding the most frequent numeric value in a range
View formula detailsSTDEV
=STDEV(A1:A5)Estimating sample standard deviation for statistical analysis
View formula detailsVAR
=VAR(A1:A5)Estimating sample variance for variability analysis
View formula detailsCan't find the formula you need?
Use our AI-powered Formula Generator to create custom formulas for any task. Simply describe what you want to calculate in plain language.
Popular formula requests:
- Calculate the sum of values when multiple conditions are met
- Extract specific text between two characters
- Look up values across multiple sheets with fallback options
- Calculate business days between two dates excluding holidays
Unlock the Full Power of Sheet Alchemy
Get access to all our formula generators, script generators, and conversion tools with a free Sheet Alchemy account.