582
Descriptive Statistics for Two or
More Variables
Function Name Description
CORRELP CORRELP(range1, range2) returns the p value
for the Pearson coeffi cient of correlation between
range1 and range2. (Note: Range values must be
in two columns.)
MEDIANDIFF MEDIANDIFF (range, range2) calculates the
pairwise median difference between values in
two separate columns.
MWMedian MWMedian(range, range2) calculates the median of
the Walsh averages between two columns of data.
MWMedian2 MWMedian2(range, range2) calculates the
median of the Walsh averages for data values
in one column (range) with category levels in a
second column (range2). There can be only two
levels in the categories column.
PEARSONCHISQ PEARSONCHISQ(range) returns the Pearson
chi-square test statistic for data in range.
PEARSONP PEARSONP(range) returns the p value for the
Pearson chi-square test statistic for data in range.
SPEARMAN SPEARMAN(range) returns the Spearman
nonparametric rank correlation for values in range.
(Note: Range values must be in one column only.)
SPEARMANP SPEARMANP(range) returns the p value for the
Spearman nonparametric rank correlation for
values in range. (Note: Range values must be in
one column only.)
Distributions
Function Name Description
NORMBETW NORMBETW(lower, upper, mean, stdev)
calculates the area under the curve between the
lower and upper limits for a normal distribution
with m 5 mean and s5stdev.
TDF TDF(number, df, cumulative) calculates the
area under the curve to the left of number for
a t distribution with degrees of freedom df, if
cumulative 5 true. If cumulative 5 false, this
function calculates the probability density
function for number.
