The STEYX function returns the standard error of the predicted y-value for each x in the regression. The standard error …
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.S function calculates the standard deviation for a sample set of data. STDEV.S replaces the older STDEV function, with the …
Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution …
Returns the skewness of a distribution. Skewness characterizes the degree of asymmetry of a distribution around its mean. Positive skewness …
The RSQ function returns the square of the Pearson product moment correlation coefficient through data points in known_y’s and known_x’s. …
The Excel RANK.EQ function returns the rank of a number against a list of other other numeric values. When values contain …
The Excel STDEVA function calculates standard deviation for a sample of data. Unlike the STDEV function, STDEVA will evaluate text and …
The Excel RANK.AVG function returns the rank of a number against a list of other other numeric values. When values contain …
The Excel QUARTILE.INC function returns the quartile (each of four equal groups) for a given set of data. QUARTILE.INC can …
The Excel QUARTILE.EXC function returns the quartile for a given set of data. QUARTILE.EXC can return, first quartile, second quartile, and …