correlation

Monte Carlo analysis without macros Monte Carlo analysis without macros
(0)
5,486
587
A traditional sensitivity analysis involves testing a limited number of scenarios (e.g. base, upside and downside). Each scenario is a…
Descriptive statistics for grouped (weighted) data Descriptive statistics for grouped (weighted) data
(0)
3,640
194
Excel has a powerful set of tools to perform statistical analysis, but they apply only to ungrouped data. As an…
ASSETS CORRELATION MODEL ASSETS CORRELATION MODEL
(0)
1,514
83
Achieve greater diversification in your asset allocation by using this tool to calculate the correlation coefficient between any two variables, including…