cumulative distribution

I'd like a formula that examines a cell and an array to determine what, if any funds are available to fund a reference cell. Example: Budget$500 Request:Available: Item (Priority #1)$350$350 Item (Priority #2)$100$100 Item (Priority #3)$250$50 Item (Priority #4)$75$0 What...

Hi, I am trying to create a formula in excel which shows the provides the Cumulative distribution function for a skewed normal distribution giving set parameters for skewness, mean and std. dev. I have done this for a normal distribution using the Norm.Dist (Culminative True) function, but i...

I have a year end sale figure of £80,000 and want to divide this between 12 months in way that starts from Jan to Dec, and the Jan Sale not to be less than £4,000 and each month the sale increase slightly with a few fluctuations in Sep, Feb and March when there is seasonality and the sales are...

Hello everyone, I would like to use the Student T density function & cumulative probability function in a measure related to a data table in PivotTable Fields. Excel has it with T.DIST(..., ..., FALSE/TRUE). However is it a more or less straightforward to use an equivalent in DAX? Thanks in...

Hi All, I am trying to solve the following formula in excel for variable "n": All other variables will have already been calculated and I just need to solve for "n". I have tried using the different binomial functions offered by excel but none give the results I am looking for...