Microsoft Office Tutorials and References
In Depth Information
Table 1-1. Improved Statistical Functions
Determines the probability that a set number of true/false trials,
where each trial has a consistent chance of generating a true or false
result, will result in exactly a specified number of successes (for
example, exactly five out of ten coin flips will end up heads).
Finds a value that best fits a result in a chi -squared distribution.
Returns a value you can use to construct a confidence interval for a
Determines when the number of failures in a series of true/false trials
exceeds a criterion (for example, more than 5 percent of light bulbs in
a production run fail to light).
Estimates the standard deviation of values in a column by considering
only those values that meet a criterion.
Calculates the standard deviation of values in a column based on
every value in the column.
Estimates the variance of values in a column or list by considering only
those values that meet a criterion.
Calculates the variance of values in a column or list based on every
value in the column.
Returns the value that would generate a target result from an
F-test (a test of variability between two data sets).
Calculates future values based on an existing time series of values.
Returns the value that would generate a given result from a
gammadistributed (that is, skewed) data set.
Predicts the exponential growth of a data series.
Returns the probability of selecting an exact number of a single type of
item from a mixed set of objects. For example, a jar holds 20 marbles,
6 of which are red. If you choose three marbles, what is the probability
you will pick exactly one red marble?
Calculates the point at which a line will intersect the y-axis.
Generates a line that best fits a data set by generating a
twodimensional array of values to describe the line.
Generates a curve that best fits a data set by generating a
twodimensional array of values to describe the curve.
Returns the inverse logarithm of a value in a distribution.
Returns the number of standard deviations a value is away from the
mean in a lognormal distribution.
Returns the probability that there will be a given number of failures
before a given number of successes in a binomial distribution.