Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X
Hi
I'm trying to make a sheet for consolidation of soil with probabilistic analyses using montecarlo function.
As attached is a sheet of my initial try, but the formula doesn't compute even if
the units are totally dropper off from the matrices.
Can this type of relatively simpel formula be used,
or do I first need to make a vector of ech parameter with the random fluctuation?
The aim is that in final stage the units could be used in the formula.
Normal distributions require means and standard deviations. I've never thought much of the inbuilt montecarlo function in MC, it's too restrictive. I've attached an alternative approach (making some assumptions about means and standard deviations).
Alan
Your function must be a function of a single variable, which may be an array:
With regards to using units, you've bad luck. Mathcad (unlike Prime) does not allow differently united elements in a single array.
Another error is that you forgot to supply the 3rd parameter Rvals to the montecarlo() function.
Success!
Luc