Manuals/calci/TTESTPAIRED

From ZCubes Wiki
Jump to navigation Jump to search
TTESTPAIRED(Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)


  • and are set of values.
  • is the Hypothesized Mean Difference.
  • is the significance level.
  • is the logical value.
    • TTESTPAIRED() determines whether a samples means are distinct.

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 value of the Hypothesized Mean Difference .In this function HypothesizedMeanDifference=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 t-TEST: PAIRED TWO SAMPLE FOR MEANS
VARIABLE1 VARIABLE2
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

Related Videos

TTESTPAIRED

See Also

References