Apple Event: May 7th at 7 am PT
In app Numbers there are a lot of statistic functions, but there is not any inverse of the cumulative of those functions, as normal, lognormal, triangular and uniform.
iPad Air
Which "simple function"? You haven't supplied function names.
SG
The function is: the inverse function of cumulative triangular distribution.
It is a statistic function. In Numbers the only inverse cumulative is the inverse of beta cumulative (BETA.INV.***)
mcsalo wrote:
The function is: the inverse function of cumulative triangular distribution.
Does Excel have it?
SG
NO. Excel has NO inverse cumulative function.
In Numbers there is BETA.ACUM.INV . Ok, very good.
Now it is only necessary to repeat the procedure (inverse cumulative) to the others important statistic functions, which people really use.
Numbers has a large subset of Excel functions plus a couple of its own (related to dates and time). If Excel doesn't have the function then Numbers likely won't either.
Often an Excel solution can be adapted to Numbers, though.
Searching for "inverse triangular distribution excel" I came up with quite a few hits, including this one, which may or may not help (I have only a basic grounding in probability and statistics).
SG
But it is a simple use of an equation, simpler and easier than beta.acum.inv. I will continue to use a formula or equation. ok.
Thanks for your answer.
I need to use a specific function: the inverse of cumulative triangular distribution, very useful in Monte Carlo simulation. Why is this simple function not available in NUMBERS.?
