The gamma distribution may be written in several different (but mathematically equivalent) forms. Excel uses the following

Question:

The gamma distribution may be written in several different (but mathematically equivalent) forms. Excel uses the following form for the two-parameter gamma distribution in its functions GAMMADIST (xi) = F(xi) and GAMMAINV(F) = (xi) :
The gamma distribution may be written in several different (but

The three-parameter gamma distribution with lower bound is easily evaluated by replacing the lower and upper limits by and respectively. Method-of-moments estimates for the three parameters are
α = 4/C2S
β = Sx ˆ™ CS / 2 = Sx /ˆšÎ±

The gamma distribution may be written in several different (but

If CS

The gamma distribution may be written in several different (but
The gamma distribution may be written in several different (but

The skewness of the two-parameter gamma distribution is
CS = 2 / ˆša= 2CV
Which provides a way of computing frequency factors, as described below.
Of course, moments are computed using logarithms of the data for the LP3 distribution. For given values of α and β, Excel function GAMMADIST returns F(x1) given x1 and GAMMAINV returns xx given F. Letting x1 = + K - Sx where K(F,CS) is the frequency factor, and using the parameter estimates given above, the upper limit of the integral can be manipulated to give
K(F,CS) = Ginv ˆ™ CS / 2-2 / CS,
Where Ginv = GAM MAIN V(F, α, β) To evaluate K, set β = 1 and a = 4 / Cs Hence, frequency factors can be computed only as a function of the CDF and skewness for any values of either parameter, and Table 3-4 can be avoided. For negative skewness, the symmetry of the distribution is exploited, and the same relationship holds for K, but with 1-F as the argument of GAMMAINV, instead of F. (The negative sign of Cs is retained in the equation.) For the special case of Cs = 0, K = z = standard normal variate.
(a) Compute frequency factors for T = 2yr and 100 yr and for CS = + 0.5 and CS = -0.5 Compare the four values with the values given in Table 3-4.
(b) Repeat Problems 3.7, 3.8 and 3.10 using Excel functions GAMMADIST and GAMMAINV.

Distribution
The word "distribution" has several meanings in the financial world, most of them pertaining to the payment of assets from a fund, account, or individual security to an investor or beneficiary. Retirement account distributions are among the most...
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Hydrology and Floodplain Analysis

ISBN: 978-0132567961

5th edition

Authors: Philip B. Bedient, Wayne C. Huber, Baxter E. Vieux

Question Posted: