描述
PROB函数返回一个范围内的值在两个极限之间的概率。如果未提供upper_limit,则返回x_range中的值等于lower_limit的概率。
语法
PROB (x_range, prob_range, [lower_limit], [upper_limit])
争论
| Argument | 描述 | Required/Optional |
|---|---|---|
| X_range | The range of numeric values of x with which there are associated probabilities. | Required |
| Prob_range | A set of probabilities associated with values in x_range. | Required |
| Lower_limit | The lower bound on the value for which you want a probability. | Optional |
| Upper_limit | The optional upper bound on the value for which you want a probability. | Optional |
Notes
如果省略upper_limit,则PROB返回等于lower_limit的概率。
If any value in prob_range ≤ 0 or if any value in prob_range > 1, PROB returns the #NUM! error value.
如果prob_range中的值之和不等于1,则PROB返回#NUM!。错误值。
如果x_range和prob_range包含不同数量的数据点,则PROB返回错误值＃N/A。
适用性
Excel 2007,Excel 2010,Excel 2013,Excel 2016
Example
