First time with Pearson’s formulae for correlation

Sparky91

New member
Joined
Apr 14, 2018
Messages
2
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=&quot]1.363138,[/FONT][FONT=&quot]1.389033,[/FONT][FONT=&quot]1.417664,[/FONT][FONT=&quot]1.448548,1[/FONT][FONT=&quot].480294[/FONT]
Y Values :- [FONT=&quot]22416,[/FONT][FONT=&quot]23138,24042,24795,25845

[/FONT]
Pearson's formulae for correlation :- "attached"
24042
24042
24042
24042
24042

[FONT=&quot]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=&quot]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]
 

Attachments

  • pearsons.png
    pearsons.png
    3.5 KB · Views: 6
Top