PsiFrequency (cell,freq type,bin bounds,simulation)
PsiFrequency returns an array of frequencies describing the distribution of trial values for the specified uncertain function cell. Use PsiFrequency to easily draw a histogram chart. You’ll need to “array-enter” this function by selecting a group of cells, typing the function call, and pressing Ctrl + Shift + Enter.
The freq type argument affects the contents of each element of the array result:
0 – Each element contains the frequency of trial values falling into the corresponding bin (like a probability density function)
1 – Each element contains the cumulative frequency of trial values falling into the corresponding bin plus all lower bins (like a cumulative distribution function)
2 – Each element contains the cumulative frequency of trial values falling into the corresponding bin plus all higher bins (like a reverse cumulative distribution function)
The bin bounds argument is either an array of values (e.g. { 5, 10, 15, 20 }) or a cell range containing the upper limit of trial values that should fall into the corresponding bin. The values should be in strictly increasing order. As in the Excel FREQUENCY function, the number of elements in the array result will be one more than the number of values or cells in the bin bounds argument (or fewer, if the array-entered result occupies fewer cells); the last element contains the number of trial values larger than the highest bin bound value.
Alternatively, you can specify an integer number N of bins for the bin bounds argument. In this case, N equal-size bins are assumed, with bounds sufficient to capture all trials values from PsiMin (cell) to PsiMax (cell); N values are returned, with the last one always 1 or 0.
Note to RASON Users: The Create App feature in Analytic Solver supports the translation of the PsiFrequency function into the RASON modeling language when the PsiFequency function is in one of the following two forms:
- =PsiFrequency(cell, freq_type, NumBins) - Specify an integer number N of bins for the bin bounds argument. In this case, N equal-size bins are assumed, with bounds sufficient to capture all trials values from PsiMin (cell) to PsiMax (cell); N values are returned, with the last one always 1 or 0.
- =PsiFrequency(cell, freq_type, CellRange) - Cell range containing the lower and upper limits of trial values that should fall into the corresponding bin. The values should be listed in the cell range in strictly increasing order.