BUSINESS ADMINISTRATION
COMPUTER APPLICATION IN BUSINESS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
CORRELATION
|
|
|
CORR
|
|
|
CORREL
|
|
|
COREL
|
Detailed explanation-1: -The CORREL function returns the correlation coefficient of two cell ranges. Use the correlation coefficient to determine the relationship between two properties. For example, you can examine the relationship between a location’s average temperature and the use of air conditioners.
Detailed explanation-2: -The Excel Correl function is the same as the Excel Pearson Function, except that, in earlier versions of Excel (earlier than Excel 2003), the Pearson function may exhibit some rounding errors.
Detailed explanation-3: -The CORREL function in Google Sheets calculates the correlation coefficient between two data sets. The syntax for CORREL is: =CORREL(array1, array2) The first argument, array1, is the first data set. The second argument, array2, is the second data set.
Detailed explanation-4: -#DIV/0 error is an error that occurs if the arrays are empty or if the standard deviation of their values equals zero. The cells with value zero are accepted; however, an array containing a text, logical value, or left empty are ignored.