TTESTPAIRED

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

• $ar1$ and $ar2$ are set of values.
• $md$ is the Hypothesized Mean Difference.
• $alpha$ is the significance level.
• $lv$ 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 $TTESTPAIRED(ar1,ar2,md,alpha,lv)$, $ar1$ and $ar2$ are two arrays of sample values.
• $md$ is the Hypothesized Mean Difference .In this function md=0.
• $alpha$ is the significance level which ranges from 0 to 1.
• $lv$ is the logical value like TRUE or FALSE.TRUE is indicating the result will display in new worksheet.Suppose we are omitted the $lv$ 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

Excel Results

Related Videos

TTESTPAIRED

See Also

• TTEST
• TDIST
• TINV
• TTESTEQUALVARIANCES
• TTESTUNEQUALVARIANCES