Student Work

Demographic Assumptions

Public

Downloadable Content

open in viewer

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.

  • This report represents the work of one or more WPI undergraduate students submitted to the faculty as evidence of completion of a degree requirement. WPI routinely publishes these reports on its website without editorial or peer review.
Creator
Publisher
Identifier
  • E-project-042909-192437
Advisor
Year
  • 2009
Sponsor
Date created
  • 2009-04-29
Resource type
Major
Rights statement
Last modified
  • 2021-01-26

Relations

In Collection:

Items

Items

Permanent link to this page: https://digital.wpi.edu/show/8c97ks068