Statistical Functions
The logic of likelihood. Master the 25 essential tools for probability distributions, competitive ranking, and advanced data mining.
Live Score Feedback
Active Logic Validation
Industry Datasets
Statistical Functions Foundations
Learn how Excel statistical functions summarize data, compare spread, and help you understand typical results.
Average Function
Calculate the arithmetic mean of numbers in Excel. A simple way to see the typical value in a list.
Averageif Function
Calculate the average of values that match one condition. Useful when you want the mean for one category, threshold, or label.
Averageifs Function
Calculate the average of values that meet more than one condition. Useful when one filter is not enough.
Binom.dist Function
Find the probability of a certain number of successes in a fixed number of yes-or-no trials.
Correl Function
Measure how strongly two sets of numbers move together.
Count Function
Count how many cells contain numbers. Useful when you only want a tally of numeric entries.
Counta Function
Count how many cells are not empty. Useful when you want to know how many entries exist, no matter what type of data they contain.
Countblank Function
Count how many cells are blank. Useful when you want to measure missing data or incomplete entries.
Countif Function
Count how many cells match one condition. Useful for quick filtered counts like Yes/No, scores above a target, or text matches.
Countifs Function
Count how many rows meet multiple conditions. Useful when one filter is not enough.
Large Function
Return the k-th largest value in a dataset. Useful when you want a ranked high value instead of just the maximum.
Max Function
Find the largest number in a list. Useful for spotting the highest sale, top score, or latest date.
Maxa Function
Find the largest value while including logical values such as TRUE and FALSE. MAXA is useful when a range mixes numbers with logical test results.
Maxifs Function
Find the highest value that matches one or more conditions. Useful when you need the top result from a filtered group.
Median Function
Find the middle value in a set of numbers. A good choice when very high or very low values would distort the average.
Min Function
Find the smallest number in a list. Useful for spotting the lowest price, smallest score, or earliest value in a set.
Mina Function
Find the smallest value while including logical values such as TRUE and FALSE. MINA is useful when a range mixes numbers with logical test results.
Minifs Function
Find the lowest value that matches one or more conditions. Useful when you need the minimum from a filtered group.
Mode Function
Find the most frequently occurring number in a list. MODE is useful for repeated numeric categories such as scores, ratings, or hourly activity blocks.
Mode.mult Function
Return all most frequently occurring numbers from a dataset. MODE.MULT is useful when more than one value ties for the highest frequency.
Mode.sngl Function
Find the number that appears most often in a list. Useful when you want the most common score, rating, or ID.
Norm.dist Function
Return the normal distribution for a value when you know the mean and standard deviation. Useful for bell-curve probability work.
Percentile.exc Function
Find a percentile while excluding the two outer edges of the distribution.
Percentile.inc Function
Find a percentile while including the full range from minimum to maximum.
Quartile.exc Function
Return quartile cutoffs with the exclusive method.
Quartile.inc Function
Return quartile cutoffs from the full range, including minimum and maximum.
Rank.avg Function
Return the rank of a value while averaging tied positions.
Rank.eq Function
Return the rank of a number in a list. Useful for leaderboards, score positions, and classic tie handling.
Slope Function
Find the rate of change in a linear relationship between two numeric lists.
Small Function
Return the k-th smallest value in a dataset. Useful when you want a ranked low value instead of just the minimum.
Stdev.p Function
Measure standard deviation for a full population. Use it when your dataset already includes every value you want to analyze.
Stdev.s Function
Measure standard deviation for a sample. Use it when your data is only part of a larger group.
Sumproduct Function
Multiply corresponding values and sum the results in one formula. SUMPRODUCT is useful for weighted totals, inventory value, and conditional calculations.
Var.p Function
Measure variance for a full population. Use it when your dataset already includes every value you want to analyze.
Var.s Function
Measure variance for a sample. Use it when your data is only part of a larger population.
"This expertise path is engineered for maximum logic retention. We use interactive simulations to ensure every advanced function is immediately applied to real-world datasets."