Calc Guide

Syntax Description
SP)
the value returned for unsuccessful tests. R is
the value returned for successful tests. SP is
the probability of the success of an attempt.
NORMDIST(number;
mean; STDEV; C)
Returns the normal distribution for the given
Number in the distribution. Mean is the mean
value of the distribution. STDEV is the
standard deviation of the distribution. C = 0
calculates the density function, and C = 1
calculates the distribution.
NORMINV(number;
mean; STDEV)
Returns the inverse of the normal distribution
for the given Number in the distribution.
Mean is the mean value in the normal
distribution. STDEV is the standard deviation
of the normal distribution.
NORMSDIST(number) Returns the standard normal cumulative
distribution for the given Number.
NORMSINV(number) Returns the inverse of the standard normal
distribution for the given Number, a
probability value.
PEARSON(data_1; data_2) Returns the Pearson product moment
correlation coefficient r. Data_1 is the array of
the first data set. Data_2 is the array of the
second data set.
PERCENTILE(data; alpha) Returns the alpha-percentile of data values in
an array. Data is the array of data. Alpha is
the percentage of the scale between 0 and 1.
PERCENTRANK(data;
value)
Returns the percentage rank (percentile) of the
given value in a sample. Data is the array of
data in the sample.
PERMUT(count_1;
count_2)
Returns the number of permutations for a
given number of objects. Count_1 is the total
number of objects. Count_2 is the number of
objects in each permutation.
PERMUTATIONA(count_1;
count_2)
Returns the number of permutations for a
given number of objects (repetition allowed).
Count_1 is the total number of objects.
Count_2 is the number of objects in each
permutation.
PHI(number) Returns the values of the distribution function
for a standard normal distribution for the given
Number.
Appendix B Description of Functions 455