next up previous contents index
Next: PV Up: A. Function Reference Previous: PROPER   Contents   Index


PTTEST

Syntax: PTTEST(R1, R2)

R1 = a range
R2 = a range

PTTEST returns the significance level (alpha) of the two-sided paired T-test for the paired samples contained in ranges R1 and R2, respectively. Then alpha is the probability of error in rejecting the null hypothesis that mean [y-x]=0. R1 and R2 must have the same dimension.

Examples:

PTTEST(A1..A4, B1..B4) = 0.64, where A1..A4 = .5, .98, .22, .1, and B1..B4 = .87, .6, .21, .49.

PTTEST(H5..H9, K5..K9) = 0.0008594, where H5..H9 = 14, 35, 37, 0, 33, and K5..K9 = 67, 77, 94, 34, 99.

PTTEST(A1..A30, B1..B50) = Error - ranges must be same dimension

Excel function: N/A


next up previous contents index
Next: PV Up: A. Function Reference Previous: PROPER   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003