Page 31 - Microsoft Office Excel 2003 Programming Inside Out

Part 1: Preliminaries
What’s New in Excel 2003

Table 1-1. Improved Statistical Functions
NORMDIST Returns the number of standard deviations a value is away from the
mean in a normal distribution. Chapter 1
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.

5