Statistics

Analysing data in Excel
(0)
813
82
In this post I have collected a handful of techniques for working with data in Excel: looking up values, matching…
Monte Carlo analysis without macros
(0)
553
76
The Monte Carlo method tests a large number (several hundreds or thousands) of "scenarios" in which the inputs are random…
Predictive statistics in financial modeling Predictive statistics in financial modeling
(0)
498
48
In this publication I will explain:   - how to build trends and why commonly used CAGR rarely gives reliable…
Variance Analysis & Portfolio Statistics Variance Analysis & Portfolio Statistics
(0)
580
1
The attached template provides the basis for product portfolio analysis. The template performs the following types of analysis: - key…