You are Here: Home >< Maths

# Maths/Statistics Help Pearsons Correlation Watch

1. Hi everyone Im using the Pearsons correlation method to find the correlation of to variables x being Rating and y being votes however I keep messing up the formula can someone please input this for me into a suitable programme/calculator and tell me the answer?

Pearsons Corrleation

x= 249.3
y= 7635372
xy= 63925204.9
x2 ( x squared)= 2073.61
y2 ( y squared)= 3062783060420
n= 30

here are the needed values
2. (Original post by Rhy)
...
I get 11.94722272

So, unless I made a mistake, there's an error in the data.
3. (Original post by smiley321)
YA GET ME I GOT 18.156, GOT a* MATHS ALEVEL, ITE LOVE
We could both be wrong.

I'd be more convinced if we both had the same answer.

Do we have a third vote?
4. (Original post by ghostwalker)
We could both be wrong.

I'd be more convinced if we both had the same answer.
He is a troll GW, posting nonsense on threads
5. (Original post by ghostwalker)

Do we have a third vote?
I got 0.32358

but on an annoying calculator so will try again

Checked using a spreadsheet and get the same
6. (Original post by TenOfThem)
He is a troll GW, posting nonsense on threads
Thanks. No red gem to give them away - damn!

(Original post by TenOfThem)
I got 0.32358

but on an annoying calculator so will try again

Checked using a spreadsheet and get the same
Yep, I had input the data incorrectly. 0.323581962
Thank god spreadsheets are easy to correct.

PRSOM.
7. (Original post by TenOfThem)
I got 0.32358

but on an annoying calculator so will try again

Checked using a spreadsheet and get the same
I get the same as you on a calculator
8. I'm not a troll at all haha, that is the answer I needed thankyou It shows there is a mild positive correlation is thanks guys
9. Would anyone mind giving me the steps on how they got 0.323581962 as for some reason when I try I keep getting it wrong
10. (Original post by Rhy)
I'm not a troll at all haha
No-one suggested that you were

It shows the correlation is negative
erm

no it doesn't
11. (Original post by Rhy)
Would anyone mind giving me the steps on how they got 0.323581962 as for some reason when I try I keep getting it wrong
Just put those values in ... I cannot really give you steps

Are you using enough ()
12. Is it possible for you to type the way you are doing as I may be misusing the formula for example enough brackets
13. Oh and how did you manage to calculate this on a spreadsheet, which programme did you use excel?
14. (Original post by Rhy)
Oh and how did you manage to calculate this on a spreadsheet, which programme did you use excel?
I used excel.

Put in the numbers (correctly - not like what I did), put in the formula appropriately, and out pops the answer.
15. (Original post by Rhy)
Ah I've used the pearson function on excel
erm

you only have 18 y-values there

And x^2 in your original post is incorrect

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: April 12, 2013
Today on TSR

### What is the latest you've left an assignment

And actually passed?

### Simply having a wonderful Christmas time...

Discussions on TSR

• Latest
• ## See more of what you like on The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

• Poll
Useful resources

## Make your revision easier

### Maths Forum posting guidelines

Not sure where to post? Read the updated guidelines here

### How to use LaTex

Writing equations the easy way

### Study habits of A* students

Top tips from students who have already aced their exams

Can you help? Study help unanswered threads

## Groups associated with this forum:

View associated groups
Discussions on TSR

• Latest
• ## See more of what you like on The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

• The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.