Manuals/calci/TTESTPAIRED

TTESTPAIRED(ar1,ar2,md,alpha,lv)


  • and are set of values.
  • is the Hypothesized Mean Difference.
  • is the significance level.
  • is the logical value.

Description

  • This function gives a value of paired t -test.
  • A paired t-test looks at the difference between paired values in two samples.
  • Paired samples also called matched samples or repeated measures.
  • This test is used when the samples are dependent. i.e.,only one sample which is tested twice or the two samples that have been paired.
  • In  ,   and   are two arrays of sample values.
  •   is the Hypothesized Mean Difference .In this function md=0.
  •   is the significance level which ranges from 0 to 1.
  •   is the logical value like TRUE or FALSE.TRUE is indicating the result will display in new worksheet.Suppose we are omitted the   value it will consider the value as FALSE.
  • The t statistic of this function calculated by:

  where   is the average value,   is the standard deviation and   is the constant.

  • This function will give the result as error when
      1. any one of the argument is non_numeric.
      2. alpha>1.

Examples

Spreadsheet
A B C D E F
1 21 24 29 11 19 8
2 17 10 32 7 15 22
  1. =TTESTPAIRED(A1:F1,A2:F2,5,0.25)
Result
Variable 1 Variable 2
Mean 18.666666666666668 17.166666666666668
Variance 62.66666666666667 80.56666666666666
Observations 6 6
Pearson Correlation 0.39499794997886284
Hypothesized Mean Difference 5
Degree Of Freedom 5
T-Statistics -0.9186172406951716
P(T<=t) One-tail 0.20022020093421516
T Critical One-Tail 0.7266868353364707
P(T<=t) Two-tail 0.40044040186843033
T Critical Two-Tail 1.300949035127116

See Also

References