Documentation/Calc Functions/PROB

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

PROB

Category:

Statistical Analysis

Summary:

Returns the probability that values in a range are between two limits.

Syntax:

PROB(Data; Probability; Start; End)

Returns:

Arguments:

Data is the array or range of data in the sample.

Probability is the array or range of the corresponding probabilities.

Start is the start value of the interval whose probabilities are to be summed.

End (optional) is the end value of the interval whose probabilities are to be summed. If this parameter is missing, the probability for the Start value is calculated.

If there is no End value, this function calculates the probability based on the principle that the Data values are equal to the value of Start.

Additional details:

Examples:

=PROB(A1:A50;B1:B50;50;60) returns the probability with which a value within the range of A1:A50 is also within the limits between 50 and 60. Every value within the range of A1:A50 has a probability within the range of B1:B50.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: