Faculty Advisor

Abraham, Jon P

Abstract

Hewitt Associates, in order to perform valuations on pension plans, must make certain demographic assumptions. The objective of this project was to choose statistical tests to analyze the accuracy of these assumptions, and to provide the sponsor with an automated tool to use on an ongoing basis. This MQP created a tool within Microsoft Excel that works with Hewitt's current pension valuation software to analyze the statistical accuracy of Hewitt's demographic assumptions. The analysis compares how well Hewitt's expected demographic probabilities performed using exact confidence intervals and the calculation of p-values adjusted for False Discovery Rate. This tool flags assumptions that need to be reassessed and will aid Hewitt in improving the accuracy of their demographic assumption.

Publisher

Worcester Polytechnic Institute

Date Accepted

April 2009

Major

Actuarial Mathematics

Project Type

Major Qualifying Project

Accessibility

Unrestricted

Advisor Department

Mathematical Sciences

Share

COinS