SimulationRSquared
RiskAMP Simulation Analysis Functions
Using this function in Excel:
=SimulationRSquared(Y, X)
Function arguments:
| Y | The reference cell of dependent values for the regression |
| X | The reference cell of independent values for the regression |
Returns the coefficient of determination (r²) value from a linear regression.
The coefficient of determination describes what percentage of the variability of the dependent value can be predicted from changes in the independent value.