Manuals/calci/TTESTPAIRED

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

• 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 Array1 } 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 Array2 } 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 HypothesizedMeanDifference } 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 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 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(Array1,Array2,HypothesizedMeanDifference,Alpha,NewTableFlag)} , 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 Array1 } 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 Array2 } 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 HypothesizedMeanDifference } is the value of the Hypothesized Mean Difference .In this function HypothesizedMeanDifference=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 NewTableFlag } 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 NewTableFlag } 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

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