	Related Topics:
	Spreadsheet Data Source Functions Data Entry Tips for Functions

FMATRIX

Description: Returns a value from the Fisher variance/covariance matrix for the selected data source. Enter numbers to identify the row and column in the matrix table. The full table is displayed in the "Quick Results Report" for the calculated data sheet.

Syntax: FMATRIX (Data_Src, Row, Column)

Data_Src is the source data sheet from which the information is taken.

Row is the row number of the "Var/Cov Matrix" table in the Quick Results Report.
Column is the column number of the "Var/Cov Matrix" table in the Quick Results Report.

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:

FMATRIX (“Folio1!Data 1”, 1,1) = VarBeta = 0.0028467101839658

Note that this value will vary depending on the source data set.