How do you calculate pearson's r from this table?

X Y
5 24
8 40
3 20
6 30
9 40
7 35
10 50
2 22

The correct answer for the linear regression table is Y' = 3.56X + 10.4. But every time i calculate r, i get a value over 1.

Here is another one that i couldn't figure out the r:

Student/QuizScore/FinalScore
1 / 5 / 82
2 / 8 / 80
3 / 3 / 75
4 / 1 / 60
5 / 10 / 92
6 / 6 / 85
7 / 7 / 86
8 / 4 / 70
9 / 2 / 42
10 / 6 / 78

Always Pearson's r ≤ 1. One indicates perfect predictability. How can you get better than perfect predictability?

I searched Google under the key words "calculating pearson's r" to get these possible sources:

http://www.google.com/search?client=safari&rls=en&q=calculating+pearson's+r&ie=UTF-8&oe=UTF-8

In the future, you can find the information you desire more quickly, if you use appropriate key words to do your own search. Also see http://hanlib.sou.edu/searchtools/.