Manuals/calci/TTESTPAIRED

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

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

TTESTPAIRED