Manuals/calci/TTESTPAIRED

TTESTPAIRED(Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)

• $Array1$ and $Array2$ are set of values.
• $HypothesizedMeanDifference$ is the Hypothesized Mean Difference.
• $Alpha$ is the significance level.
• $NewTableFlag$ 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 $TTESTPAIRED(Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)$, $Array1$ and $Array2$ are two arrays of sample values.
• $HypothesizedMeanDifference$ is the value of the Hypothesized Mean Difference .In this function HypothesizedMeanDifference=0.
• $Alpha$ is the significance level which ranges from 0 to 1.
• $NewTableFlag$ is the logical value like TRUE or FALSE.TRUE is indicating the result will display in new worksheet.Suppose we are omitted the $NewTableFlag$ value it will consider the value as FALSE.
• The t statistic of this function calculated by:

$t={\frac {{\bar {x}}-\mu _{0}}{s.d/{\sqrt {n}}}}$ where ${\bar {x}}$ is the average value, $s.d$ is the standard deviation and $\mu _{0}$ 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

• TTEST
• TDIST
• TINV
• TTESTEQUALVARIANCES
• TTESTUNEQUALVARIANCES

References

• Student's t-test

• List of Main Z Functions

• Z3 home