- Picture and text skills
- Case
Returns the corresponding probability that the value in the area falls within the specified interval.
If upper_limit is not given, returns the probability that the value in the interval x_range is equal to the lower limit lower_limit.
Syntax
PROB(x_range,prob_range,lower_limit,upper_limit)
X_range x numerical range with respective corresponding probability values.
Prob_range corresponds to each value in x_range a set of probability values.
Lower_limit is the numerical lower bound used for function calculation probability .
Upper_limit is optional for function calculation probability Numerical upper bound.
Description
• If any value in prob_range is ≤ 0 or > 1, function PROB returns the error value #NUM!.
• If the sum of all values in prob_range is greater than 1. Function PROB returns error value #NUM!.
• If upper_limit is omitted, the function PROB returns the value The probability when equal to lower_limit.
• If the data points in x_range and prob_range The corresponding numbers are different, and the function PROB returns the error value #N/A.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/PROB-han-shu-ji-suan-shu-zhi-zhi-ding-qu-jian-de-gai-lyu.html
支付宝扫一扫 
评论列表（196条）
测试