Paired t-test

Calculates the paired t-Test of two data samples.

แƒ‘แƒ แƒซแƒแƒœแƒ”แƒ‘แƒแƒ–แƒ” แƒฌแƒ•แƒ“แƒแƒ›แƒ˜แƒกแƒแƒ—แƒ•แƒ˜แƒก...

From the menu bar:

Choose Data - Statistics - Paired t-test

From the tabbed interface:

Choose Data - Statistics - Paired t-test.

On the Data menu of the Data tab, choose Statistics - Paired t-test.


A paired t-test is any statistical hypothesis test that follows a Student's t distribution.

note

For more information on paired t-tests, refer to the corresponding Wikipedia article.


แƒ›แƒแƒœแƒแƒชแƒ”แƒ›แƒ”แƒ‘แƒ˜

Variable 1 range: The reference of the range of the first data series to analyze.

Variable 2 range: The reference of the range of the second data series to analyze.

Results to: The reference of the top left cell of the range where the test will be displayed.

Grouped By

Select whether the input data has columns or rows layout.

Open file with example:

แƒ›แƒแƒ’แƒแƒšแƒ˜แƒ—แƒ˜

The following table has two data sets.

A

B

1

28

19

2

26

13

3

31

12

4

23

5

5

20

34

6

27

31

7

28

31

8

14

12

9

4

24

10

0

23

11

2

19

12

8

10

13

9

33


Results for paired t-test:

The following table shows the paired t-test for the data series above:

paired t-test

alpha

0.05

แƒฐแƒ˜แƒžแƒแƒ—แƒ”แƒขแƒฃแƒ แƒ˜ แƒกแƒแƒจแƒฃแƒแƒšแƒแƒก แƒกแƒฎแƒ•แƒแƒแƒ‘แƒ

0

แƒชแƒ•แƒšแƒแƒ“แƒ˜ 1

แƒชแƒ•แƒšแƒแƒ“แƒ˜ 2

แƒกแƒแƒจแƒฃแƒแƒšแƒ

16.9230769231

20.4615384615

แƒ“แƒ˜แƒกแƒžแƒ”แƒ แƒกแƒ˜แƒ

125.0769230769

94.4358974359

แƒ“แƒแƒ™แƒ•แƒ˜แƒ แƒ•แƒ”แƒ‘แƒ”แƒ‘แƒ˜

13

13

แƒžแƒ˜แƒ แƒกแƒแƒœแƒ˜แƒก แƒ™แƒแƒ แƒ”แƒšแƒแƒชแƒ˜แƒ

-0.0617539772

แƒ’แƒแƒ–แƒแƒ›แƒ˜แƒšแƒ˜ แƒกแƒแƒจแƒฃแƒแƒšแƒแƒก แƒกแƒฎแƒ•แƒแƒแƒ‘แƒ

-3.5384615385

แƒกแƒฎแƒ•แƒแƒแƒ‘แƒ”แƒ‘แƒ˜แƒก แƒ“แƒ˜แƒกแƒžแƒ”แƒ แƒกแƒ˜แƒ

232.9358974359

df

12

t แƒกแƒขแƒแƒขแƒ˜แƒกแƒขแƒ˜แƒ™แƒ

-0.8359262137

P (T<=t) แƒชแƒแƒšแƒ›แƒฎแƒ แƒ˜แƒ•แƒ˜

0.2097651442

แƒ™แƒ แƒ˜แƒขแƒ˜แƒ™แƒฃแƒšแƒ˜ t แƒชแƒแƒšแƒ›แƒฎแƒ แƒ˜แƒ•แƒ˜

1.7822875556

P (T<=t) แƒแƒ แƒ›แƒฎแƒ แƒ˜แƒ•แƒ˜

0.4195302884

แƒ™แƒ แƒ˜แƒขแƒ˜แƒ™แƒฃแƒšแƒ˜ t แƒแƒ แƒ›แƒฎแƒ แƒ˜แƒ•แƒ˜

2.1788128297


Please support us!