Covariance
Calculates the covariance of two sets of numeric data.
The covariance is a measure of how much two random variables change together.
For more information on statistical covariance, refer to the corresponding Wikipedia article.
แแแแแชแแแแแ
Input Range: The reference of the range of the data to analyze.
Results to: The reference of the top left cell of the range where the results will be displayed.
The following data will be used as example
|
ย |
A |
B |
C |
|---|---|---|---|
|
1 |
แแแแแแแขแแแ |
แคแแแแแ |
แแแแแแแแ |
|
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 covariance of the sample data above.
|
แแแแแ แแแชแแแแ |
Column 1 |
Column 2 |
Column 3 |
|---|---|---|---|
|
Column 1 |
111.65 |
||
|
Column 2 |
-61.4444444444 |
258.41 |
|
|
Column 3 |
-32 |
53.11 |
204.61 |
