SimulationSlope
RiskAMP Simulation Analysis Functions
Using this function in Excel:
=SimulationSlope(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 slope (m) from a linear regression.
The linear regression equation has the form
y = mx + b
This function solves for the slope (m) based on the values of the reference cells X and Y over all iterations of the simulation. Use the SimulationIntercept function to solve for the intercept (b).