	Related Topics and Links:
	Function Wizard Functions Data Entry Tips for Functions Function Wizard - Data Sources

FMATRIX

Description: Returns a value from the Fisher variance/covariance matrix for the selected data source. Enter the row and column of the desired cell in the matrix table. The 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:

A default data source selected from the Data Source Index drop-down list.
A data sheet name (e.g., "Folio1!Data 1").
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.

E-mail Link