Statistics

Monte Carlo analysis without macros Monte Carlo analysis without macros
(0)
909
113
The Monte Carlo method tests a large number (several hundreds or thousands) of "scenarios" in which the inputs are random…
Analysing data in Excel Analysing data in Excel
(0)
1,361
116
In this post I have collected a handful of techniques for working with data in Excel: looking up values, matching…
Portfolio Analysis and Sales Forecasting Portfolio Analysis and Sales Forecasting
(0)
995
2
The attached template provides the basis for product portfolio analysis as follows: - key statistics: total, average, median, standard deviation (total…