Correlation

Calculates the correlation of two sets of numeric data.

Selle käsu kasutamiseks...

Choose Data - Statistics - Correlation


The correlation coefficient (a value between -1 and +1) means how strongly two variables are related to each other. You can use the CORREL function or the Data Statistics to find the correlation coefficient between two variables.

A correlation coefficient of +1 indicates a perfect positive correlation.

A correlation coefficient of -1 indicates a perfect negative correlation

note

For more information on statistical correlation, refer to the corresponding Wikipedia article.


Andmed

Vahemik: ala, mis sisaldab andmeid, mida tuleb analĂĽĂĽsida.

Tulemused: viide lahtrivahemiku, kuhu tulemused väljastatakse, ülemisele vasakpoolsele lahtrile.

RĂĽhmitamine

Vali, kas sisendandmed paiknevad veergudes või ridades.

Näide

Järgnevaid andmeid kasutatakse näidetena

A

B

C

1

Matemaatika

FĂĽĂĽsika

Bioloogia

2

47

67

33

3

36

68

42

4

40

65

44

5

39

64

60

6

38

43

7

47

84

62

8

29

80

51

9

27

49

40

10

57

49

12

11

56

33

60

12

57

13

26


The following table displays the results of the correlation of the sample data above.

Korrelatsioonid

Column 1

Column 2

Column 3

Column 1

1

Column 2

-0.4029254917

1

Column 3

-0.2107642836

0.2309714048

1


Palun toeta meid!