Difference between revisions of "Documentation/How Tos/Calc: PROB function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m (→Example:) |
m |
||
(11 intermediate revisions by 6 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE:PROB function}} |
+ | {{Documentation/CalcFunc StatisticalTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_POISSON_function | ||
+ | |NextPage=Documentation/How_Tos/Calc:_STANDARDIZE_function | ||
+ | }}__NOTOC__ | ||
== PROB == | == PROB == | ||
Line 9: | Line 14: | ||
: <tt>'''values'''</tt> is a range or array of numbers (possibly unordered). | : <tt>'''values'''</tt> is a range or array of numbers (possibly unordered). | ||
− | : <tt>'''probabilities'''</tt> is a range or array of numbers of the same size as <tt>'''values'''</tt>, indicating the corresponding probability (>0 and <=1) | + | : <tt>'''probabilities'''</tt> is a range or array of numbers of the same size as <tt>'''values'''</tt>, indicating the corresponding probability (>0 and <=1) that each value in <tt>'''values'''</tt> will occur. The numbers in <tt>'''probabilities'''</tt> must sum to 1 exactly. |
: <tt>'''PROB'''</tt> finds all <tt>'''values'''</tt> which are between <tt>'''start'''</tt> and <tt>'''end'''</tt> inclusive and returns the sum of their corresponding <tt>'''probabilities'''</tt>. | : <tt>'''PROB'''</tt> finds all <tt>'''values'''</tt> which are between <tt>'''start'''</tt> and <tt>'''end'''</tt> inclusive and returns the sum of their corresponding <tt>'''probabilities'''</tt>. | ||
: <tt>'''end'''</tt> may be omitted, in which case <tt>'''PROB'''</tt> returns the probability corresponding to <tt>'''start'''</tt> (or <tt>'''0'''</tt> if <tt>'''start'''</tt> is not present in <tt>'''values'''</tt>). | : <tt>'''end'''</tt> may be omitted, in which case <tt>'''PROB'''</tt> returns the probability corresponding to <tt>'''start'''</tt> (or <tt>'''0'''</tt> if <tt>'''start'''</tt> is not present in <tt>'''values'''</tt>). | ||
+ | |||
+ | |||
+ | : Advanced topic: <tt>'''PROB'''</tt> evaluates the <tt>'''values'''</tt> and <tt>'''probabilities'''</tt> parameters as [[Documentation/How_Tos/Using_Arrays|array formulas]] - see the examples. | ||
=== Example: === | === Example: === | ||
Line 25: | Line 33: | ||
: returns <tt>'''0.4'''</tt>, the probability for <tt>'''4'''</tt>. | : returns <tt>'''0.4'''</tt>, the probability for <tt>'''4'''</tt>. | ||
− | === | + | |
− | [[Documentation/How_Tos/Calc: Statistical functions| | + | Evaluation as an * [[Documentation/How_Tos/Using_Arrays|array formula]]: |
+ | |||
+ | <tt>'''PROB(A1:A2*2; B1:B2; 2)'''</tt> | ||
+ | : where cells A1, A2 contain 1, 4 and cells B1, B2 contain 0.3, 0.7, returns <tt>'''0.3'''</tt>. <tt>'''PROB'''</tt> forces evaluation of <tt>'''values'''</tt> as an array formula, so that <tt>'''A1:A2*2'''</tt> yields the array {2 | 8}. Thus, <tt>'''PROB({2 | 8}; B1:B2; 2)'''</tt> is actually evaluated to give the result. | ||
+ | |||
+ | <tt>'''PROB(A1:A2; B1:B2/100; 4)'''</tt> | ||
+ | : where cells A1, A2 contain 1, 4 and cells B1, B2 contain 30, 70, returns <tt>'''0.7'''</tt>. <tt>'''PROB'''</tt> forces evaluation of <tt>'''probabilities'''</tt> as an array formula, so that <tt>'''B1:B2/100'''</tt> yields the array {0.3 | 0.7}. Cells B1 and B2 effectively contain percentages here. | ||
+ | |||
+ | === Issues: === | ||
+ | *If <tt>'''start'''</tt> is given as a range (eg D4:D5) and the formula entered in scalar (non-array) mode then the top left value of the range appears to be evaluated, rather than the intersection of the range and the formula cell row/column. This is a minor issue which is recorded in {{bug|88967}}. | ||
+ | |||
+ | {{SeeAlso|EN| | ||
+ | * [[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]] | ||
+ | * [[Documentation/How_Tos/Using_Arrays|Using Arrays]] | ||
+ | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
+ | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
+ | [[Category: Documentation/Reference/Calc/Statistical functions]] |