Related Topics: | ||
Description: Returns the rank value (i.e., the unreliability estimate from rank regression) for the specified cell. Use numbers to identify both the row and column (e.g., for cell A2 in the data sheet, enter 2 for the row and 1 for the column).
Syntax: DATARANK(Data_Src, Row, Column)
Data_Src is the source data sheet from which the value is taken.
Row is the row number in the data sheet.
Column is the column number in the data sheet.
Remarks:
The Data_Src can be one of the following values:
If using a default data source, it must be either 1, 2, 3 or 4, as selected from the Data Source Index drop-down list.
It can take a data sheet name (e.g., "Folio1!Data 1").
It can take a variable name defined in the Defined Names window (e.g., datasource).
The Row and Column values must be greater than 0.
Example:
DATARANK("Folio1!Data 1", 1, 1) = 0.001742214906
Note that this value will vary depending on the source data set.
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.