Microsoft Office Tutorials and References

In Depth Information

Table 1-1.
Improved Statistical Functions

NORMDIST

Returns the number of standard deviations a value is away from the

mean in a normal distribution.

NORMINV

Returns a value that reflects the probability a random value selected

from a distribution will be above it in the distribution.

NORMSDIST

Returns a standard normal distribution, with a mean of 0 and a standard

deviation of 1.

NORMSINV

Returns a value that reflects the probability a random value selected

from the standard normal distribution will be above it in the distribution.

PEARSON

Returns a value that reflects the strength of the linear relationship

between two data sets.

POISSON

Returns the probability of a number of events happening, given the

Poisson distribution of events.

RAND

Generates a random value.

RSQ

Returns the square of the Pearson coefficient of two sets of values.

SLOPE

Returns the slope of a line.

STDEV

Estimates the standard deviation of a numerical data set based on a

sample of the data.

STDEVA

Estimates the standard deviation of a data set (which can include text

and true/false values) based on a sample of the data.

STDEVP

Calculates the standard deviation of a numerical data set.

STDEVPA

Calculates the standard deviation of a data set (which can include text

and true/false values).

STEYX

Returns the predicted standard error for the
y value for each
x value in

a regression.

TINV

Returns a
t value based on a stated probability and degrees of

freedom.

TREND

Returns values along a trend line.

VAR

Estimates the variance of a data sample.

VARA

Estimates the variance of a data set (which can include text and true/

false values) based on a sample of the data.

VARP

Calculates the variance of a data population.

VARPA

Calculates the variance of a data population, which can include text

and true/false values.

ZTEST

Returns the probability that the mean of a data sample would be

greater than the observed mean of data in the set.