Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

How to calculate Pearson's Rank in Microsoft Excel?

I am attempting to do Geography coursework and for this I need to calculate Pearson's rank between two different sets of data. The one problem is whenever I attempt to do it after putting it through the entire formula it comes out at -63.5 which obviously is not right as it is not between -1 and +1 so if anyone has any advice as to how to do it differently or a guide on how to do it in excel then I would be very grateful.

Please and Thank You

Seb

1 Answer

Relevance
Still have questions? Get your answers by asking now.