{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Probability Distributions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Probability Distributions","index":0,"n_rows":47,"n_cols":46,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIDE THESE COLUMNS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THEY'RE HERE ONLY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TO HELP CENTER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THE TITLE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Probability Mass",null,null,null,null,null,null,null,null,"Cumulative",null,null,null,"Expected",null,null,null,null,null,null,null,null,null,null,null,"Moment Generating"]
[null,"Distribution",null,null,null,"Description",null,null,null,"Notes",null,null,null,"Notation",null,null,null,"or Density Function",null,null,null,null,null,null,null,null,"Distribution Function",null,null,null,"Value",null,null,null,"Variance",null,null,null,"Median",null,null,null,"Function"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ","-----------------------------------------------(PMF or PDF)-----------------------------------------------",null,null," ",null,null,null,null," ","-----------------------------------------------(CDF)-----------------------------------------------",null,null," ","-----------------------------------------------(μ)-----------------------------------------------",null,null," ","-----------------------------------------------(σ2)-----------------------------------------------",null,null," ",null,null,null," ","-----------------------------------------------(MGF)-----------------------------------------------",null,null," "]
[null,null,null,null,null,"(a)",null,null,null,{"$f":"\"(\"&CHAR(CODE(MID(F9,2,1))+1)&\")\"","v":"(b)"},null,null,null,{"$f":"\"(\"&CHAR(CODE(MID(J9,2,1))+1)&\")\"","v":"(c)"},null,null,null,{"$f":"\"(\"&CHAR(CODE(MID(N9,2,1))+1)&\")\"","v":"(d)"},null,null,null,null,null,null,null,null,{"$f":"\"(\"&CHAR(CODE(MID(R9,2,1))+1)&\")\"","v":"(e)"},null,null,null,{"$f":"\"(\"&CHAR(CODE(MID(AA9,2,1))+1)&\")\"","v":"(f)"},null,null,null,{"$f":"\"(\"&CHAR(CODE(MID(AE9,2,1))+1)&\")\"","v":"(g)"},null,null,null,{"$f":"\"(\"&CHAR(CODE(MID(AI9,2,1))+1)&\")\"","v":"(h)"},null,null,null,{"$f":"\"(\"&CHAR(CODE(MID(AM9,2,1))+1)&\")\"","v":"(i)"}]
[]
[null,"Discrete"]
[]
[null,null,"Bernoulli",null,null,null,"Takes the value 1 with probability p and takes the value 0 with probability q = 1 - p.",null,null,null,"This is a binomial with n = 1 (although this gets circular since the binomial is defined below in terms of the Bernoulli)."]
[]
[null,null,"Binomial",null,null,null,"Sum of n independent Bernoulli trials identically distributed with parameter p.",null,null,null,"Converges to a Poisson as n approaches infinity and p approaches zero in such a way that np = λ, the parameter for the Poisson.",null,null,null,"B(n, p)",null,null,null,null,null,null,null,null,null,null,null,null,"(expressed in terms of the regularized incomplete beta function)"]
[]
[null,null,"Geometric",null,null,null,"Number of Bernoulli trials with parameter p, until 1 success.",null,null,null,"This is equivalent to a negative binomial with r equal to 1."]
[]
[null,null,"Hypergeometric",null,null,null,"Suppose there is an urn with N elements, of which there are A of type 1 and B = N - A of type 2. If n objects are chosen randomly without replacement, the number of elements that are type 1 follows a hypergeometric distribution. Let p = A/N and q = B/N = 1 - p.",null,null,null,"A hypergeometric is like a binomial without replacement. When N is very large relative to n, it approaches a binomial."]
[]
[null,null,"Multinomial",null,null,null,"An experiment has k possible outcomes with probabilities p1, p2, …, pk. If the experiment is repeated n successive times independently, Xi is a random variable of the number of times the experiment results in outcome i.",null,null,null,"Expected value and variance can be thought of in terms of a binomial where p = pi and q = 1 - pi.\nCov(Xi, Xj) = -npipj"]
[]
[null,null,"Negative Binomial",null,null,null,"Number of Bernoulli trials with parameter p, until r successes.",null,null,null,"Equal to the sum of r geometric distributions.",null,null,null,"NB(r, p)"]
[]
[null,null,"Poisson",null,null,null,"Expresses the probability of a number of events occurring in a fixed period of time if these events occur with a known average rate and independently of the time since the last event.",null,null,null,"Can be used as an approximation for the binomial distribution with parameters (n, p) when n is large and p is small so that np is moderate size, with λ = np.",null,null,null,"Pois(λ)"]
[]
[null,null,"Uniform",null,null,null,"A finite number of equally spaced values between a and b are equally likely to be observed; every one of n values has equal probability 1/n, where n equals b - a + 1.",null,null,null,null,null,null,null,"Unif(a, b)"]
[]
[null,"Continuous"]
[]
[null,null,"Chi-Square",null,null,null,"A chi-square random variable is parametrized by its degrees of freedom. If Z is a standard normal random variable, then Z12 + Z22 + … + Zn2 is distributed as a chi-square with n degrees of freedom. It is equivalent to a gamma distribution with α = n / 2 and β = 1 / 2.",null,null,null,"The sum of two standard normals, Z12 + Z22, is distributed as a chi-square with two degrees of freedom. A chi-square with two degrees of freedom is equal to a gamma with  α = 1 and β = 1 / 2. But since  α = 1, this is also equal to an exponential with hazard rate λ = 1 / 2 and mean 2."]
[]
[null,null,"Exponential",null,null,null,"Describes the time between events in a Poisson process with parameter λ. The hazard rate (PDF divided by survival function) of an exponential distribution is constant and equal to λ.\nλe-λt / e-λt = λ\nSince an exponential distribution's hazard rate is constant and equal to λ, the parameter that defines the distribution, sometimes the distribution is spoken of as being parametrized in terms of its hazard rate.",null,null,null,"A Poisson random variable models how many times something will happen in one unit of time (λ is calculated as an average within this time unit). If the occurrences in disjoint time intervals are independent, which is assumed, then the number of occurrences over t units of time is Poisson with mean λt. This can be shown using the fact that the sum of two independent Poisson random variables with parameters λ1 and λ2 is distributed as a Poisson with parameter λ = λ1 + λ2 (a proof of this fact can use the binomial theorem). In the case of t Poissons with the same parameter λ, the resulting random variable is Poisson distributed with parameter λt. The survival function [s(x) = Prob(X > x) = 1 - F(x)] of the exponential distribution equals the probability that the Poisson process with time t is zero, which equals exp(-λt). Note that the probability that the Poisson equals zero is treated as a function of time [i.e., the probability that at time t the Poisson is zero equals exp(-λt)].",null,null,null,"Exp(λ)"]
[]
[null,null,"Gamma 1",null,null,null,"The gamma distribution is formed by adding n IID exponential distributions with hazard rate λ."]
[]
[null,null,"Gamma 2",null,null,null,"For the gamma distribution described, parameter n does not have to be an integer. The more general version of the gamma distribution replaces parameter n with α and λ with β, and α is not constrained to the integers."]
[]
[null,null,"Lognormal",null,null,null,"A probability distribution of a random variable whose natural logarithm is normally distributed. It is parametrized by the mean and variance of its corresponding normal distribution. If X is normally distributed, then exp(X) is lognormally distributed. If Y is lognormally distributed, then ln(Y) is normally distributed.",null,null,null,"The lognormal distribution shows up in something almost analogous to the central limit theorem, but for products. Suppose Y is the product of IID random variables:\nY = X1X2…Xn\nThen ln(Y) = ln(X1) + ln(X2) + … + ln(Xn)\nSo ln(Y) converges in distribution to a normal as n approaches infinity, from the ordinary central limit theorem. Since ln(Y) converges in distribution to a normal, Y converges in distribution to a lognormal."]
[]
[null,null,"Normal",null,null,null,"This is the common bell-shaped curve. It arises in a wide variety of places. The sum of n independent, identically distributed (IID) random variables with mean μ and variance σ2 converges in distribution to a normal distribution with mean nμ and variance nσ2.",null,null,null,"Also referred to as a Gaussian distribution.",null,null,null,"N(μ, σ2)"]
[]
[null,null,"Pareto 1",null,null,null,"Pareto proposed the distribution in terms of its cumulative distribution function, which he believed gave a good approximation to the proportion of incomes that were less than x. The parameter xm is the minimum value that a Pareto random variable can take, and the parameter α is sometimes referred to as the Pareto index. The lower the value of α, the more uniformly dispersed the distribution (e.g., the larger the Pareto index, the smaller the proportion of very high-income people when the distribution is used to model income). xm and α must be greater than zero.",null,null,null,"If the Pareto index, α, is set to log45 = 1.160964, then the 80-20 rule holds. This rule says that 20% of the population makes 80% of the income. In terms of the distribution, if there are n people, with person i's income equal to Xi, then the value k such that F(k) = 0.8 is the cutoff for which 80% of the population makes less than this income. For the other 20% of the population to make 80% of the income, it must hold that the sum of Xi greater than x, divided by the sum of all Xi is equal to 0.8. I have not seen a proof of why this holds, although I believe it must hold in the limit as n approaches infinity. I have also not seen a derivation of why log45 is the appropriate parameter. I believe this proof and derivation would rely on the fact that the Pareto distribution is a power-law probability distribution, but I'm not sure."]
[]
[null,null,"Pareto 2",null,null,null,"A standard Pareto distribution shifted left so that it starts at 0 instead of xm (shifted left x units by adding xm to x in the PDF and CDF equations).",null,null,null,"θ was used to parametrize this in place of xm."]
[]
[null,null,"Uniform",null,null,null,"Values between a and b are equally likely to be observed; density function is constant across x.",null,null,null,null,null,null,null,"Unif(a, b)"]