The PROB() function returns that a range of values are between two limits. The syntax for the function is PROB (x_range, prob_range, lower_limit, upper_limit). The argument "x_range" can be an array, a referenced range of cells or a named range. However referenced cells that do not contain values or that cannot be converted to numeric values such as text, logical values or empty cells will be ignored. Values in the "prob_ range" argument must be between 0 and 1 otherwise the function will return a #NUM error. Note: If the arguments "x_range" and "prob_range" contain different numbers of data points the PROB function will return a #N/A error value. The PROB function calculates the probability that a range of data values "x_range" exists within two limits "lower_limit" and "upperlimit" given known the probabilites each given data point in the range occuring ("prob_range"). For example: PROB({0,1,2,3,4},{0.1,0.2,0.4,0.2,0.1},2,4) = 0.7 That is there is a 70% chance that a randomly chosen number (from the x_range) will fall between the numbers 2 and 4. This can be calculated confidently given the known probabilitis of each data point are accurate. If the "upper_limit" is left omitted the function will use the highest number in the x_range" to determine the value of the upper limit. e.g. PROB ({0,1,2,3,4},{0.1,0.2,0.4,0.2,0.1},2) = 0.7

How to use the PROB() function: Type " =PROB( " Enter the coordinates of the"x_range" cell "A2:A10" Type a comma. Enter the coordinate of the "prob_range" last data cell "B2:B10". Type a comma. Enter a value for the "lower_limit", "2" Type a comma. Enter the value for the "upper_limit", "5". Type ")" then press the "Enter" key.