# Manuals/calci/TTESTPAIRED

Jump to navigation
Jump to search

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

- and are set of values.
- is the Hypothesized Mean Difference.
- is the significance level.
- 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 , and are two arrays of sample values.
- is the value of the Hypothesized Mean Difference .In this function HypothesizedMeanDifference=0.
- is the significance level which ranges from 0 to 1.
- 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:

where is the average value, is the standard deviation and 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)

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

## See Also

## References