Table sorting
|
# data (Students) |
1 |
2 |
3 |
4 |
5 |
.. |
29 |
30 |
n=30 |
|
X value Literature marking (x) |
3 |
7 |
8 |
.. |
.. |
7 |
1 |
7 |
S=164 |
|
Y value Foreign language marking (y) |
2 |
6 |
10 |
.. |
.. |
7 |
0 |
7 |
S=157 |
|
x2 value |
9 |
49 |
64 |
.. |
.. |
49 |
1 |
49 |
S=1040 |
|
y2 value |
4 |
36 |
100 |
.. |
.. |
49 |
0 |
49 |
S=1047 |
|
xy value |
6 |
42 |
80 |
.. |
.. |
49 |
0 |
49 |
S=1026 |
|
x mean |
X=164/30 =5,4666667 |
||||||||
|
y mean |
X=157/30 =5,2333333 |
||||||||
|
x variance |
S2x= (1040/30) - 5,46666672 = 4,7822222 |
||||||||
|
y variance |
S2y= (1047/30) - 5,23333332 = 7,512222222 |
||||||||
|
Standard deviation of x |
|
||||||||
|
Desviación típica de y |
|
||||||||
|
Covarianza de xy |
Sxy=[(164.157)/30]-(5,4666667. 5,2333333) = 5,59111111 |
||||||||
= 
= 2,186829262
= 
= 2,740843341
# data: In this element, in the row, the number of elements to study will be placed. In the example, using the marks and students, we will encounter the number of students in the classroom, i.e. from 1 to 30 and in the last cell you will find the total number of students, i.e. 30.
X value: In this row you will have the first group of data related with the element to study. In the example using the marks and students, you will encounter the marks obtained by each student in the subject and in the last cell there will be the total number of points obtained by the class.
Y value: In this row you will find the second group of data related with each element to study. In the example of marks and students, you will find the marks that each student has obtained in a subject and in the last cell you will find the total number of points obtained by the class.
x2 value: In this row you will find the square of the first group of data related with each element to study. In the example of marks and students, you will find the square of each student marking in literature and in the last cell you will find the total number of points obtained by the class.
y2 value: In this row the square of the second group of data related to each element to study will be encountered. In the example of marks and students, the marks obtained by each student in foreign languages will be placed, whilst in the last cell the total number of points obtained by class will be placed.
xy value: In this row, the product of the data from the first group and the second group related to each element to study will go. In the example used corresponding to marks and students, the product of each student marks in both subjects will go and in the last cell you will find the total number of points obtained by the class.
Arithmetic mean of (x): In this row the average of a collection of numbers obtained by dividing the sum of those numbers by the amount of them will be placed. In the example of marks and students, the sum of marks obtained by each student in the first subject divided by the total number of students in the class will go here.
Arithmetic mean of (y): In this row will go the average of a collection of numbers obtained by dividing the sum of those numbers by the amount of numbers. In the example used will go the sum of marks obtained by each student in the second subject divided by the total number of students in the class.
Variance of (x): It is the square of the standard deviation. In the example, we will place the sum of x2 divided by the number of students subtracted by the square of the arithmetic mean obtained for the first subject.
Variance of (y): It is the square of the standard deviation. In the example, it will be calculated by the sum of y2 divided by the number of students subtracted by the square of the arithmetic mean for the second subject.
Standard deviation of (x): It is square root of the variance of x. In the example considered, it will be calculated as the square root of the sum of x2 divided by the number of students subtracted by the square of the arithmetic mean obtained for the first subject.
Standard deviation of (y): It is the square root of the variance of y. In the example used, it will be calculated as the square root of the sum of y2 divided by the number of students subtracted by the square of the arithmetic mean obtained for the second subject.
Covariance of x, y: It is the measure of the trend of two random variables, x and y, to be modified together. In our example, it has to be explained whether there is relation or not among the marks of both subjects.