Manuals/calci/TTESTPAIRED

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

• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ar1 } and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ar2 } are set of values.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle md } is the Hypothesized Mean Difference.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle alpha } is the significance level.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle TTESTPAIRED(ar1,ar2,md,alpha,lv)} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ar1 } and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ar2 } are two arrays of sample values.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle md } is the Hypothesized Mean Difference .In this function md=0.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle alpha } is the significance level which ranges from 0 to 1.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle lv } is the logical value like TRUE or FALSE.TRUE is indicating the result will display in new worksheet.Suppose we are omitted the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle lv } value it will consider the value as FALSE.
• The t statistic of this function calculated by:

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle t = \frac{\bar{x}-\mu_ 0}{s.d/\sqrt{n}}} where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \bar{x}} is the average value, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle s.d } is the standard deviation and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \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

	Variable 1	Variable 2
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

See Also

• TTEST
• TDIST
• TINV
• TTESTEQUALVARIANCES
• TTESTUNEQUALVARIANCES