The spreadsheet did not show enough calculations, such as numerator of equation, where you are compiling the sum of the x times y variances from their mean data.  Also, if working with spreadsheets, such as excel, I have found that parenthesis around values helps to ensure proper steps in calculations of complex equations.  I can see from plot r is high, but 1.0 is max.  

Dear Mr. William F. Hansen,

Thank you very much for your help. I realized it was kind of stupid mistake. Now that I did what you corrected me to do, I got a more relevant point, it's still low because it has resulted in 0.44, but it is more relevant. Thank you again, Sir!

Regards,

Adi Seno Abyoga

If you get a correlation coefficient (r, r-squared, R, R-squared) greater than 1 there is a mistake. There are no exceptions.

I am glad you have worked things out.

Theoretically, it is not acceptable. But, we are some time getting results more than 1 also but as much as you got >3.  Try to use some software for calculation r.

Dear Mr. Timothy A Ebert and Mr. Rameswar Prasad Sah,

Thank you very much for pointing that out. I am aware that this is due to my lack of experience in processing the data. Software is really useful in terms doing this statistical analysis compare to in hand calculation with excel which sometimes can lead to a fatal mistake like this. Once again, thank you for your input kind people.

Best Regards,

Adi Seno Abyoga

Dear Adi

Correlation coefficient ( r ) estimation ranged between +1 and - 1 and not exceed them, in case you got a high estimation, that mean some errors were made in the calculations, there are many Softwares ( SPSS, SAS, .... ) can help you to get accurate results.

Good Luck

Dear Mr. Khalid Hassan, 

thank you very much for your input again. I will make sure in the future endeavor that I will do it correctly, I will discuss again much further in detail about my results today and will post it again.

Best Regards,

Adi Seno Abyoga