Results 1 to 8 of 8

Probability Formula for Large Data Set

Threaded View

  1. #1
    Registered User
    Join Date
    04-03-2021
    Location
    CA, US
    MS-Off Ver
    MS365 Version 2103 (Build 13901.20312)
    Posts
    4

    Probability Formula for Large Data Set

    Hello,

    I am trying to solve the answer to two probability questions with multiple variables as they pertain to a large data set. I am sure after assistance with the formula/method for solving one question and a portion of data, I will be able to solve the rest. The problem and questions are as follows and the data set is attached (if I need to provide more information, clarify anything, or post in a more appropriate forum, please let me know):

    Problem background
    The 2013-16 drought prompted us to secure additional water supplies through transfers from other agencies. This water could then be stored in Lake Oroville, a major reservoir with a capacity of 3.5 million acre-feet (MAF).
    However, storing water in Oroville carries a risk: if a wet winter causes the lake level to get too high, operators must release (spill) excess water to avoid the risk of catastrophic flooding. The maximum volume of water that Oroville can hold without exceeding this level is known as the Flood Control Limit, and it varies by month (in order to accommodate wet season runoff). Any stored water that causes the lake to rise above the Flood Control Level will therefore be lost. In this exercise, you will help decide whether to approve a proposed transfer of 200 thousand acre-feet (TAF) by estimating the probability of spilling this water, given a range of likely future hydrologic conditions.

    The CALSIM model estimates the volume of water stored in Oroville over the next 24 months by simulating multiple future precipitation and runoff conditions (hydrologic sequences). These hydrologic sequences come from historical data for the years 1952—2001. Each of the 50 model runs uses a different historical year as the starting point. For example, model run #1 assumes the next 24 months will look like 1952-53, run #2 assumes they will look like 1953-54, etc. Together, the 50 model runs constitute a range of possible futures from which probabilities can be determined.
    The results of these model runs are shown in the excel workbook, in the ‘Oroville profile’ tab. For each month, the estimated Oroville Storage and Flood Control Limit is given in TAF. If the 200 TAF of transfer water is added on top of the modelled storage, any excess water over the flood control limits would be subject to spilling.

    Questions
    1. Assuming we place 200 TAF (200,000 acre ft) of transfer water in storage immediately, what is the probability of having 180 TAF or more (90%) remaining after 24 months?

    2. What is the probability of having 100 TAF (50%) or more remaining in storage after 24 months?
    Attached Files Attached Files
    Last edited by justindigo; 04-07-2021 at 04:46 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel Probability Function - How to check and apply probability
    By StormerJack in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-10-2019, 03:06 PM
  2. Probability formula
    By jack3dm in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-26-2018, 04:23 PM
  3. Formula to output +/-1 at specified probability
    By chilledmalt in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-04-2017, 05:47 PM
  4. average of data by date to probability formula steps help
    By jamie2v in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-20-2014, 05:17 PM
  5. Probability/Formula Help
    By jamesryan in forum Excel General
    Replies: 1
    Last Post: 08-10-2007, 06:36 PM
  6. Probability Question:probability outcomes
    By Myles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2006, 06:45 AM
  7. Replies: 1
    Last Post: 09-08-2005, 10:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1