PTTEST(R1, R2)

 

Description

This function returns the significance level of the two-sided paired T-test for the paired samples contained in the ranges R1 and R2, respectively.  The return value is the probability of error in rejecting the null hypothesis that the mean of [y-x]=0.  R1 and R2 must have the same dimensions.

 

Parameters

 

R1

A range.

 

R2

A range.

 

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 have different dimensions.