MATRIXSCATTERPLOT
Category: User Defined Function.
Description: Creates as scatter plot graphic of the values present in two matrices.
Syntax: MATRIXSCATTERPLOT(range, range, [section of matrix to use], [cell position where to insert the graphic])
Section of matrix to use: Optional. Possible parameters:
-
BOTH, will use the average between the upper and lower sections of the matrix for the calculation of the correlation coeficient
-
UPPER, only the upper section will be used (above the diagonal)
-
LOWER (default value), only the lower section will be used (below the diagonal)
Cell where to insert the graphic: Optional. Default value is where the formula has been inserted.