Correlation Method

To find a link between problems with the verses of Al - Quran then used the correlation method. This method uses mathematical calculations to produce a number that indicates the link between the problem and verses of the Qur'an verses. Correlation formula is :

Where x and y is the average sample mean (array1) and average (array2).

Restore the correlation coefficient of the array1 and array2 cell ranges. Use the correlation coefficient to determine the relationship between the two properties. For example, you can examine the relationship between the average temperature of the location and use of AC.

If an array or reference argument contains text, logical values, or empty cells, those values are ignored, but cells with zero values will be included return CORREL # N / A.