RANK.AVG Function in Excel: Rank That Shares Ties Fairly
RANK.AVG works like RANK.EQ, but tied values get the average rank (2.5 and 2.5 instead of 2 and 2). Useful for statistics; confusing on…
Read article →Statistical
Excel Statistical functions explained with syntax, examples and common mistakes.
COUNTIFS Function in Excel: Count With Multiple Conditions
COUNTIFS Function in Excel: Count With Multiple Conditions
StatisticalLevel: IntermediateAvailable in: Excel 2007+COUNTIFS counts rows where every condition is true.Syntax=COUNTIFS(criteria_range1, criteria1.
Read article →SMALL Function in Excel: The k-th Smallest Value
SMALL Function in Excel: The k-th Smallest Value
StatisticalLevel: IntermediateAvailable in: Excel 2007+SMALL returns the k-th smallest number — bottom-N lists and the earliest dates.Syntax=SMALL(array.
Read article →COUNTIF Function in Excel: Count Cells That Meet a Condition
COUNTIF Function in Excel: Count Cells That Meet a Condition
COUNTIF counts cells that meet one condition. It is also the simplest duplicate checker.
Read article →LARGE Function in Excel: The k-th Largest Value (Top 3, Top 10)
LARGE Function in Excel: The k-th Largest Value (Top 3, Top 10)
LARGE returns the k-th largest value; SMALL returns the k-th smallest. Together they build top-N lists in any version.
Read article →PERCENTRANK Function in Excel: Percentile Rank (Older Name)
PERCENTRANK Function in Excel: Percentile Rank (Older Name)
PERCENTRANK returns the rank of a value as a percentage of the data. It is a compatibility function: Excel keeps it so workbooks from…
Read article →FORECAST Function in Excel: Straight-Line Forecast (Older Name)
FORECAST Function in Excel: Straight-Line Forecast (Older Name)
FORECAST predicts a value on a straight-line trend. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →NEGBINOM.DIST Function in Excel: Failures Before the k-th Success
NEGBINOM.DIST Function in Excel: Failures Before the k-th Success
NEGBINOM.DIST gives the chance of a number of failures before reaching a set number of successes, e.g. calls before the 3rd sale.
Read article →NORMDIST Function in Excel: Normal Distribution (Older Name)
NORMDIST Function in Excel: Normal Distribution (Older Name)
NORMDIST gives the normal distribution for a mean and SD. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and…
Read article →EXPONDIST Function in Excel: Exponential Distribution (Older Name)
EXPONDIST Function in Excel: Exponential Distribution (Older Name)
EXPONDIST returns the exponential probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft…
Read article →GAMMAINV Function in Excel: Inverse Gamma (Older Name)
GAMMAINV Function in Excel: Inverse Gamma (Older Name)
GAMMAINV returns the value at a gamma probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →BINOMDIST Function in Excel: Binomial Probability (Older Name)
BINOMDIST Function in Excel: Binomial Probability (Older Name)
BINOMDIST returns the binomial probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft…
Read article →