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.
Search JabSto ::




Custom Search