Function: PROB

Function: PROB

The PROB function is a statistical function that can calculate the probability associated with a given range. The function is useful for calculating the probability for the occurrences having discrete probabilities of an event. In this guide, we’re going to show you...
Function: VARPA

Function: VARPA

The VARPA function is a statistical function that can calculate and return the variance of a population by evaluating text and logical values. Variance provides a general idea of how much data points are spread in a data set, and can be used to calculate the standard...
Function: VARP

Function: VARP

The VARP function is a statistical function calculates and returns the variance of a population. Variance provides a general idea of how much data points are spread in a data set, and can be used to calculate the standard deviation or determine the risk of an...
Function: VAR.P

Function: VAR.P

The VAR.P function is a statistical function that can calculate and return the variance of a population. This formula was essentially introduced as a replacement for the outdated VARP function. Variance provides a general idea of how much data points are spread in a...
Function: VAR

Function: VAR

The VAR function is a statistical function calculates and returns the variance of a sample. The variance provides a general idea of the spread of data, and can be used to calculate the standard deviation or determining risk of an investment. In this guide, we’re going...
Function: CHISQ.TEST

Function: CHISQ.TEST

The CHISQ.TEST is a Statistical function that calculates the chi squared (χ2) distribution and returns the probability of a value chi-squared (χ2) between observed and expected data. The chi squared (χ2) test can be used to assess the relationship between two data...
How to slugify a string with Excel

How to slugify a string with Excel

“Slugify” is a term for converting strings into URL slug format. A URL slug, or just slug in this article’s context, is the part of the URL that comes after the domain extension. In this guide, we’re going to show you how to slugify a string with Excel. Download...
How to calculate median by criteria in Excel

How to calculate median by criteria in Excel

In this guide, we’re going to show you how to run calculate median by criteria in Excel. Download Workbook To calculate median based on a criteria, you need to supply a range of values to be compared against the specific criteria defined in the MEDIAN function....
Function: NORMSINV

Function: NORMSINV

NORMSINV Excel formula is a Statistical function that calculates the inverse of the standard normal cumulative distribution of a specific probability. The standard normal distribution is a type of normal distribution with a mean of zero (0) and a standard deviation of...