Manuals/calci/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 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

TTESTPAIRED(A1:F1,A2:F2,5,0.25)

See Also

• TTEST
• TDIST
• TINV
• TTESTEQUALVARIANCES
• TTESTUNEQUALVARIANCES