Description: Recognizing an opportunity to help serve its members in this age of increased financial oversight, the Health Section of the Society of Actuaries commissioned a series of guides on the use of statistical techniques specifically geared for the work of health actuaries. The first guide in the series titled, 'Statistical Methods for Health Actuaries - IBNR Estimates: An Introduction,' is about the calculation of incurred but not reported [IBNR] health claims reserves. In particular, the guide focuses on the development of confidence intervals around IBNR estimates. This is an Excel workbook created to demonstrate the techniques discussed in the guide.

Description: This work investigates the use of a statistical approach to calculate the incurred but not reported IBNR reserve directly. This allows for the reserve to be estimated in one step, without completion factors, and it provides a confidence interval around the estimate of IBNR as well.

Description: Recognizing an opportunity to help serve its members in this age of increased financial oversight, the Health Section of the Society of Actuaries commissioned a series of guides on the use of statistical techniques specifically geared for the work of health actuaries. In this first guide in the series, the topic is an estimate well-known to health actuaries- the calculation of incurred but not reported [IBNR] health claims reserves. In particular, this guide focuses on the development of confidence intervals around IBNR estimates.