![]() The equation for the correlation coefficient is:Īre the sample means AVERAGE(array1) and AVERAGE(array2). A correlation coefficient that is closer to 0, indicates no or weak correlation. ![]() ![]() Positive correlation means that if the values in one array are increasing, the values in the other array increase as well. If either array1 or array2 is empty, or if s (the standard deviation) of their values equals zero, CORREL returns a #DIV/0! error.Īs much as the correlation coefficient is closer to +1 or -1, it indicates positive (+1) or negative (-1) correlation between the arrays. If array1 and array2 have a different number of data points, CORREL returns a #N/A error. If an array or reference argument contains text, logical values, or empty cells, those values are ignored however, cells with zero values are included. The CORREL function syntax has the following arguments:Īrray2 Required. For example, you can examine the relationship between a location's average temperature and the use of air conditioners. Use the correlation coefficient to determine the relationship between two properties. The CORREL function returns the correlation coefficient of two cell ranges.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |