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