First time with Pearson’s formulae for correlation
I spent all day struggling through this only to punch the data into an online calculator here >http://www.socscistatistics.com/tests/pearson/Default2.aspx which got a different result.
If someone could explain where I went wrong it would be greatly appreciated.
X Values :- [FONT="]1.363138,[/FONT][FONT="]1.389033,[/FONT][FONT="]1.417664,[/FONT][FONT="]1.448548,1[/FONT][FONT="].480294[/FONT]
Y Values :- [FONT="]22416,[/FONT][FONT="]23138,24042,24795,25845
[/FONT]Pearson's formulae for correlation :- "attached"
[FONT="]Where,
N = Number of values for elements
X = population in millions
Y = Giga watt hours
ΣXY = Sum of the product of first and second scores
ΣX = Sum of first scores
ΣY = Sum of second scores
ΣX2 = Sum of square first scores
ΣY2 = Sum of square second scores
My Working :-
N = 5
ΣXY = 170953.97094
ΣX = 7.098677
ΣY = 120236
ΣX2 = 10.08689073377
ΣY2 = 2898617914[/FONT]
[FONT=Segoe UI, Arial, sans-serif]r = (N*ΣXY) - (ΣX*ΣY) / SQRT((N*ΣX2) - ΣX^2) * ((N*ΣY2) - ΣY^2)[/FONT]
[FONT=Segoe UI, Arial, sans-serif]r = (5*170953.97094) - (7.098677*120236) / SQRT((5*10.0868907337) - 7.098677^2) * ((5*2898617914) - 120236^2)[/FONT]
[FONT=Segoe UI, Arial, sans-serif]r = 1253.326928 / 1694.33547331[/FONT]
[FONT=Segoe UI, Arial, sans-serif]r = 0.73971592269
[/FONT][FONT="]The answer I got when I entered the data here> [/FONT][FONT=Segoe UI, Arial, sans-serif]http://www.socscistatistics.com/tests/pearson/Default2.aspx was r = 0.9991
If someone could show me where I went wrong that would be great.
Thanks in advance.[/FONT]
I spent all day struggling through this only to punch the data into an online calculator here >http://www.socscistatistics.com/tests/pearson/Default2.aspx which got a different result.
If someone could explain where I went wrong it would be greatly appreciated.
X Values :- [FONT="]1.363138,[/FONT][FONT="]1.389033,[/FONT][FONT="]1.417664,[/FONT][FONT="]1.448548,1[/FONT][FONT="].480294[/FONT]
Y Values :- [FONT="]22416,[/FONT][FONT="]23138,24042,24795,25845
[/FONT]Pearson's formulae for correlation :- "attached"
24042 |
24042 |
24042 |
24042 |
24042 |
[FONT="]Where,
N = Number of values for elements
X = population in millions
Y = Giga watt hours
ΣXY = Sum of the product of first and second scores
ΣX = Sum of first scores
ΣY = Sum of second scores
ΣX2 = Sum of square first scores
ΣY2 = Sum of square second scores
My Working :-
N = 5
ΣXY = 170953.97094
ΣX = 7.098677
ΣY = 120236
ΣX2 = 10.08689073377
ΣY2 = 2898617914[/FONT]
[FONT=Segoe UI, Arial, sans-serif]r = (N*ΣXY) - (ΣX*ΣY) / SQRT((N*ΣX2) - ΣX^2) * ((N*ΣY2) - ΣY^2)[/FONT]
[FONT=Segoe UI, Arial, sans-serif]r = (5*170953.97094) - (7.098677*120236) / SQRT((5*10.0868907337) - 7.098677^2) * ((5*2898617914) - 120236^2)[/FONT]
[FONT=Segoe UI, Arial, sans-serif]r = 1253.326928 / 1694.33547331[/FONT]
[FONT=Segoe UI, Arial, sans-serif]r = 0.73971592269
[/FONT][FONT="]The answer I got when I entered the data here> [/FONT][FONT=Segoe UI, Arial, sans-serif]http://www.socscistatistics.com/tests/pearson/Default2.aspx was r = 0.9991
If someone could show me where I went wrong that would be great.
Thanks in advance.[/FONT]