The TRIMMEAN function returns the mean of the interior of a data set. TRIMMEAN calculates the mean taken by excluding …

# 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 Excel STDEV.P function calculates the standard deviation for a sample set of data. STDEV.P calculates standard deviation using the …

TREND function is a built-in function in excel which comes under the category of Statistical function to calculate the linear …

T Test function in excel is used for calculating the probability of significant difference between two data sets whether any …

The T.INV.2T function returns the two-tailed inverse of the Student’s t-distribution Syntax:= T.INV.2T(probability,deg_freedom) The T.INV.2T function syntax has the following …

The Excel STANDARDIZE function returns a normalized value (z-score) based on the mean and standard deviation. Syntax:= STANDARDIZE (x, mean, …

The Excel T.INV function calculates the left-tailed inverse of the Student’s T Distribution, which is a continuous probability distribution that …

The T.DIST.RT function returns the right-tailed Student’s t-distribution. The t-distribution is used in the hypothesis testing of small sample data …

Returns the two-tailed Student’s t-distribution. The Student’s t-distribution is used in the hypothesis testing of small sample data sets. Use …

SLOPE Function is a statistical function in excel. SLOPE Function calculates the slope of a line generated by linear regression. In …