Manuals/calci/TTESTPAIRED
- 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 value it will consider the value as FALSE.
- The t statistic of this function calculated by:
value it will consider the value as FALSE.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
| 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)
| 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 |