Title page for E-project-042909-192437

Project Type MQP

Submission date 2009-04-29

Authors
Theresa Cheng, MAC
Benjamin Gilde, MAC
Charlotte Paige McAuliffe, MAC

URN E-project-042909-192437

Sponsor Hewitt Associates LLC

Title Demographic Assumptions

Advisor
Abraham, Jon P, MA

Availability restricted

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.

Files
DAAT.xls
Demographic_Assumptions.pdf
There is one file which has been withheld at the advisor's request.
indicates that a file or directory is accessible from the WPI campus network only.

Browse by Author | Browse by Department | Search all available E-projects

Questions? Email project-questions@wpi.edu
Maintained by webmaster@wpi.edu

Project Type	MQP
Submission date	2009-04-29
Authors	Theresa Cheng, MAC Benjamin Gilde, MAC Charlotte Paige McAuliffe, MAC
URN	E-project-042909-192437
Sponsor	Hewitt Associates LLC
Title	Demographic Assumptions
Advisor	Abraham, Jon P, MA
Availability	restricted
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.
Files	DAAT.xls Demographic_Assumptions.pdf There is one file which has been withheld at the advisor's request. indicates that a file or directory is accessible from the WPI campus network only.