What is Answerbag?

Ask questions and share your knowledge with the world here on Answerbag. Get the best answers where there are no duplicate questions and questions are always open - our community of over 1,142,000 will find your answer!

Join For Free!
 

How to Calculate Exceedance Probability

Friday, September 04, 2009
Related Tags: probability | exceedance | values | formula | number
 

Instructions

Things You’ll Need:

  • Formula: Rank / (Total Number of Values+1) = Exceedance Probability
  • Step 1:
    Arrange the values that you have from greatest to least. For example, if you are trying to calculate exceedance probability for the peak flow of a river, you might have annual data regarding the water level. If this were the case, then each year would most likely have a different peak flow level. What you would need to do with this data is arrange these peak flow levels from greatest to least.
  • Step 2:
    Add up the total number of values. Using our example from Step 1, this would be equivalent to the number of years for which we have data since each year constitutes a single value.
  • Step 3:
    Plug the total number of values into the formula: Rank / (Total Number of Values+1) = Exceedance Probability. For example, if you found in the previous step that you had 9 values, then you would insert this number into the formula making it: Rank / (9+1) = Exceedance Probability.
  • Step 4:
    Number each individual value, according to its rank in the arrangement. The greatest value should be ranked number one, the second greatest number two, and so on, until each value has a rank.
  • Step 5:
    Decide which value you want to use as the standard. The standard value is the value for which you want to calculate the exceedance probability.
  • Step 6:
    Take the rank of this standard value and plug it into the formula. For example, if we wanted to use the fifth largest value as the standard value in our calculation, we would plug the number "5" into our formula of (Rank / Total Number of Values + 1) = Exceedance Probability. Using our example from Step 2, this would give us 5 / (9 + 1) = Exceedance Probability.
  • Step 7:
    Solve for exceedance probability. With all the variables in place, perform the addition and division functions required of the formula. Using our example, this would give us 5 / (9 + 1) = 5 / 10 = 0.50. The solution is the exceedance probability of our standard value expressed as a percent, with 1.00 being equivalent to a 100 percent probability.

Tips & Warnings

  • Data representing a longer period of time will result in more reliable calculations.

Photo/Video Credit

nws.noaa.gov/climate

Related Content
How to Calculate Normal Probability
Normal probability calculates the number of occurrences for an event based on a certain number of possible outcomes. The calculation is generally expressed as a percentage or a number from zero to...
How to Calculate Normalized Data
"Standardized" and "normalized" are two terms that are often confused when manipulating data. To standardize a data set, individual values are converted to z-scores by using the mean and standard...
How to Use Math in Health Care Careers
Health care professionals use math to complete a variety of medical functions. These functions range from simple data collection to complex statistical computations. Although the type of math used...
Definition of Table of Values
A table of values is a list of numbers that are used to substitute one variable, such as within an equation of a line and other functions, to find the value of the other variable, or missing...
How to Calculate the Sortino Ratio
The Sortino Ratio is a modified version of the Sharpe ratio. It is used by investment managers to calculate portfolio risk. The Sharpe ratio quantifies the return (alpha) over the volatility (beta)...