|
|
|
|
|
by thanatropism
4485 days ago
|
|
> normally financial or market sizing ones A-ha. Here's the hidden assumption. You're looking at sheets that have a handful of parameters/assumptions and span out their consequences. (You want to stake out the market of people selling Monte Carlo add-ins.) Many people use spreadsheets as ad hoc accretion calculators/graphers/explorers. This very week -- I estimated about a hundred separate generalized-extreme-value models in Mathematica (working basically by hand to import data from Excel; but this because there was a lot of careful culling), then exported a number of statistics from the distributions. Then I spent a couple of hours a day later looking at scatterplots in Excel -- trying transformations, whatever worked -- that helped me show how those models isolated a particular global feature across the hundred-or-so distributions. I was looking at your demo and shaking my head -- "is this for cash flow models? But it doesn't even have features for stochastic parameters..." But I guess I see it. |
|