In the workbook attached, I am trying to compute Pearson's correlation coefficient in cell B21. The expected answer is 0.529809. How can I feed the below formula in cell B21 to give the expected answer?
6(20,485) – (247 × 486) / [√[[6(11,409) – (2472)] × [6(40,022) – 4862]]]
Σx 247
Σy 486
Σxy 20485
Σx2 11409
Σy2 40022
n 6
Last edited by gko_87; 07-26-2017 at 07:08 AM.
OnditiGK
Since you have Excel 2010... just use PEARSON function.
=PEARSON(B2:B7,C2:C7)
If using 2007... use
=CORREL(B2:B7,C2:C7)
But read the detail in link as well.
http://www.statisticshowto.com/corre...nt-excel-2007/
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
I know how to use the function, but I want to be able to enter the formula manually. Kindly look at my formula in B21 and tell me what I am missing. There is a reason for this. Please.
Read the link.
https://en.wikipedia.org/wiki/Pearso...on_coefficient
You are missing SQRT for second part of denominator calculation.
=((B19*B16)-(B14*B15))/(SQRT((B19*B17-(B14^2)))*(SQRT(B19*B18-(B15^2))))
Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks