The MODE.SNGL function returns the most frequently occurring, or repetitive, value in an array or range of data. Syntax:= MODE.SNGL(number1,,…) …

# Category: Statistical functions

In addition to formulas, another way to conduct mathematical computations in Excel is through functions. Statistical functions apply a mathematical process to a group of cells in a worksheet. For example, the SUM function is used to add the values contained in a range of cells.

The MODE.MULT function returns a vertical array of the most frequently occurring, or repetitive values in an array or range …

Lognormal Distribution function comes under the Statistical functions in the MS Excel, which is one of the most important functions …

Linest function in excel is a statistical function that is used for calculating straight-line statistics and return an array from …

The Excel LOGEST function returns statistical information on the exponential curve of best fit, through a supplied set of x- …

The Microsoft Excel LARGE Function is the function which is responsible for returning the nth largest value from a given …

Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific …

The PHI function returns the value of the density function for a standard normal distribution. Syntax:= PHI(x) The PHI function …

The KURT function returns the kurtosis of a data set. Kurtosis characterizes the relative peakedness or flatness of a distribution …

The PROB function returns the probability that values in a range are between two limits. If upper_limit is not supplied, …