| 
November 22nd, 2008, 02:51 PM
| | Junior Member | | Join Date: Nov 2008
Posts: 44
Country: Thanks: 0
Thanked 16 Times in 15 Posts
| | Need formula for the expected value between two points in a lognormal distribution I'd greatly appreciate any help with this insurance-related math question:
I have the average and the standard deviation of a set of claims ranging between $5,000 and $100,000. My data has no claims in it with values under $5,000 nor does it have any claims in it with values in excess of $100,000. If I'm willing to assume that the overall claim distribution is lognormal, how can I use the average and standard deviation for this limited set of data to derive the mu and sigma for the entire distribution?
Thanks in advance for any and all help!
- Steve J | 
November 22nd, 2008, 07:10 PM
| | Senior Member | | Join Date: Mar 2008
Posts: 448
Country: Thanks: 20
Thanked 202 Times in 169 Posts
| | Quote:
Originally Posted by Steve_J I'd greatly appreciate any help with this insurance-related math question:
I have the average and the standard deviation of a set of claims ranging between $5,000 and $100,000. My data has no claims in it with values under $5,000 nor does it have any claims in it with values in excess of $100,000. If I'm willing to assume that the overall claim distribution is lognormal, how can I use the average and standard deviation for this limited set of data to derive the mu and sigma for the entire distribution?
Thanks in advance for any and all help!
- Steve J | Hi Steve J,
The Wikipedia article on the log-normal distribution, Log-normal distribution - Wikipedia, the free encyclopedia,
gives formulas for mu and sigma in terms of the distribution's mean and standard deviation. | 
November 22nd, 2008, 07:43 PM
| | Junior Member | | Join Date: Nov 2008
Posts: 44
Country: Thanks: 0
Thanked 16 Times in 15 Posts
| | Unfortunately, that doesn't seem to cover it Thanks for the reply. Unfortunately, Wikipedia only seems to provide information for the entire distribution, the distribution limited to some threshold value of X, and/or the distribution in excess of some value of X. I didn't see anything there about what to do if you need to estimate the mean between two values (i.e., where an upper and lower cap both apply).
Again, any additional help would be greatly appreciated. | | Thread Tools | | | | Display Modes | Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts HTML code is Off | | | All times are GMT -7. The time now is 06:11 PM. | | |
 | |  |