JAS
06-07-2006, 01:34 PM
On the second page of this paper, Finger uses the log-normal distribution (mean=50,000 and CV=3) to get results using different attachment points.
Does anyone know how to get these answers in Excel?
Att Pt -----> Result
100,000 ---> 40%
250,000 ---> 21%
1,000,000 --> 5%
Edit: OK, so I'm a moron and didn't look at the table on the next page that showed where these came from!
Does anyone know how to get these answers in Excel?
Att Pt -----> Result
100,000 ---> 40%
250,000 ---> 21%
1,000,000 --> 5%
Edit: OK, so I'm a moron and didn't look at the table on the next page that showed where these came from!