![]() 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 |