---
title: "@RISK Models"
canonical: "https://modelassist.epixanalytics.com/space/EA/26581760/%40RISK%20Models"
format: markdown
---
The table below lists all the @RISK models available in ModelAssist. Links are provided to topics that discuss these models. Use Ctrl+F if you want to search for a particular [Software feature](https://modelassist.epixanalytics.com/space/EA/26581732/Main+%40RISK+Functions) or [Excel function](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570), or for a specific modeling technique. All models are unprotected to allow you to use the code for your own problems, but remember to first open @RISK to be able to run the model. Note that all models are copyrighted: as a user of ModelAssist you are authorized to use the models with attribution, so please [cite ModelAssist](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26579303) in your publications.
| | | | | |
| --- | --- | --- | --- | --- |
| **Model name**
**Topic link** | **Techniques used** | **Problem description** | **[Distributions](https://modelassist.epixanalytics.com/space/EA/26581732/Main+%40RISK+Functions)** | **[Excel functions](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)** |
| [Arsenic sweets](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26577894)
[Arsenic sweets download](/wiki/download/attachments/26581760/Arsenic_sweets-AtRISK.xlsx?version=1&modificationDate=1506097535000&cacheVersion=1&api=v2) | [Hypergeometric](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574987) model
[Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574972) model
Direct calculation of probability
[Numerical integration](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575285)
Simulating a stochastic sequence | A bag contains 100 sweets, 20 of which contain arsenic. 20 people take 5 sweets each. You are one of them. A person eating just 1 arsenic sweet has a 50% probability of dying. A person eating 2 or more sweets will certainly die. Question 1: How many arsenic sweets will you get? Question 2: What is the probability you will die? Question 3: How many people will die? Question 4: How many sweets would you need to eat to have eaten 1 arsenic sweet? Question 5: How many sweets would you need to eat to have eaten 2 arsenic sweets? | [Hypergeometric](https://modelassist.epixanalytics.com/wiki/spaces/EA/pages/26575208)
[Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204)
[Discrete](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575205) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[HYPGEOMDIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[COUNTIF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[COMBIN](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Asphalt](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574984)
[Asphalt download](/wiki/download/attachments/26581760/Asphalt-AtRISK.xlsx?version=1&modificationDate=1506097535000&cacheVersion=1&api=v2) | [Gamma estimate of Poisson mean](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574982)
[Numerical integration](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575285) | Different types of asphalt are considered for the resurfacing of a road from City A to City B. The current road has two types of asphalt, called Grey and Black. For the government, safety is the major consideration when choosing the type of asphalt that has to be used for resurfacing. The performance of asphalt of course depends to a large extend on the specific weather and climate circumstances. Both types of asphalt have been used for the current road and we can therefore compare the risks of an accident per mile of Grey asphalt with that of Black asphalt. | [Gamma](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575231) | [GAMMADIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SUMPRODUCT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Basel II](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575614)
[Basel II download](/wiki/download/attachments/26581760/Basel_II-AtRISK.xlsx?version=1&modificationDate=1506097535000&cacheVersion=1&api=v2) | Loan default
Loss model | You are working for a bank that has a portfolio of 25 loans, ranging from $1,000 to $15,000 and belonging to seven different rating grades with long-term (historic) probability of default (PD) levels ranging from 0.5% to 5%. The short term PD is, however, influenced by a macro-economic factor (50%) and an idiosyncratic (random) factor (50%). What are the losses and their distribution parameters under the three different scenarios? | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217)
[Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204)
[Exponential](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575227)
[Correlation Matrix Tool](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575456) | [VLOOKUP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [BetaBinomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575203)
[BetaBinomial download](/wiki/download/attachments/26581760/BetaBinomial-AtRISK.xlsx?version=1&modificationDate=1506097535000&cacheVersion=1&api=v2) | Constructing a [Dirichlet distribution](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575224) | Compares a binomial and a beta-binomial distribution | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217)
[Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204) | |
| [Binomial confidence construction](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575357)
[Binomial confidence construction download](/wiki/download/attachments/26581760/Binomial_confidence_construction-AtRISK.xlsx?version=1&modificationDate=1506097536000&cacheVersion=1&api=v2) | [Constructs a classical statistics confidence distribution for a binomial probability](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575357) | | [Cumulative](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575222)[ Ascending](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[BINOMDIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [BootstrapMoM for Gamma](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575328)
[BootstrapMoM for Gamma download](/wiki/download/attachments/26581760/BootstrapMoM_for_Gamma-AtRISK.xlsx?version=1&modificationDate=1506097505000&cacheVersion=1&api=v2) | [Bootstrap/MoM](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575328) fit | Performs a second-order fit of data to a [Gamma](https://modelassist.epixanalytics.com/space/EA/26575231/Gamma) distribution | [Gamma](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575231) | [AVERAGE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[VAR](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Bounded random walk](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575446)
[Bounded random walk download](/wiki/download/attachments/26581760/bounded_random_walk-AtRISK.xlsx?version=1&modificationDate=1506097505000&cacheVersion=1&api=v2) | | Models a random walk where we impose a boundary condition on a stochastic time series. | [Lognormal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575244) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Capital required](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575611)
[Capital required download](/wiki/download/attachments/26581760/Capital_required-AtRISK.xlsx?version=1&modificationDate=1506097505000&cacheVersion=1&api=v2) | [Poisson counts](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574980)
[Sum of random number of random variables](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575620)
Output statistics generation in spreadsheet
Calculation of risk budget | You are a consultant, hired by a US beer brewery that makes a special beer exclusively for the UK market. The brewery has a contract for selling 1,000,000 cases next year at a price of 10 pounds per case. You are asked how much capital the firm needs. The firm is exposed to two types of risk; exchange risk and liability claims, but the firm does not want to use any insurance or hedging. | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217)
[Normal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575246)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | [EXP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[LN](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[ROUND](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Cards](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575626)
[Cards download](/wiki/download/attachments/26581760/cards-AtRISK.xlsx?version=1&modificationDate=1506097506000&cacheVersion=1&api=v2) | [Hypergeometric sample](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574987)
[Numerical integration](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575285) | I have three full packs of cards, and I draw 10 cards from each pack. What is the probability that I draw at least 10 hearts in total? | [Hypergeometric](https://modelassist.epixanalytics.com/wiki/spaces/EA/pages/26575208) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [CLT flip ](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575620)
[CLT flip download](/wiki/download/attachments/26581760/CLT_flip-AtRISK.xlsx?version=1&modificationDate=1506097506000&cacheVersion=1&api=v2) | [Sum of random number of random variables](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575620)
[Numerical integration](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575285)
[Central Limit Theorem](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574953) | You run a special forces division of your country's army. You need to recruit another 16 personnel. The selection process is very tough, and only 34% of people who have ever started the training have completed it. The selection process is also very expensive. It costs $10600 to start a person on the program and $3200 thereafter for each week of training. The training course lasts 13 weeks. A person who fails has equal probability of doing so at any point during the course. You have a budget of $2,200,000. What is the probability that this will be sufficient for your recruitment needs? | [NegBinomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575213)
[Normal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575246)
[Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575256) | [AVERAGE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SQRT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [CLT risk portfolio approximation](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575603)
[CLT risk portfolio approximation download](/wiki/download/attachments/26581760/CLT_risk_portfolio_approximation-AtRISK.xlsx?version=1&modificationDate=1506097506000&cacheVersion=1&api=v2) | [Central Limit Theorem](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574953) | | [Bernoulli](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575202)
[Normal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575246)
[PERT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575251) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Clumps of cysts](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575620)
[Clumps of cysts download](/wiki/download/attachments/26581760/Clumps_of_cysts-AtRISK.xlsx?version=1&modificationDate=1506097506000&cacheVersion=1&api=v2) | Disaggregated
[Poisson process](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574979) | Clumps of cysts appear in water from a particular lake at a rate of 2.3 cysts per 1000m3. The number of cysts in a clump appears to take the distribution from empirical data shown in the table below. A filtration system is used that is able to capture these cyst clumps with varying efficiency depending on the clump size as shown in the third column of the table below. If a town draws its drinking water from this lake, uses the filtration system, and consumes 7600 m3 of water per year, how many cysts will be consumed? A cyst has a 25% probability of causing illness, how many people will get ill next year? | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Coins ](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575626)
[Coins download](/wiki/download/attachments/26581760/coins-AtRISK.xlsx?version=1&modificationDate=1506097506000&cacheVersion=1&api=v2) | Exercise in building a dynamic array | What is the distribution of the maximum number of heads I can get in a row by tossing a fair coin 10 times? | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[MAX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Combining opinions](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575439)
[Combining opinions download](/wiki/download/attachments/26581760/Combining_opinions-AtRISK.xlsx?version=1&modificationDate=1506097506000&cacheVersion=1&api=v2) | [Combining divergent expert estimates of the same quantity](https://modelassist.epixanalytics.com/space/EA/26575439/Incorporating+differences+in+expert+opinions) | Three weather experts are estimating what the wind speed (in Beaufort) will be tomorrow. Each of them gives her own opinion on what values the parameter can take. Expert A thinks the speed will be minimal 3, most likely 4 and maximal 6. Expert C thinks it will be respectively 3, 7 and 10. Finally, expert B thinks it will be between 3 and 9, with a distribution that looks like the one on sheet "Expert B". We weight expert B's opinion twice as heavy as the opinion of A or C. Now, we are to combine their opinions into one estimate. | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217)
[Discrete](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575205)
[PERT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575251) | |
| [Computers in the basement](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575627)
[Computers in the basement download](/wiki/download/attachments/26581760/Computers_in_the_basement-AtRISK.xlsx?version=1&modificationDate=1506097506000&cacheVersion=1&api=v2) | Exercise in building a dynamic array | You need a replacement PC. The IT manager says there are 22 PCs stored in the basement, but 3 have bad hard disks only, two have bad motherboards only, and one has both a bad hard disk and motherboard. Of course, nobody can remember which ones. For reasons he alone understands, you can only take out one PC at a time, coming to him to ask for the key, and then returning it afterwards. Presuming you can dismantle PCs and rebuild them, how many trips will you have to make to the basement to get a working PC? | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204) | [AND](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[OR](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Contagious extreme value distribution](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575630)
[Contagious extreme value distribution download](/wiki/download/attachments/26581760/Contagious_extreme_value_distribution-AtRISK.xlsx?version=1&modificationDate=1506097506000&cacheVersion=1&api=v2) | Contagious extreme value model and comparison with simulation | Model the extreme value distribution for the maximum explosion size, given the frequency of explosions and explosion intensity. | [Exponential](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575227)
[Extremevalue](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575228)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[LN](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[MAX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [COPPER](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575627)
[COPPER download](/wiki/download/attachments/26581760/COPPER-AtRISK.xlsx?version=1&modificationDate=1506097507000&cacheVersion=1&api=v2) | [Number of errors to achieve a success](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574981)
Sum of resources expended to achieve success | A manufacture is trying to extrude a length of copper wire of 5 kilometres, and there is a certain failure rate which is described by .07 failures per kilometre. And if the failure occurs before we produced our 5 km. of wire, then we have to re-start again. Because for some reason we can't attach two pieces of wire together, we just need 5 km. of absolutely perfect wire. So we are trying to estimate the distribution for the total amount of wire we produce in kilometres in order to get our 5 kilometres of perfect wire and the distribution for the number of times we need to re-start the production. | [Exponential](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575227) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [CopulaPatterns](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26586569)
[CopulaPatterns download](https://epixanalytics.atlassian.net/wiki/download/attachments/26586569/CopulaPatterns.xlsx?version=1&modificationDate=1561135032000&cacheVersion=1&api=v2) | Using different copulas to model relationships between datasets | | | RiskNormal
RiskCopula |
| [Correlated risk portfolio](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575459)
[Correlated risk portfolio download](/wiki/download/attachments/26581760/Correlated_risk_portfolio-AtRISK.xlsx?version=1&modificationDate=1506097507000&cacheVersion=1&api=v2) | Modeling correlated risks | We have a portfolio of risks (A to J), each of which is described by a PERT distribution. The risks are correlated in the following way: a) If A or C occurs, D increases in size by 50%; b) If A or D occurs, E increases to 45% probability and c) If all of B, C, E, F occur, H increases in size by 320% and to 13% probability. Our task is to calculate the total risk of the portfolio. | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204)
[Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217) | [AND](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[OR](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Correlating interest and mortgage rates](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575457)
[Correlating interest and mortgage rates download](/wiki/download/attachments/26581760/correlating_interest_and_mortgage_rates-AtRISK.xlsx?version=1&modificationDate=1506097507000&cacheVersion=1&api=v2) | Modeling two correlated variables using the [envelope method](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575457) | | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217) | |
| [Correlated Time Series fitting and forecasting](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26586613)
[Correlated Time Series fitting and forecasting download](https://epixanalytics.atlassian.net/wiki/download/attachments/26586613/Time_series_fitting_and_forecasting_AtRisk.xlsx?version=2&modificationDate=1558462486000&cacheVersion=1&api=v2) | Fitting[ correlated](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575455) time series and forecasting both with the correlation | | | [RiskCorrmat](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26581732) |
| [Correlation using look-up tables](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575458)
[Correlation using look-up tables download](/wiki/download/attachments/26581760/Correlation_using_look-up_tables-AtRISK.xlsx?version=1&modificationDate=1506097507000&cacheVersion=1&api=v2) | [Modeling correlation using a lookup table](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575458) | | [Discrete](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575205)
[Triangular](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575255) | [HLOOKUP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Cost and schedule](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575599)
[Cost and schedule download](/wiki/download/attachments/26581760/Cost_and_schedule-AtRISK.xlsx?version=1&modificationDate=1506097507000&cacheVersion=1&api=v2) | Modeling project duration and cost from inter-related tasks | A new building is to be constructed by a consortium for a client. The project is divided into seven sections. The client wishes to see a risk analysis of the schedule and cost risks and how these relate to each other. | [Discrete](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575205)
[Triangular](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575255) | [TODAY](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[MAX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Cost model](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575598)
[Cost model download](/wiki/download/attachments/26581760/Cost_model-AtRISK.xlsx?version=1&modificationDate=1506097507000&cacheVersion=1&api=v2) | A very simple [project cost model](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575598) | We need to build a cost model for a new bridge. All cost items are grouped into 8 categories. Three of these categories include a probability of occurrence of a particular event that will result in additional cost. Find the distribution of the total cost for this project. | [Discrete](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575205)
[Triangular](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575255) | |
| [Covariance and correlation ](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575619)
[Covariance and correlation download](/wiki/download/attachments/26581760/Covariance_and_correlation-AtRISK.xlsx?version=1&modificationDate=1506097507000&cacheVersion=1&api=v2) | Calculates the approximate sum of correlated random variables using a [covariance matrix](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575619). | A demonstration of how covariance can be used to calculate the approximate sum of a number of number of correlated random variables, even when those variables are skewed. | [Correlation Matrix Tool](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575456)
[Lognormal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575244) | [COVAR](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[INDEX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SQRT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Cysts in water](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574985)
[Cysts in water download](/wiki/download/attachments/26581760/Cysts_in_water-AtRISK.xlsx?version=1&modificationDate=1506097508000&cacheVersion=1&api=v2) | [Sum of random number of random variables](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575620)
[Numerical integration](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575285) | Foci of cysts are randomly distributed in water with the average of 0.3 foci per litre. Each focus can contain from 1 to 5 cysts, with each value having the same probability of being true. Each cyst has a 20% probability of infecting a person. If I drink 12 litres of water, how many cysts will I consume? What is the probability of me getting infected from drinking 12 litres of water? | [Integer Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575209)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Dirichlet](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575636)
[Dirichlet download](/wiki/download/attachments/26581760/Dirichlet-AtRISK.xlsx?version=1&modificationDate=1506097508000&cacheVersion=1&api=v2) | [Generate a Dirichlet distribution](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575636) | All cars in a city are divided into 9 different types. We have monitored 100 cars that were entering a particular motorway, and counted the number of cars of each type. What are the uncertainty distributions for the proportions of each type in a total number of cars? | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217) | |
| [Dirichlet distribution](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575224)
[Dirichlet distribution download](/wiki/download/attachments/26581760/Dirichlet_distribution-AtRISK.xlsx?version=1&modificationDate=1506097508000&cacheVersion=1&api=v2) | [Two methods of Dirichlet distribution construction.](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575224) | | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217)
[Gamma](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575231) | |
| [Distance to Nearest Herd ](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575634)
[Distance to Nearest Herd download](/wiki/download/attachments/26581760/DistanceToNearestHerd-AtRISK.xlsx?version=1&modificationDate=1506097508000&cacheVersion=1&api=v2) | Two ways of determining the distance between an individual and its nearest, or next nearest, etc. neighbor. | It is known that the average density of herds in a region is 0.052/km2, but no information is available about the distribution of distance between these herds. We assume that the herds are randomly distributed, that their is no clustering in their position, and that the spread of a herd is very small compared to the distance between herds. What is the distribution of distance between a random herd and its nearest neighbor? | [Exponential](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575227)
[Gamma](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575231)
[Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575256) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[MIN](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[PI](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SQRT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Distribution of Particles](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575641)
[Distribution of Particles download](/wiki/download/attachments/26581760/DistributionOfParticles-AtRISK.xlsx?version=1&modificationDate=1506097508000&cacheVersion=1&api=v2) | Distributing particles randomly scattered through a medium when the medium is divided up. | You are bottling 375 litres of wine into 500 bottles. There are in total 216 bacteria in the vat of wine. The task is to model the amount of bacteria in each bottle. | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Election](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575646)
[Election download](/wiki/download/attachments/26581760/Election-AtRISK.xlsx?version=1&modificationDate=1506097508000&cacheVersion=1&api=v2) | Constructing a [Dirichlet distribution](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575224)
[Numerical integration](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575285) | We have surveyed 175 people, asking them for which party they are intending to vote. The results are as shown below. Using the Dirichlet distribution and assuming that people don't change their mind between the poll and election time, answer the questions:
- How confident are we that SMP will win (get more votes than any other party)?
- If the SDP joins forces with the EDP, and the SMP joins forces with the PSM, how confident are we that SDP/EDP will get more votes than SMP/PSM? | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217) | [MAX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Electricity Option](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26579328)
[Electricity Option download](/wiki/download/attachments/26581760/Electricity_option-AtRISK.xlsx?version=1&modificationDate=1506099712000&cacheVersion=1&api=v2) | | An electricity re-seller is thinking of selling an option to its customers. The buyer of this option will have the right to purchase electricity at any time within a period of 10 days at the spot rate with a cap of USD 120/KWh, thus saving money if the electricity price rises above that figure. In order to calculate the price of this option, the company needs to estimate how much the spot price could exceed the cap and how much electricity it would sell to the option-holder when the latter decides to exercise the option. | [Lognormal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575244) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Empirical distributions](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575275)
[Empirical distributions download](/wiki/download/attachments/26581760/Empirical_distributions-AtRISK.xlsx?version=1&modificationDate=1506097510000&cacheVersion=1&api=v2) | Three options to [construct an empirical distribution](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575275) | | [Cumulative](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575222)[ Ascending](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)
[Discrete Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575206)
[Integer Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575209)
[Histogram](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575234) | [CONCATENATE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[FREQUENCY](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[INDEX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[VLOOKUP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Error](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575226)
[Error download](/wiki/download/attachments/26581760/Error-AtRISK.xlsx?version=1&modificationDate=1506097510000&cacheVersion=1&api=v2) | Generating values from the [Error distribution](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575226) | | [General](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575232) | [ABS](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[EXP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[GAMMALN](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SQRT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Estimate mean and stdev for Normal distribution when neither known (topic link 1)](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575345)
[Estimate mean and stdev for Normal distribution when neither known (topic link 2)](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575347)
[Estimate mean and stdev for Normal distribution when neither known download](/wiki/download/attachments/26581760/Estimate_mean_and_stdev_for_Normal_distribution_when_neither_known-AtRISK.xlsx?version=1&modificationDate=1506097510000&cacheVersion=1&api=v2) | A [classical statistics](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575342) method of estimating the mean and the standard deviation for Normal distribution when neither are known. | | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204)
[Gamma](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575231)
[Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575256)
[Student-t](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575254) | [AVERAGE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[COUNT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SQRT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[STDEV](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Estimate mean for Normal distribution when stdev is known](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575344)
[Estimate mean for Normal distribution when stdev is known download](/wiki/download/attachments/26581760/Estimate_mean_for_Normal_distribution_when_stdev_is_known-AtRISK.xlsx?version=1&modificationDate=1506097510000&cacheVersion=1&api=v2) | A [classical statistics](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575342) method of estimating the mean for Normal distribution when the distributions standard deviation is known | | [Normal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575246) | [AVERAGE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[COUNT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SQRT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Estimate stdev for Normal distribution when mean is known](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575346)
[Estimate stdev for Normal distribution when mean is known download](/wiki/download/attachments/26581760/Estimate_stdev_for_Normal_distribution_when_mean_is_known-AtRISK.xlsx?version=1&modificationDate=1506097510000&cacheVersion=1&api=v2) | A [classical statistics](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575342) method of estimating the standard deviation of a Normal distribution when the distributions mean is known. | | [Gamma](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575231) | [COUNT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SQRT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SUMPRODUCT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Exchange rate ](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575606)
[Exchange rate download](/wiki/download/attachments/26581760/Exchange_rate-AtRISK.xlsx?version=1&modificationDate=1506097510000&cacheVersion=1&api=v2) | Projected random time series with dominant shock component | Model exchange rate for 300 periods according to the formula: Xi+1=Normal(Xi,sigma*Xi). There is an election at period 100, with 3 possible outcomes (see the table below). The volatility of the exchange rate changes depending on the party that gets into power. If Conservatives get in, there's a 50:50 chance that sigma increases to 0.1 somewhere between period 180 and 200. | [D](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[iscrete](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575205)
[Normal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575246)
[Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575256) | [AND](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[ROUND](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[VLOOKUP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Finally retired](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575615)
[Finally retired download](/wiki/download/attachments/26581760/Finally_retired-AtRISK.xlsx?version=1&modificationDate=1506097511000&cacheVersion=1&api=v2) | Calculate the total worth of a retirement fund upon retirement. | You are trying to calculate the total worth of your retirement fund upon your retirement. You are 32-years-old now and the retirement age in your country is 60, but there is a 75% chance that it will be changed to 65 years. You contribute 5% of your salary to the retirement fund each year. Your annual salary this year is 20,000, and you expect it to rise with Lognormal(3%,1%) per year in real terms (above inflation). You estimate that the return on the pension fund will be minimum 3%, most likely 4% and maximum 7% (assuming a Pert distribution). | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204)
[Lognormal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575244)
[Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[MAX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Financial formats](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575515)
[Financial formats download](/wiki/download/attachments/26581760/Financial_formats-AtRISK.xlsx?version=1&modificationDate=1506097511000&cacheVersion=1&api=v2) | Offers a number of formats you can use so that a cell with the value 105,000, for example, will appear on-screen as 105k. You need only copy and paste cells from this file into your spreadsheet, or use Excels Format Painter tool to transfer the formats | | | |
| [Fitting ExtValue](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575630)
[Fitting ExtValue download](/wiki/download/attachments/26581760/Fitting_ExtValue-AtRISK.xlsx?version=1&modificationDate=1506097511000&cacheVersion=1&api=v2) | Fit an [Extreme Value minimum distribution](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575630) to data | | [Extremevalue](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575228) | |
| [Fixed and Risked model](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575528)
[Fixed and Risked model download](/wiki/download/attachments/26581760/Fixed_and_Risked_Model-AtRISK.xlsx?version=1&modificationDate=1506097511000&cacheVersion=1&api=v2) | A simple model to illustrate how to add uncertainty to the values of the components in the model by replacing a fixed value by a probability distribution describing our uncertainty. | | [Lognorm](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575244)[al](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)
[Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217) | |
| [Floods](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575650)
[Floods download](/wiki/download/attachments/26581760/Floods-AtRISK.xlsx?version=1&modificationDate=1506097511000&cacheVersion=1&api=v2) | | A vast area of land in country A is below the average sea level. Dikes are built along the sea coast in order to protect the country from floods. Extreme wave-height and still water level are two very important factors for causing flooding along the sea coast. The scientists concerned with the safety of the land-space found out that a catastrophe can occur if the wave-height and still water level satisfy the following relation:
Catastrophe factor = 0.4 * wave-height [m.] + sea level [m.] > 6.2.
Taking into account the country’s geography, the area of flooded land-space can be calculated using the following formula:
LogNormal(1.38*Catastrophe factor^2, 3.52*Catastrophe factor^(1/4)) [100 sq. km.].
Giving that storms occur at a Poisson expected rate of 25 per year, what is the probability that within 5 years there will be a flood that will cover more that 7,000 sq. km? | [Lognormal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575244)
[Normal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575246) | [EXP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[LOGNORMDIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Frechet](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575630)
[Frechet download](/wiki/download/attachments/26581760/Frechet-AtRISK.xlsx?version=1&modificationDate=1506097511000&cacheVersion=1&api=v2) | Generating a [Frechet distribution](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575228) | | [Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575256) | [LN](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Function to integrate - 1](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575631)
[Function to integrate - 1 download](/wiki/download/attachments/26581760/function_to_integrate_-_1-AtRISK.xlsx?version=1&modificationDate=1506097511000&cacheVersion=1&api=v2) | [Numerical integration](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575285) | Perform the following integral:
 | [Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575256) | [EXP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SIN](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Function to integrate - 2](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575631)
[Function to integrate - 2 download](/wiki/download/attachments/26581760/function_to_integrate_-_2-AtRISK.xlsx?version=1&modificationDate=1506097511000&cacheVersion=1&api=v2) | [Numerical integration](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575285) | Perform the following integral:
 | [Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575256) | [ABS](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[LN](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SIN](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Function to integrate - 3](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575631)
[Function to integrate - 3 download](/wiki/download/attachments/26581760/function_to_integrate_-_3-AtRISK.xlsx?version=1&modificationDate=1506097512000&cacheVersion=1&api=v2) | [Numerical integration](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575285) | Perform the following integral:
 | [Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575256) | [EXP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SIN](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Gender ](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575397)
[Gender download](/wiki/download/attachments/26581760/gender-AtRISK.xlsx?version=1&modificationDate=1506097512000&cacheVersion=1&api=v2) | [Bayesian inference](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575368)
[Informed prior](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575376)
[Hypergeometric sampling](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574987) | 20 people are randomly picked off a city street in France. Whether they are male or female is noted on 20 identical pieces of paper, put into a hat and the hat is brought to me. I have not seen these 20 people. I take out five pieces of paper from the hat and read them - three are female. I am then asked to estimate the number of females in the original group of twenty. | | [BINOMDIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[HYPGEOMDIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[OR](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Healtheffect](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575627)
[Healtheffect download](/wiki/download/attachments/26581760/Healtheffect-AtRISK.xlsx?version=1&modificationDate=1506097512000&cacheVersion=1&api=v2) | Number of samples required in a random sampling of a population to obtain a particular minimum set.
[Normal approximation to the NegBin](https://modelassist.epixanalytics.com/space/EA/26575261/Approximations+to+the+Negative+Binomial+distribution) | You are a government body doing research into the effects of marriage and smoking on peoples health. You are doing a random telephone survey and you require 50 people from each of the four possible categories. From previous studies you know that 32% of people agree to participate in this type of survey when called. How many calls will you need to make, given that previous studies show the population to be split into the four categories. | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204)
[NegBinomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575213) | [AND](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Hospital](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575600)
[Hospital download](/wiki/download/attachments/26581760/hospital-AtRISK.xlsx?version=1&modificationDate=1506097512000&cacheVersion=1&api=v2) | Simple project duration model | In order to build a hospital, a construction firm needs to finish several stages of different duration. What is the total duration of the project? | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217)
[PERT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575251) | |
| [HyperGeoTrials ](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575627)
[HyperGeoTrials download](/wiki/download/attachments/26581760/HyperGeoTrials-AtRISK.xlsx?version=1&modificationDate=1506097512000&cacheVersion=1&api=v2) | Constructing an [Inverse Hypergeometric distribution](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575210) and generating values | | [Discrete](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575205) | [COMBIN](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Indepprob](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575626)
[Indepprob download](/wiki/download/attachments/26581760/indepprob-AtRISK.xlsx?version=1&modificationDate=1506097512000&cacheVersion=1&api=v2) | Illustrating an incorrect way to use the Beta distribution to model variability in a Binomial probability | The probability of a trials success is a random variable and each trials probability is independent of the others. Model the probability for each trial separately as a random variable and calculate the total number of successes. | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217)
[Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204) | |
| [Integrated Risk Management](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575611)
[Integrated Risk Management download](/wiki/download/attachments/26581760/Integrated_Risk_Management-AtRISK.xlsx?version=1&modificationDate=1506097512000&cacheVersion=1&api=v2) | [Sum of random number of random variables](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575620)
[Numerical integration](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575285)
Insurance
Hedging | Your company is exposed to two types of risk, market risk through price and volume fluctuations and risk of fire. Currently, the company does have insurance and you are asked to evaluate if this is the best way going forward. | [Lognormal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575244)
[Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[TREND](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [InvGaussian](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575236)
[InvGaussian download](/wiki/download/attachments/26581760/InvGaussian-AtRISK.xlsx?version=1&modificationDate=1506097512000&cacheVersion=1&api=v2) | [Inverse Gaussian](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575236) | | [I](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[nvGaussian](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575236) | |
| [Jacknife](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575404)
[Jacknife download](/wiki/download/attachments/26581760/Jacknife-AtRISK.xlsx?version=1&modificationDate=1506097513000&cacheVersion=1&api=v2) | [Jacknife analysis](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575404) | | [D](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[iscrete Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575206) | [AVERAGE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[COUNT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SQRT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[STDEV](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[Array formulae](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Laplace](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575240)
[Laplace download](/wiki/download/attachments/26581760/Laplace-AtRISK.xlsx?version=1&modificationDate=1506097513000&cacheVersion=1&api=v2) | Constructs a [Laplace distribution](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575240) | | [Exponential](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575227) | [SQRT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Lawyers](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574977)
[Lawyers download](/wiki/download/attachments/26581760/Lawyers-AtRISK.xlsx?version=1&modificationDate=1506097515000&cacheVersion=1&api=v2) | Comparing uncertain quantities
[Binomial estimation of p](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574975)
[Numerical integration](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575285) | A performance measure for lawyers is the percentage of cases he or she has won. Let's say a person is looking for a lawyer to defend his case and would like to choose the one with the highest performance. There are three lawyers in the area who are knowledgeable in the field and their past performances are known. Assuming that each lawyer's cases were random samples from the same population of cases (so we can assume a Binomial process) since all three lawyers work in the same field, whom should the person choose as his lawyer? | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217) | [BETADIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Leading indicator ](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575449)
[Leading indicator download](/wiki/download/attachments/26581760/Leading_indicator-AtRISK.xlsx?version=1&modificationDate=1506097515000&cacheVersion=1&api=v2) | Model a time series based on a relationship with a [leading indicator variable](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575449) | | [Normal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575246) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[INTERCEPT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[ISNA](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[NA](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[RSQ](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SLOPE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[FALSE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Lifetime of a device](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575643)
[Lifetime of a device download](/wiki/download/attachments/26581760/Lifetime_of_a_device-AtRISK.xlsx?version=1&modificationDate=1506097516000&cacheVersion=1&api=v2) | Reliability of a set of components | A piece of electronic equipment is composed of six components A to F. The mean times between failures for each of the components are given below. The components are in serial and parallel configuration as shown on the chart. What is the probability that the machine will fail within 250 hours? | [Exponential](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575227) | [MAX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[MIN](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Logarithmic](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575211)
[Logarithmic download](/wiki/download/attachments/26581760/Logarithmic-AtRISK.xlsx?version=1&modificationDate=1506097516000&cacheVersion=1&api=v2) | Constructs a [Logarithmic distribution](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575211) | | [D](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[iscrete](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575205) | [LN](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Lognormal random walk](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575612)
[Lognormal random walk download](/wiki/download/attachments/26581760/Lognormal_random_walk-AtRISK.xlsx?version=1&modificationDate=1506097516000&cacheVersion=1&api=v2) | Model a [lognormal random walk](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575612) | | [Lognormal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575244) | |
| [Market growth model](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575607)
[Market growth model download](/wiki/download/attachments/26581760/Market_growth_model-AtRISK.xlsx?version=1&modificationDate=1506097516000&cacheVersion=1&api=v2) | Exercise to allow you to try out various modeling techniques | You are asked to determine an NPV for 10 years of cashflow (with no residual value, e.g. lease end), discounted at 8.5% on revenue converted back to sterling, for a new store in Times Square, New York to be opened in 2005 | [D](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[iscrete Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575206)
[Normal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575246)
[Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217) | [EXP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[TODAY](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[TREND](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[YEAR](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Market Size Estimation ](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575384)
[Market Size Estimation download](/wiki/download/attachments/26581760/Market_Size_Estimation-AtRISK.xlsx?version=1&modificationDate=1506097516000&cacheVersion=1&api=v2) | | You are an R&D company, that is planning to commercialize a new technology for oil refineries to help them meet a new EPA NOx emission requirements that will come into effect 1 year from now. However, you only want to develop this technology further if there are at least 55 refineries in the US that could benefit from your technology. Recently, a competing technology was brought in the market (technology X) that also helps refineries meet these emissions and quite a few refineries are already using this technology (before start of EPA requirements), but it is a lot more expensive. You are convinced that a refinery that used technology X is as likely to buy your new technology (if you develop it) as a refinery that doesn't use any technology yet. The total market size for your new technology (Y) is therefore any refinery that currently doesn't meet EPA requirements plus any refinery that used technology X. What is the probability that this total market is more than 55 refineries? | [Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575256) | [AND](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Markov Chain Model](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26586629)
[Markov Chain Model download](https://epixanalytics.atlassian.net/wiki/download/attachments/26586629/MarkovChainModel_AtRisk.xlsx?version=1&modificationDate=1558478653000&cacheVersion=1&api=v2) | Models the ratings and defaults of the portfolio over time with a Markov Chain model | | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204) | [TRANSPOSE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[Array Functions](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IFERROR](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[RiskBinomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26581732)
[RiskPercentile](https://modelassist.epixanalytics.com/wiki/spaces/EA/pages/26581732)
[RiskMean](https://modelassist.epixanalytics.com/wiki/spaces/EA/pages/26581732)
[RiskTruncate](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26581732) |
| [Mean accuracy](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575299)
[Mean accuracy download](/wiki/download/attachments/26581760/Mean_accuracy-AtRISK.xlsx?version=1&modificationDate=1506097516000&cacheVersion=1&api=v2) | Checks whether sufficient iterations have been run for a [desired level of model output accuracy](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575299) | How many iterations are needed to be confident that the true mean is within Y of my models output mean. | | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[NORMSDIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Mean reversion](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575450)
[Mean reversion download](/wiki/download/attachments/26581760/Mean_reversion-AtRISK.xlsx?version=1&modificationDate=1506097516000&cacheVersion=1&api=v2) | analyze historic data for a [random time series exhibiting mean reversion](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575450) and then produce a forecast | | [Normal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575246)
[D](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[iscrete Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575206) | [EXP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[INTERCEPT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SLOPE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[FALSE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[Array formulae](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [MTTF ](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575401)
[MTTF download](/wiki/download/attachments/26581760/MTTF-AtRISK.xlsx?version=1&modificationDate=1506097517000&cacheVersion=1&api=v2) | [Bayesian inference](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575368), estimating MTTF
[Constructing posterior distribution for simulation](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575401) | 10 components of the same type are run for 3000 hours and 4 fail within that time. Assuming that the components have a constant instantaneous failure rate, what is the MTTF? | [G](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[eneral](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575232) | [BINOMDIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[EXPONDIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Multinomial (topic link 1)](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575633)
[Multinomial (topic link 2)](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575212)
[Multinomial (topic link 3)](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575636)
[Multinomial download](/wiki/download/attachments/26581760/Multinomial-AtRISK.xlsx?version=1&modificationDate=1506097517000&cacheVersion=1&api=v2) | Construct a [Multinomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575212) distribution | All cars in a city are divided into 9 different types. We know the proportion of each type in a total number of cars. If we were to monitor 1000 cars that enter a particular motorway, how many cars of each type would we see? | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Multivariate hypergeometric (topic link 1)](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575636)
[Multivariate hypergeometric (topic link 2)](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575960)
[Multivariate hypergeometric download](/wiki/download/attachments/26581760/Multivariate_hypergeometric-AtRISK.xlsx?version=1&modificationDate=1506097517000&cacheVersion=1&api=v2) | Construct a [Multivariate Hypergeometric](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575960) distribution | There are 100 colored balls in a bag, from which 10 are red, 15 white, 20 blue, 25 green and 30 yellow. Without looking into the bag, you take 30 balls out. How many balls of each color will you take from the bag? | [Hypergeometric](https://modelassist.epixanalytics.com/wiki/spaces/EA/pages/26575208) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [New product sales](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26577360)
[New product sales download](/wiki/download/attachments/26581760/New_product_sales-AtRISK.xlsx?version=1&modificationDate=1506097517000&cacheVersion=1&api=v2) | | Model sales of a new product that will either do very well, poorly or something in between. | [Lognormal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575244)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214)
[Triangular](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575255) | [BETADIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Non Parametric Bootstrap Model](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575409)
[Non Parametric Bootstrap Model download](/wiki/download/attachments/26581760/Non_Parametric_Bootstrap_Model-AtRISK.xlsx?version=1&modificationDate=1506097517000&cacheVersion=1&api=v2) | [Non-parametric Bootstrap](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575409) technique to calculate the statistics of interest | | [Discrete Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575206) | [AVERAGE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[PERCENTILE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[STDEV](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Non-parametric Bootstrap between two means ](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575414)
[Non-parametric Bootstrap between two means download](/wiki/download/attachments/26581760/Non-parametric_Bootstrap_between_two_means-AtRISK.xlsx?version=1&modificationDate=1506097518000&cacheVersion=1&api=v2) | [Non-parametric Bootstrap](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575405) estimate of difference in means between two populations | | [Discrete Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575206) | [AVERAGE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Non-parametric Bootstrap of mean treatment effect](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575414)
[Non-parametric Bootstrap of mean treatment effect download](/wiki/download/attachments/26581760/Non-parametric_Bootstrap_mean_treatment_effect-AtRISK.xlsx?version=1&modificationDate=1568399204000&cacheVersion=1&api=v2) | [Non-parametric Bootstrap](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575405) estimate of the effect of a treatment within same subject | Basic model to show how the non-parametric Bootstrap can be used to model treatment effect. Note that this could also be modeled with a classical parametric construction Normal(mb-ma, sqrt(Vb+Va)), but would assume the treatment effect is indeed Normally distributed | [Discrete Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575206) or [RiskResample](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26581732) | [AVERAGE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Non-parametric Bootstrap of mean treatment effect](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575416)
[Non-parametric regression Bootstrap download](/wiki/download/attachments/26581760/Non-parametric_regression_Bootstrap-AtRISK.xlsx?version=1&modificationDate=1506097518000&cacheVersion=1&api=v2) | [Non-parametric Bootstrap regression](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575416) | Estimate regression parameters without assuming normally distributed residuals | [Discrete Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575206) | [COUNT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[FORECAST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[INTERCEPT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SLOPE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SQRT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[TREND](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [NonParaCont1](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575313)
[NonParaCont1 download](/wiki/download/attachments/26581760/NonParaCont1-AtRISK.xlsx?version=1&modificationDate=1506097517000&cacheVersion=1&api=v2) | Fit a [continuous non-parametric 1st order distribution](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575313) to small and large data sets | | [Cumulative Ascending](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575222) | [COUNT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[MAX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[MIN](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[PERCENTILE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [NonParaCont2](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575314)
[NonParaCont2 download](/wiki/download/attachments/26581760/NonParaCont2-AtRISK.xlsx?version=1&modificationDate=1506097517000&cacheVersion=1&api=v2) | Fit a [continuous non-parametric 2nd order distribution](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575314) to small and large data sets | | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217)
[Cumulative Ascending](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575222)
[PERT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575251)
[Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575256) | [COUNT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [NPV of a capital investment (topic link 1)](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575608)
[NPV of a capital investment (topic link 2)](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575609)
[NPV of a capital investment download](/wiki/download/attachments/26581760/NPV_of_a_capital_investment-AtRISK.xlsx?version=1&modificationDate=1506097518000&cacheVersion=1&api=v2) | Exercise to allow you to try out various modeling techniques | You are evaluating a new company making fuel cells for hospital power plants. There are various uncertainties influencing the cashflows. Calculate the NPV of a project. | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204)
[D](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[iscrete Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575206)
[General](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575232)
[PERT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575251)
[Triangular](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575255) | [AND](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [NPV with Timing Risk](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26586601)
[NPV with Timing Risk download](https://epixanalytics.atlassian.net/wiki/download/attachments/26586601/NPV_WithTimingRisk_AtRisk.xlsx?version=1&modificationDate=1557871161000&cacheVersion=1&api=v2) | [Valuation model](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575608) with three sheets which show how multiple risks are accounted for, including launch timing risk. | A product launch opportunity is being evaluated with and without uncertainty about the assumptions, and with risk of launch delay using the [envelope method](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575457) to correlated variables. The NPV of the business opportunity is calculated for each model. | [PERT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575251) | [NPV](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[MAX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[MIN](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SUMIF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[RiskMean](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26581732)
[RiskTarget](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26581732)
[RiskPercentile](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26581732) |
| [Offshore Oil Platform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575650)
[Offshore Oil Platform download](/wiki/download/attachments/26581760/Offshore_Oil_Platform-AtRISK.xlsx?version=1&modificationDate=1506097518000&cacheVersion=1&api=v2) | [MaxExtreme distribution](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575228) | During the construction of an offshore oil platform, we need to evaluate the yearly probability that the oil platform fails. The platform has 6 beams with individual strength distributions that can be described by a Weibull (0, 36.5, 20). The maximum yearly stresses on the platform (e.g. wind) can be described by a MaxExtreme (7.5, 5) and are highly correlated as they share the same environment. If 2 or more beams break, the oil-platform fails. What is the yearly probability that the platform fails? | [Weibull](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575257) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [One lightbulb](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575628)
[One lightbulb download](/wiki/download/attachments/26581760/One_lightbulb-AtRISK.xlsx?version=1&modificationDate=1506097518000&cacheVersion=1&api=v2) | [Renewal process](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574992)
[Number of random variable to reach a defined sum](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575621) | It is known that a certain type of light bulb has a lifetime that is Weibull (1.3,4020) hours distributed. If I have one light bulb working at all times, replacing each failed light bulb immediately with another, how many light bulbs will have failed in 10 000 hours? | [Weibull](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575257) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Parametric Bootstrap Model](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575410)
[Parametric Bootstrap Model download](/wiki/download/attachments/26581760/Parametric_Bootstrap_Model-AtRISK.xlsx?version=1&modificationDate=1506097518000&cacheVersion=1&api=v2) | [Parametric Bootstrap](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575406) | Calculate the statistics of interest for a Lognormal distribution fitted to a data set | [Lognormal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575244) | [AVERAGE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[PERCENTILE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[STDEV](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Paratetramol](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575310)
[Paratetramol download](/wiki/download/attachments/26581760/Paratetramol-AtRISK.xlsx?version=1&modificationDate=1506097518000&cacheVersion=1&api=v2) | | You have data on the amount of Paratetramol that people have taken. The Paratetramol will have come in pills of specific doses (e.g. 25mg), so the observations will take 25mg steps. How to fit a Negative Binomial distribution to this data? | [NegBinomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575213) | |
| [Particles in a volume ](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575641)
[Particles in a volume download](/wiki/download/attachments/26581760/Particles_in_a_volume-AtRISK.xlsx?version=1&modificationDate=1506097518000&cacheVersion=1&api=v2) | Allocating particles in suspension to sub-divisions of equal, and unequal sizes | A number of particles N is distributed in some relatively large liquid volume V. This volume is divided into n volumes. What is the joint probability distribution of the number of particles in each division? | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Pats ](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575400)
[Pats download](/wiki/download/attachments/26581760/Pats-AtRISK.xlsx?version=1&modificationDate=1506097519000&cacheVersion=1&api=v2) | [Bayesian inference through accept/reject simulation](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575384)
Several interlinked stochastic processes | A herd of 25 cows is suspected of having disease X. You are going to look for this disease by taking samples from the cow pats they produce and test for antibodies to X. On average, this breed of cow produces 12 pats per day per cow. 10 fresh pats (i.e. produced that day) are tested. 2 test positive for contamination.
The test used is not perfect. If the cow pat contains antibodies to X there is a 90% probability (bases on a previous study with 18/20 success rate) that the test will come up positive. On the other hand, if the cow pat has no antibodies to X, here is still a 5% chance (based on a previous study with a 1/20 failure rate) that the test will be positive. How many of the cows are infected? | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217)
[Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204)
[Hypergeometric](https://modelassist.epixanalytics.com/wiki/spaces/EA/pages/26575208)
[Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575256)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Pearson V](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575249)
[Pearson V download](/wiki/download/attachments/26581760/Pearson_V-AtRISK.xlsx?version=1&modificationDate=1506097519000&cacheVersion=1&api=v2) | | | [Gamma](https://modelassist.epixanalytics.com/space/EA/26575231/Gamma)
[P](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[earson5](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575249) | |
| [Pearson VI](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575250)
[Pearson VI download](/wiki/download/attachments/26581760/Pearson_VI-AtRISK.xlsx?version=1&modificationDate=1506097519000&cacheVersion=1&api=v2) | | | [Beta](https://modelassist.epixanalytics.com/space/EA/26575217/Beta)
[P](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[earson6](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575250) | |
| [People in a lift](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575621)
[People in a lift download](/wiki/download/attachments/26581760/people_in_a_lift-AtRISK.xlsx?version=1&modificationDate=1506097519000&cacheVersion=1&api=v2) | Calculating (rather than simulating) the probability that a sum of random variables exceeds some target | The elevator is able to lift 500 kg, and if this limit is exceeded, it breaks down. The task is to calculate the optimal number of people allowed to enter the elevator at a time so that the risk of breaking the lift is acceptable. | | [NORMDIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SQRT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Performing Monte Carlo Simulations in @Risk](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575290)
[Performing Monte Carlo Simulations in @Risk download](/wiki/download/attachments/26581760/Performing_Monte_Carlo_Simulations_in_AtRisk-AtRISK.xlsx?version=1&modificationDate=1506103783000&cacheVersion=1&api=v2) | Illustrates the steps to perform [Monte Carlo Simulations](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575290) in @Risk. | | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217)
[PERT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575251) | |
| [Percentile accuracy](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575300)
[Percentile accuracy download](/wiki/download/attachments/26581760/Percentile_accuracy-AtRISK.xlsx?version=1&modificationDate=1506097519000&cacheVersion=1&api=v2) | Continuously calculates the number of iterations needed to achieve the [desired level of accuracy for an output percentile](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575300) | How many iterations are needed to be confident that the true X percentile is within Y of my models output percentile. | | [NORMSDIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[ROUNDUP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Plane crashes1](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575620)
[Plane crashes1 download](/wiki/download/attachments/26581760/plane_crashes1-AtRISK.xlsx?version=1&modificationDate=1506097520000&cacheVersion=1&api=v2) | [Sum of random number of random variables](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575620)
[Poisson process](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574979) | A company insures airplanes. They crash at a rate of 0.23 crashes per month. Each crash costs $Lognormal(120,52) million. What is the distribution of cost to the company for the next five years? | [Lognormal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575244)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | [VLOOKUP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Plane crashes2](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575620)
[Plane crashes2 download](/wiki/download/attachments/26581760/plane_crashes2-AtRISK.xlsx?version=1&modificationDate=1506097520000&cacheVersion=1&api=v2) | Poisson process with time log
[Sum of random number of random variables](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575620) | A company insures airplanes. They crash at a rate of 0.23 crashes per month. Each crash costs $Lognormal(120,52) million. What is the distribution of the value of the liability if discount it at the risk free rate of 5%? | [Exponential](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575227)
[Lognormal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575244) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Poisson confidence construction](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575362)
[Poisson confidence construction download](/wiki/download/attachments/26581760/Poisson_confidence_construction-AtRISK.xlsx?version=1&modificationDate=1506097520000&cacheVersion=1&api=v2) | Construct a [classical statistics](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575342) confidence distribution for the [Poisson parameter](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574982) | | [Cumulative Ascending](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575222) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[POISSON](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Poisson random walk](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575445)
[Poisson random walk download](/wiki/download/attachments/26581760/Poisson_random_walk-AtRISK.xlsx?version=1&modificationDate=1506097520000&cacheVersion=1&api=v2) | Poisson random walk with trend | A model that can be used, for example, to describe vehicle accident claims made to an insurance company, or cases of a disease for a health authority as the number of cars increases, the number of car crashes increases correspondingly according to some function; as the pollution level in a city increases, the number of people with respiratory disease increases | [Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | |
| [Poisson series](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575447)
[Poisson series download](/wiki/download/attachments/26581760/Poisson_series-AtRISK.xlsx?version=1&modificationDate=1506097520000&cacheVersion=1&api=v2) | Poisson random walk with trend and seasonality | An insurance company needs to model the number of car crashes in the country over the next 52 weeks period. The projection should include two factors: a) 10% annual upward trend due to the increase in the total number of cars in the country and b) seasonality factor - higher probability of a car crash during a winter season. | [Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | |
| [Power station pumps](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575644)
[Power station pumps download](/wiki/download/attachments/26581760/Power_station_pumps-AtRISK.xlsx?version=1&modificationDate=1506097521000&cacheVersion=1&api=v2) | Modeling continuous random process | 4 pumps, A to D, serve a power station. In order to work, the station needs 2 working pumps. Each pump has a probability of failure in a day, which depends on number of pumps working. Each repair of the pump takes LN(20,15) days. How long will it take before a shutdown (before 3 of 4 pumps break down)? How many shutdowns will the station have per year? What is the probability of one or more shutdowns per year? | [Exponential](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575227)
[Lognormal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575244) | [AND](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[HLOOKUP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[LN](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[OR](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Power units](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26577894)
[Power units download](/wiki/download/attachments/26581760/Power_units-AtRISK.xlsx?version=1&modificationDate=1506097521000&cacheVersion=1&api=v2) | [Numerical integration](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575285)
[Multiple scenarios](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26577894) | Your company produces specialist power units. We deliver these units to the client in batches of ten. The client has a quality control procedure for each consignment, as follows: Three units are tested. If two or more of these samples are defective, the consignment is rejected. If one is defective, another three are tested, and if any of these second set are defective the consignment is also rejected. We want to construct a model that looks at the risk of rejection of a consignment for different numbers of defective power units. | [Hypergeometric](https://modelassist.epixanalytics.com/wiki/spaces/EA/pages/26575208) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[MAX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Prevalence estimate for imperfect test](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575629)
[Prevalence estimate for imperfect test download](/wiki/download/attachments/26581760/Prevalence_estimate_for_imperfect_test-AtRISK.xlsx?version=1&modificationDate=1506097521000&cacheVersion=1&api=v2) | [Bayesian inference](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575368)
Prevalence estimate with imperfect test | We are doing a random survey of people in some region to determine the prevalence of infection with a particular micro-organism. The test consists of randomly selecting a person, drawing a sample of their blood and looking for antibodies. The test is imperfect, however, as there remains a possibility that antibodies may not be detected in the blood of an infected person, and that antibodies may be misidentified in samples from non-infected people. Knowing Se - the probability that an infected person will test positive and Sp - the probability that a non-infected person will test negative, estimate true population prevalence. | [G](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[eneral](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575232) | [BINOMDIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Probability of ruin](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575526)
[Probability of ruin download](/wiki/download/attachments/26581760/Probability_of_ruin-AtRISK.xlsx?version=1&modificationDate=1506097521000&cacheVersion=1&api=v2) | Estimating combined risk from several risk events
Probability of exceeding some threshold
[Numerical integration](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575285) | Risks A to J are ranked in descending order of expected cost. If a loss of $500,000 or more would ruin your company, how would you calculate the probability of ruin? | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204) | |
| [Projected cures](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575448)
[Projected cures download](/wiki/download/attachments/26581760/Projected_cures-AtRISK.xlsx?version=1&modificationDate=1506097521000&cacheVersion=1&api=v2) | Time series with cyclical shock | People are dying from some health problem X at a current rate of 88/month, and the rate appears to be increasing by 1.3 deaths/month with each month. However, a cure for this problem appears to be close to being finished. Estimates are that the cure will be available between 20 and 50 months from now, but nobody can say that any duration is more likely than any other. Tests so far show that it is expected that there is only a 30% chance the cure will work for a treated person.
Forecast the number of deaths there will be for the next 100 months if the cure is approved and if not approved. | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Pylons](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575602)
[Pylons download](/wiki/download/attachments/26581760/Pylons-AtRISK.xlsx?version=1&modificationDate=1506097521000&cacheVersion=1&api=v2) | Exercise to allow you to try out various modeling techniques | Your company has been invited to bid for a project to design and construct a line of 16 electricity pylons. Estimates are based on [PERT distributions](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575433) (using absolute minimum, most likely and absolute maximum) unless indicated. Produce distributions of the total project cost and duration. Use a scatter plot to illustrate the relationship between the projects cost and duration. Plot iterations above and below 35 weeks separately on the same graph and fit regression lines through the two data sets. | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217)
[Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204)
[D](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[iscrete](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575205)
[Normal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575246)
[PERT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575251) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[ROUNDUP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Pylons correlated](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575602)
[Pylons correlated download](/wiki/download/attachments/26581760/Pylons_correlated-AtRISK.xlsx?version=1&modificationDate=1506097521000&cacheVersion=1&api=v2) | Exercise to allow you to try out various modeling techniques
[Correlation matrix](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575456) | Your company has been invited to bid for a project to design and construct a line of 16 electricity pylons. Estimates are based on [PERT distributions](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575433) (using absolute minimum, most likely and absolute maximum) unless indicated. Rerun the model Pylon, but make the design time and cost 50% correlated and the time to do the foundations 40% correlated with the associated plant cost and 50% correlated with the total foundation man hours. What is the effect of including these correlations? | [Beta](https://modelassist.epixanalytics.com/space/EA/26575217/Beta)
[Correlation Matrix Tool](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575456)
[D](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[iscrete](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575205)
[Normal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575246)
[PERT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575251) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[ROUNDUP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [RandomWalk1](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26577359)
[RandomWalk1 download](/wiki/download/attachments/26581760/Random_walk_1-AtRISK.xlsx?version=1&modificationDate=1506097522000&cacheVersion=1&api=v2) | Additive random walk with no memory | Model a random walk: St = St-1+ Normal(*m*,*s*) | [Normal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575246) | |
| [RandomWalk2](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575451)
[RandomWalk2 download](/wiki/download/attachments/26581760/Random_walk_2-AtRISK.xlsx?version=1&modificationDate=1506097522000&cacheVersion=1&api=v2) | Multiplicative random walk with no memory | Model a random walk: St = St-1* Normal(1+*m*,*s*) | [Normal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575246) | |
| [Raw egg](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575285)
[Raw egg download](/wiki/download/attachments/26581760/Raw_egg-AtRISK.xlsx?version=1&modificationDate=1506097522000&cacheVersion=1&api=v2) | Mixing calculation and simulation in risk models | You have determined that a raw egg has a 0.2% probability of being contaminated with Salmonella, that there is a 3.5% probability that a random egg would be consumed raw, a contaminated raw egg contains Poisson(50) bacteria, and that the probability a person would be ill is =1-Exp(-bacteria/5308)^-0.4059. You are asked to calculate the probability that a random egg will cause someone to become ill. | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | [EXP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[POISSON](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SUMPRODUCT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Rayleigh fit](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575325)
[Rayleigh fit download](/wiki/download/attachments/26581760/Rayleigh_fit-AtRISK.xlsx?version=1&modificationDate=1506097522000&cacheVersion=1&api=v2) | Using [optimization](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575325) (Excels Solver) to obtain an [MLE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575336) fit to a distribution | Find the parameter of a Rayleigh distribution that will best match the observed 18 data points. | | [ABS](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[EXP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[MIN](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
Solver |
| [Real option](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575610)
[Real option download](/wiki/download/attachments/26581760/Real_option-AtRISK.xlsx?version=1&modificationDate=1506097523000&cacheVersion=1&api=v2) | [Real option](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575610) evaluation | Same model as > Macro (inline-external-image)
[NPV of a capital investment](/wiki/download/attachments/26581760/NPV_of_a_capital_investment-AtRISK.xlsx?version=1&modificationDate=1506097518000&cacheVersion=1&api=v2), but with the addition of a real option to be evaluated | [D](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[iscrete Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575206) | |
| [Recursive formulae](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575270)
[Recursive formulae download](/wiki/download/attachments/26581760/Recursive_formulae-AtRISK.xlsx?version=1&modificationDate=1506097523000&cacheVersion=1&api=v2) | Using [recursive formulae](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575270) to construct a distribution | Illustrates a method to construct a Binomial(1000000, 0.000001) distribution. | [D](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[iscrete](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575205) | |
| [Regression Bootstrap X Y random using INDEX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575417)
[Regression Bootstrap X Y random using INDEX download](/wiki/download/attachments/26581760/Regression_Bootstrap_X_Y_random_using_INDEX-AtRISK.xlsx?version=1&modificationDate=1506097523000&cacheVersion=1&api=v2) | [Regression Bootstrap](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575417)
Use of INDEX function | Illustrates the Parametric regression Bootstrap technique using Excels INDEX function to calculate the statistics of interest for two dependent datasets. | [I](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[nteger Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575209) | [COUNT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[INDEX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[INTERCEPT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SLOPE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[STEYX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Regression Bootstrap X Y random using OFFSET](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575417)
[Regression Bootstrap X Y random using OFFSET download](/wiki/download/attachments/26581760/Regression_Bootstrap_X_Y_random_using_OFFSET-AtRISK.xlsx?version=1&modificationDate=1506097523000&cacheVersion=1&api=v2) | [Regression Bootstrap](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575417)
Use of OFFSET function | Illustrates the Parametric regression Bootstrap technique using Excels OFFSET function to calculate the statistics of interest for two dependent datasets. | [I](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[nteger Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575209) | [COUNT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[INDEX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[INTERCEPT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SLOPE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[STEYX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Regression Bootstrap X Y random using VLOOKUP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575417)
[Regression Bootstrap X Y random using VLOOKUP download](/wiki/download/attachments/26581760/Regression_Bootstrap_X_Y_random_using_VLOOKUP-AtRISK.xlsx?version=1&modificationDate=1506097523000&cacheVersion=1&api=v2) | [Regression Bootstrap](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575417)
Use of VLOOKUP function | Illustrates the Parametric regression Bootstrap technique using Excels VLOOKUP function to calculate the statistics of interest for two dependent datasets. | [I](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[nteger Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575209) | [COUNT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[INTERCEPT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SLOPE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[FALSE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[VLOOKUP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Risk Data](https://modelassist.epixanalytics.com/wiki/spaces/EA/pages/26581732)
[Risk Data download](/wiki/download/attachments/26581760/RiskData-AtRISK.xlsx?version=1&modificationDate=1506097524000&cacheVersion=1&api=v2) | The RiskData function | Illustrates the use of the RiskData(source,i,s) function, which reports the value generated for the source (cell reference, cell name or output name) for the ith iteration. | | |
| [Risk Lock 1](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575488)
[Risk Lock 1 download](/wiki/download/attachments/26581760/Risklock1-AtRISK.xlsx?version=1&modificationDate=1506097524000&cacheVersion=1&api=v2) | Using the RiskLock function to perform a [sensitivity analysis](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575488) by locking distributions sequentially to their most likely value. | Our risk model consists of 10 input (Triangular) and 1 output distributions. We need perform a sensitivity analysis by sequentially locking the value of each input distribution to its most likely value. | [Triangular](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575255) | [FALSE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Risk Lock 2](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575488)
[Risk Lock 2 download](/wiki/download/attachments/26581760/Risklock2-AtRISK.xlsx?version=1&modificationDate=1506097524000&cacheVersion=1&api=v2) | Using the RiskLock function to perform a [sensitivity analysis](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575488) by locking distributions sequentially to their most likely value. | Our risk model consists of 10 input (Triangular) and 1 output distributions. We need perform a sensitivity analysis by sequentially locking the value of each input distribution to its most likely value. | [Triangular](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575255) | [FALSE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[TRUE](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Risk portfolio](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575635)
[Risk portfolio download](/wiki/download/attachments/26581760/risk_portfolio-AtRISK.xlsx?version=1&modificationDate=1506097524000&cacheVersion=1&api=v2) | Modeling impact of [correlated](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575455) risks | Model a portfolio of risks that can influence the base estimated project cost and calculate the total cost of a project including inflation. There are 5 risk factors, some of which are correlated, plus the risk coming from the inflation. The probability of a strike doubles if the "bad weather" factor occurs. If both the "H&S" and "Strike" factors occur, the "Insolvency of sub-contractor" risk factor rises from 5% to 75%. | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217)
[Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204)
[Triangular](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575255) | [AND](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Sales at the store](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575620)
[Sales at the store download](/wiki/download/attachments/26581760/Sales_at_the_store-AtRISK.xlsx?version=1&modificationDate=1506097524000&cacheVersion=1&api=v2) | [Poisson process](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574979)
[Summing large random number of random variables](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575620) using [Central Limit Theorem](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574953) | A small shop wishes to estimate the revenue for the next year. Historical data shows that the total number of people passing the store is equal to 270,000 per year. There is a 3% probability that a passing the store person will enter the shop, and 10% probability that the person that entered the shop will make a purchase. The purchase size is distributed normally with mean - $12.71 and standard deviation - $7.27. What is the distribution of the annual revenue? | [Normal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575246)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | [SQRT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Sales projection for a finite market](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575607)
[Sales projection for a finite market download](/wiki/download/attachments/26581760/Sales_projection_for_a_finite_market-AtRISK.xlsx?version=1&modificationDate=1506097524000&cacheVersion=1&api=v2) | Model the sales over a period where it is known that there is a finite market for the product. | | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204)
[Normal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575246)
[Triangular](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575255) | [ROUND](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SQRT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Schedule model with risks](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575601)
[Schedule model with risks download](/wiki/download/attachments/26581760/Schedule_model_with_risks-AtRISK.xlsx?version=1&modificationDate=1506097525000&cacheVersion=1&api=v2) | [Project schedule modeling](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575597) with risks | There are three identified risks that can influence the duration of certain stages of the project. The GANTT chart below shows the diagram of the project schedule. Calculate the distribution of the total duration for this project. | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204)
[Triangular](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575255) | [MAX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Seasonal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575452)
[Seasonal download](/wiki/download/attachments/26581760/Seasonal-AtRISK.xlsx?version=1&modificationDate=1506097525000&cacheVersion=1&api=v2) | Additive and multiplicative seasonalized forecasts with trend. | | [Normal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575246) | |
| [Seasonal Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575447)
[Seasonal Poisson download](/wiki/download/attachments/26581760/Seasonal_Poisson_random_walk-AtRISK.xlsx?version=1&modificationDate=1506097525000&cacheVersion=1&api=v2) | Time series projection of events occurring randomly in time with [seasonality](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575452) and [cyclical shock](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575448) | An insurance company needs to model the number of old people deaths over the next 52 weeks period. The projection should include three factors: a) 5% annual downward trend due to the improvement of medical care, b) seasonality factor - higher probability of a death during summer and winter, c) economic factor - the country is expecting a sharp increase in pension in June if the law is passed through parliament which should help pensioners with heating and food, but the resultant reduction in the death rate is uncertain. | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204)
[Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575256)
[Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[MIN](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[MAX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Share price movement](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575606)
[Share price movement download](/wiki/download/attachments/26581760/share_price_movement-AtRISK.xlsx?version=1&modificationDate=1506097525000&cacheVersion=1&api=v2) | Illustration of incorrect modeling of [sum of random variables](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575616) | An individual share price movement follows a Normal(*m*,*s*) distribution. Model the distribution of the change in share price after n number of turns. | [Normal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575246) | [SQRT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Sheep in 10 tons](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575621)
[Sheep in 10 tons download](/wiki/download/attachments/26581760/sheep_in_10_tons-AtRISK.xlsx?version=1&modificationDate=1506097525000&cacheVersion=1&api=v2) | Number of random variables to reach a target | The farm sells sheep to the slaughterhouse each week by supplying the certain amount of kilograms. The task is to calculate the number of sheep that the farm needs to supply in order to make the total weight of the sheep equal the required number. | [Lognormal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575244) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[MAX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Sheep with confidence](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575621)
[Sheep with confidence download](/wiki/download/attachments/26581760/sheep_with_confidence-AtRISK.xlsx?version=1&modificationDate=1506097526000&cacheVersion=1&api=v2) | Number of random variables to reach a target with a particular probability | How many sheep is needed to supply to be 95% sure of producing at least 10 tons | [Lognormal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575244) | [AND](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Silo](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575600)
[Silo download](/wiki/download/attachments/26581760/silo-AtRISK.xlsx?version=1&modificationDate=1506097526000&cacheVersion=1&api=v2) | Simple project duration model | In order to build a silo, a construction firm needs to finish several inter-related stages of different duration. What is the total duration of the project? | [Triangular](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575255) | [MAX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Simulating a financial stock and valuing a call option](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26586589)
[Simulating a financial stock and valuing a call option download](https://epixanalytics.atlassian.net/wiki/download/attachments/26586589/Simulating%20a%20financial%20stock%20with%20a%20GBM%20timeseries%20and%20valuing%20a%20call%20option_AtRISK.xlsx?version=1&modificationDate=1557785858000&cacheVersion=1&api=v2) | Simulating a stock price with a [random walk](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26586613) model and valuation of a call option with the Black-Scholes model. | | [Lognormal](https://modelassist.epixanalytics.com/wiki/spaces/EA/pages/26575244/)
[Normal](https://modelassist.epixanalytics.com/wiki/spaces/EA/pages/26575246/) | [EXP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SQRT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[MAX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[NORMSDIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[RiskLognorm](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26581732)
[RiskNormal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26581732) |
| [Simulating a variable risk](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575526)
[Simulating a variable risk download](/wiki/download/attachments/26581760/Simulating_a_variable_risk-AtRISK.xlsx?version=1&modificationDate=1506097526000&cacheVersion=1&api=v2) | Two ways of simulating a risk event with a random impact | Lets imagine that there will be an election this year and that two parties are running: the Socialist Democrats Party and the Democratic Socialists Party. The SDP are currently in power and have vowed to keep the corporate tax rate at 17% if they win the election. Political analysts reckon they have about a 65% chance of staying in power. The DSP promise to lower the corporate tax rate by one to four percent, most probably 3%. Model the next years corporate tax rate. | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217)
[Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204)
[D](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[iscrete](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575205)
[PERT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575251) | |
| [Smooth splice Gamma and Pareto](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575624)
[Smooth splice Gamma and Pareto download](/wiki/download/attachments/26581760/Smooth_splice_Gamma_and_Pareto-AtRISK.xlsx?version=1&modificationDate=1506097526000&cacheVersion=1&api=v2) | Splicing two distributions with smooth transfer function | Model to splice a Pareto distribution onto a Gamma distribution to extend its tail. | [G](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[eneral](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575232) | [GAMMADIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[LOG](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[NORMDIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Splice Gamma and Pareto](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575624)
[Splice Gamma and Pareto download](/wiki/download/attachments/26581760/Splice_Gamma_and_Pareto-AtRISK.xlsx?version=1&modificationDate=1506097526000&cacheVersion=1&api=v2) | Splicing two distributions by using a [truncation](https://modelassist.epixanalytics.com/space/EA/26578015/Bounded+and+unbounded+distributions) to give the smooth transition | Model to splice a Pareto distribution onto a Gamma distribution to extend its tail. | [G](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[eneral](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575232) | [GAMMADIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Stock Price with Mean Reversion](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575613)
[Stock Price with Mean Reversion download](/wiki/download/attachments/26581760/Stock_price_with_mean_reversion-AtRISK.xlsx?version=1&modificationDate=1506097527000&cacheVersion=1&api=v2) | | | [Normal](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575246) | [EXP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Stress and strength](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575637)
[Stress and strength download](/wiki/download/attachments/26581760/Stress_and_strength-AtRISK.xlsx?version=1&modificationDate=1506097527000&cacheVersion=1&api=v2) | Model to determine the probability that stress on a component exceeds its strength, and therefore causes it to fail | | [Gamma](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575231) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Summary chart](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575483)
[Summary chart download](/wiki/download/attachments/26581760/Summary_chart-AtRISK.xlsx?version=1&modificationDate=1506097527000&cacheVersion=1&api=v2) | A template to plot a [summary chart](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575483) in Excel after exporting the required output statistics from Crystal Ball into Excel. | | | |
| [Ten lightbulbs](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575628)
[Ten lightbulbs download](/wiki/download/attachments/26581760/Ten_lightbulbs-AtRISK.xlsx?version=1&modificationDate=1506097528000&cacheVersion=1&api=v2) | Modeling a parallel [renewal process](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574992) | It is known that a certain type of light bulb has a lifetime that is Weibull(1.3,4020) hours distributed. If I have 10 light bulbs going at all times, how many will fail in 1000 hours? | [Weibull](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575257) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Tigers (topic link 1)](https://modelassist.epixanalytics.com/wiki/spaces/EA/pages/26575649)
[Tigers (topic link 2)](https://modelassist.epixanalytics.com/wiki/spaces/EA/pages/26575396)
[Tigers download](/wiki/download/attachments/26581760/tigers-AtRISK.xlsx?version=1&modificationDate=1506097528000&cacheVersion=1&api=v2) | [Bayesian inference](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575368)
[Capture-release-recapture experiment](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575396)
[Hypergeometric sampling](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574987) | A game warden on an island covered in jungle would like to know how many tigers she has on her island. She arranges for a capture-release-recapture survey to be carried From the experiments results, estimate how many tigers are there on the island. | [D](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[iscrete](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575205) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[HYPGEOMDIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Time series fitting and forecasting](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26586613)
[Time series fitting and forecasting download](https://epixanalytics.atlassian.net/download/attachments/23068723/Time_series_fitting_and_forecasting_AtRisk.xlsx?version=2&modificationDate=1558462486000&api=v2) | Fit a time series to historical data and use the fitted model to forecast. | | | |
| [Transaction failures](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574985)
[Transaction failures download](/wiki/download/attachments/26581760/Transaction_failures-AtRISK.xlsx?version=1&modificationDate=1506097529000&cacheVersion=1&api=v2) | Estimating total cost of [Poisson failures](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574980) at different rates. Note this is a [VC/RS/US](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575532) model | In 79 weeks, a company has observed 21 transaction failures. Each transaction failure costs are shown in the table below. What is the cost for these transaction failures next year? | [Gamma](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575231)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | [SUMPRODUCT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Treatment comparison](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575629)
[Treatment comparison download](/wiki/download/attachments/26581760/Treatment_comparison-AtRISK.xlsx?version=1&modificationDate=1506097530000&cacheVersion=1&api=v2) | Comparison of several [uncertain binomial probabilities](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574975)
[Numerical integration](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575285) | A government agency is charged with regulating the prescription of drugs. A pharmaceutical company have developed a new drug useful in the control of disease X. In field trials they have tried various dose:duration combinations with randomly selected individuals suffering from X. The results are shown in a table. How confident are we that combination D is the most effective of the four options? Is it plausible that combination A is actually better? | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217) | [IF](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[MAX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Tukey Box Plot](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575483)
[Tukey Box Plot download](/wiki/download/attachments/26581760/Tukey_Box_Plot-AtRISK.xlsx?version=1&modificationDate=1506097530000&cacheVersion=1&api=v2) | A template to produce a Tukey Box Plot, which is commonly used to represent variations between data sets. | | | |
| [Turbine blade construction](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575398)
[Turbine blade construction download](/wiki/download/attachments/26581760/Turbine_blade_construction-AtRISK.xlsx?version=1&modificationDate=1506098118000&cacheVersion=1&api=v2) | [Bayesian inference](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575368)
[Numerical integration](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575285)
[Hyperparameters](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575380)
[Constructing posterior](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575383) | Your company manufactures gas turbines for power stations. One of the key performance characteristics is that the turbine blades do not, with high probability, develop micro-fractures beyond size X within an operation period T. There are 50 blades in a turbine. You test 18 turbines for the required period T, and perform an inspection of the blades using a sonic scanner. The inspection method is not foolproof: it has a 20% chance of failing to detect a fracture that is there. Your study identified 3 fractures. What is the probability that a turbine satisfies the performance requirement?
Contacting the manufacturer of the sonic scanner, you find that actually they are not so sure about this 20% failure rate: it is based on a study where 4 of 5 fractures were detected. How does this affect your estimate of the probability that a turbine satisfies the performance requirement? | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217)
[G](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575571)[eneral](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575232) | [BINOMDIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Turbine blade simulation](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575398)
[Turbine blade simulation download](/wiki/download/attachments/26581760/Turbine_blade_simulation-AtRISK.xlsx?version=1&modificationDate=1506097530000&cacheVersion=1&api=v2) | [Bayesian inference](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575368)
[Numerical integration](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575285)
[Hyperparameters](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575380)
[Simulating posterior](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575384) | Same as > Macro (inline-external-image)
[Turbine blade construction](/wiki/download/attachments/26581760/Turbine_blade_construction-AtRISK.xlsx?version=1&modificationDate=1506098118000&cacheVersion=1&api=v2) | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217)
[NegBinomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575213) | |
| [VC RC US - 1](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575531)
[VC RC US - 1 download](/wiki/download/attachments/26581760/VC_RC_US_-_1-AtRISK.xlsx?version=1&modificationDate=1506097530000&cacheVersion=1&api=v2) | Part 1 of a simple example of a VC/RC/US model: randomness R only | A VC/RC/US model, where the probability of each possible outcome is explicitly calculated (RC), the range of variability is incorporated by making separate calculations (VC) for each value of the variability parameter(s), and the uncertainty is simulated (US). | | [POISSON](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SQRT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[Array formulae](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [VC RC US - 2](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575531)
[VC RC US - 2 download](/wiki/download/attachments/26581760/VC_RC_US_-_2-AtRISK.xlsx?version=1&modificationDate=1506097531000&cacheVersion=1&api=v2) | Part 2 of a simple example of a VC/RC/US model: randomness R and uncertainty U | An extension to model > Macro (inline-external-image)
[VC RC US - 1](/wiki/download/attachments/26581760/VC_RC_US_-_1-AtRISK.xlsx?version=1&modificationDate=1506097530000&cacheVersion=1&api=v2): randomness and uncertainty | [Gamma](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575231) | [POISSON](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[SQRT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[Array formulae](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [VC RC US - 3](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575531)
[VC RC US - 3 download](/wiki/download/attachments/26581760/VC_RC_US_-_3-AtRISK.xlsx?version=1&modificationDate=1506097531000&cacheVersion=1&api=v2) | Part 3 of a simple example of a VC/RC/US model: randomness R, uncertainty U and variability V | An extension to model > Macro (inline-external-image)
[VC RC US - 2](/wiki/download/attachments/26581760/VC_RC_US_-_2-AtRISK.xlsx?version=1&modificationDate=1506097531000&cacheVersion=1&api=v2): randomness, uncertainty and variability | | |
| [VC RS UL - 1](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575534)
[VC RS UL - 1 download](/wiki/download/attachments/26581760/VC_RS_UL_-_1-AtRISK.xlsx?version=1&modificationDate=1506097531000&cacheVersion=1&api=v2) | Simple example of a VC/RS/UL model
Part 1: generating values for uncertain parameters and | Variability is calculated, Randomness is simulated and Uncertainty is simulated in second loop (VC/RS/UL model) | [Gamma](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575231)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | |
| [VC RS UL - 2](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575534)
[VC RS UL - 2 download](/wiki/download/attachments/26581760/VC_RS_UL_-_2-AtRISK.xlsx?version=1&modificationDate=1506097531000&cacheVersion=1&api=v2) | Simple example of a VC/RS/UL model
Part 2: using generated values for uncertain parameters in loop | Variability is calculated, Randomness is simulated and Uncertainty is simulated in second loop (VC/RS/UL model) | [Gamma](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575231)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | |
| [VC RS US - 1](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575532)
[VC RS US - 1 download](/wiki/download/attachments/26581760/VC_RS_US_-_1-AtRISK.xlsx?version=1&modificationDate=1506097531000&cacheVersion=1&api=v2) | Simple example of a VC/RS/US model | Variability is calculated, Randomness and Uncertainty are simulated (VC/RS/US model). Example 1. | [Gamma](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575231)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | |
| [VC RS US - 2](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575532)
[VC RS US - 2 download](/wiki/download/attachments/26581760/VC_RS_US_-_2-AtRISK.xlsx?version=1&modificationDate=1506097531000&cacheVersion=1&api=v2) | Extension to > Macro (inline-external-image)
[VC RC US - 1](/wiki/download/attachments/26581760/VC_RC_US_-_1-AtRISK.xlsx?version=1&modificationDate=1506097530000&cacheVersion=1&api=v2) model showing how additional variability extends complexity quickly | Variability is calculated, Randomness and Uncertainty are simulated (VC/RS/US model). Extension to the previous example with additional levels of variability. | [Gamma](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575231)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | |
| [VOII](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26579297)
[VOII download](/wiki/download/attachments/26581760/VOII-AtRISK.xlsx?version=1&modificationDate=1506097532000&cacheVersion=1&api=v2) | | | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217)
[Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204) | [BETADIST](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [VS RS US - 1](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575533)
[VS RS US - 1 download](/wiki/download/attachments/26581760/VS_RS_US_-_1-AtRISK.xlsx?version=1&modificationDate=1506097532000&cacheVersion=1&api=v2) | Simple example of a VS/RS/US model | Variability, Randomness and Uncertainty are simulated together (VS/RS/US model). Example 1 | [Gamma](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575231)
[Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575256)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | [COUNT](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[INDEX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [VS RS US - 2](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575533)
[VS RS US - 2 download](/wiki/download/attachments/26581760/VS_RS_US_-_2-AtRISK.xlsx?version=1&modificationDate=1506097532000&cacheVersion=1&api=v2) | Alternative approach to > Macro (inline-external-image)
[VS RS US - 1](/wiki/download/attachments/26581760/VS_RS_US_-_1-AtRISK.xlsx?version=1&modificationDate=1506097532000&cacheVersion=1&api=v2) | Variability, Randomness and Uncertainty are simulated together (VS/RS/US model). Example 2 | [Gamma](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575231)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | |
| [Waiting under the clock](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575639)
[Waiting under the clock download](/wiki/download/attachments/26581760/Waiting_under_the_clock-AtRISK.xlsx?version=1&modificationDate=1506097532000&cacheVersion=1&api=v2) | Simulation thinking
Graphical illustration of model | Two people agreed to meet under a clock between 1pm and 2pm. Each agreed to wait 20 minutes for the other. What is the probability that they meet? | [Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575256) | |
| [Weibull](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575630)
[Weibull download](/wiki/download/attachments/26581760/Weibull-AtRISK.xlsx?version=1&modificationDate=1506097534000&cacheVersion=1&api=v2) | Generating random values from a distribution using [formula inversion method](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575630) | Illustrates the technique of generating one of the three standard extreme value distributions - a Weibull distribution | [Uniform](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575256) | [LN](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Weibull complete](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575326)
[Weibull complete download](/wiki/download/attachments/26581760/Weibull_complete-AtRISK.xlsx?version=1&modificationDate=1506097533000&cacheVersion=1&api=v2) | Finding [MLEs](https://modelassist.epixanalytics.com/space/EA/26575336/Maximum+Likelihood+Estimation+-+MLE) for a distribution fitted to [complete data](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575307) using [optimization](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575325) | Illustration of MLE fitting to the Weibull distribution using complete data | | [LOG](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[WEIBULL](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[Array formulae](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
Solver |
| [Weibull complete joint distribution](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575323)
[Weibull complete joint distribution download](/wiki/download/attachments/26581760/Weibull_complete_joint_distribution-AtRISK.xlsx?version=1&modificationDate=1506097532000&cacheVersion=1&api=v2) | [Bayesian inference for two correlated parameters](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575323)
[Likelihood function](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575381) for [complete data](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575307) | Determining the joint uncertainty distribution for parameters of a Weibull distribution where we have values for all observations | [General](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575232) | [EXP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[INDEX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[HLOOKUP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[LOG](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[WEIBULL](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[Array formulae](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Weibull interval censored](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575326)
[Weibull interval censored download](/wiki/download/attachments/26581760/Weibull_interval_censored-AtRISK.xlsx?version=1&modificationDate=1506097533000&cacheVersion=1&api=v2) | Finding [MLEs](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575336) for a distribution fitted to [interval censored data](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575307) using [optimization](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575325) | Illustration of MLE fitting to the Weibull distribution using interval censored data | | [LOG](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[WEIBULL](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[Array formulae](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
Solver |
| [Weibull interval censored joint distribution](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575323)
[Weibull interval censored joint distribution download](/wiki/download/attachments/26581760/Weibull_interval_censored_joint_distribution-AtRISK.xlsx?version=1&modificationDate=1506097533000&cacheVersion=1&api=v2) | [Bayesian inference for two correlated parameters](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575323)
[Likelihood function](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575381) for [interval censored data](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575307) | Determining the joint uncertainty distribution for parameters of a Weibull distribution where we only know the frequency of values within (usually contiguous) bin ranges. | [General](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575232) | [EXP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[INDEX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[HLOOKUP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[LOG](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[WEIBULL](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[Array formulae](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Weibull left censored](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575326)
[Weibull left censored download](/wiki/download/attachments/26581760/Weibull_left_censored-AtRISK.xlsx?version=1&modificationDate=1506097534000&cacheVersion=1&api=v2) | Finding [MLEs](https://epixanalytics.atlassian.net/static/modelassist/CrystalBall/Analysing_and_using_data/Fitting_distributions/Maximum_Likelihood_Estimates_MLEs.htm) for a distribution fitted to [left censored data](https://modelassist.epixanalytics.com/space/EA/26575307/Censored+data) using [optimization](https://modelassist.epixanalytics.com/space/EA/26575325/Finding+the+Best+Fitting+Parameters+using+Optimisation) | Illustration of MLE fitting to the Weibull distribution using left censored data | | [LOG](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[WEIBULL](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[Array formulae](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
Solver |
| [Weibull left censored joint distribution](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575323)
[Weibull left censored joint distribution download](/wiki/download/attachments/26581760/Weibull_left_censored_joint_distribution-AtRISK.xlsx?version=1&modificationDate=1506097533000&cacheVersion=1&api=v2) | [Bayesian inference for two correlated parameters](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575323)
[Likelihood function](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575381)
for [left censored data](https://modelassist.epixanalytics.com/space/EA/26575307/Censored+data) | Determining the joint uncertainty distribution for parameters of a Weibull distribution where we only have values for observations above a threshold. | [General](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575232) | [EXP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[INDEX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[HLOOKUP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[LOG](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[WEIBULL](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[Array formulae](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Weibull right censored](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575326)
[Weibull right censored download](/wiki/download/attachments/26581760/Weibull_right_censored-AtRISK.xlsx?version=1&modificationDate=1506097534000&cacheVersion=1&api=v2) | Finding [MLEs](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575336) for a distribution fitted to [right censored data](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575307) using [optimization](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575336) | Illustration of MLE fitting to the Weibull distribution using right censored data | | [LOG](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[WEIBULL](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[Array formulae](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
Solver |
| [Weibull right censored joint distribution](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575323)
[Weibull right censored joint distribution download](/wiki/download/attachments/26581760/Weibull_right_censored_joint_distribution-AtRISK.xlsx?version=1&modificationDate=1506097534000&cacheVersion=1&api=v2) | [Bayesian inference for two correlated parameters](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575323)
[Likelihood function](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575381) for [right censored data](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575307) | Determining the joint uncertainty distribution for parameters of a Weibull distribution where we only have values for observations below a threshold. | [General](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575232) | [EXP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[INDEX](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[HLOOKUP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[LOG](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[WEIBULL](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570)
[Array formulae](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
| [Widgets](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575626)
[Widgets download](/wiki/download/attachments/26581760/widgets-AtRISK.xlsx?version=1&modificationDate=1506097534000&cacheVersion=1&api=v2) | [Binomial process](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574972)
[Poisson process](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574979)
Simple simulation | There is a 5% chance of incorrectly setting up a machine to produce widgets resulting in a bad batch of out of tolerance widgets 10 machines are set up on a days production run. Each machine will produce Poisson(250) widgets. What fraction of my production will be out of tolerance? | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | |
| [Wine experts](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575647)
[Wine experts download](/wiki/download/attachments/26581760/wine_experts-AtRISK.xlsx?version=1&modificationDate=1506097535000&cacheVersion=1&api=v2) | [Bayesian inference](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575368)
[Binomial probability estimate](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574975)
[Numerical integration](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575285)
[Graphical presentation of model](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575464) | Two wine experts are each asked to guess the year of 20 different wines. Expert A guesses 11 correctly, while expert B guesses 14 correctly. How confident can we be that Expert B is really better at this exercise than Expert A? | [Beta](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575217) | |
| [Wine problem](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575626)
[Wine problem download](/wiki/download/attachments/26581760/wine_problem-AtRISK.xlsx?version=1&modificationDate=1506097535000&cacheVersion=1&api=v2) | [Binomial process](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574972)
[Poisson process](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26574979)
Simple dose-response model | 20 people are invited to a party, where some wine, contaminated with bacteria, is being served. Let's say we know that there are on average 7 bacteria per litre of wine, and one glass contains 150 ml of wine. 12 out of 20 people decided to drink one glass of wine each.
Let's also say that we know that 7 people at the party are allergic to this particular bacterium, so if they consume one or more bacteria they have a higher chance of getting ill than those who are not allergic. The probabilities of getting ill for both allergic and non-allergic people are shown in the table below. How many people are going to get ill? | [Binomial](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575204)
[Poisson](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575214) | [VLOOKUP](https://epixanalytics.atlassian.net/wiki/spaces/EA/pages/26575570) |
---