Innovative Data Integration Methodology Developed With Multilevel Modeling

Andreea Erciulescu

Westat researchers tackle an increasingly common problem: the need for granular statistics on a set of variables partially collected in distinct studies to assist in answering scientific and policy questions. In new research published in The Canadian Journal of Statistics, they disclose a novel way to integrate data: Statistical data integration using multilevel models to predict employee compensation.

Jean Opsomer

Coauthors Andreea Erciulescu, Ph.D., Jean Opsomer, Ph.D., and Benjamin J. Schneider, M.S., propose a statistical model that integrates 2 surveys’ key data on employee compensation as an example of their approach. The proposed model reconciles the surveys’ estimates for the common variable and uses the relationship between the 2 variables of interest to enable estimation of both variables’ means for all of the subgroups represented in at least one of the surveys. The precision of each variable’s estimate in each subgroup is improved by “borrowing strength” from data available for the other variable and from data available in other subgroups.

Benjamin J. Schneider

This work bridges the statistical fields of data integration and small area estimation. While this work is motivated by a statistical data integration problem, it builds upon small area estimation approaches developed to yield precise survey estimates for population subgroups with small sample sizes. The proposed model also brings a novel contribution to the proposed small area estimation, using unmatched sets of population subgroups in the model specification. This work represents an innovative synthesis of methods from these 2 fields and has the potential to improve official statistics related to employee compensation.

“Combining the information from the 2 surveys is necessary to produce a unique set of statistics for each of the 2 variables for all the domains of interest,” notes Dr. Erciulescu. “The multilevel model we introduce does this, and the application demonstrates how the availability of employee compensation at a granular level is improved.”

Want to work with us?
You’ll be in great company.

About Us Careers

Westat Employees.
Westat Employee.
AAA Foundation for Traffic Safety
Baltimore Metropolitan Council
Centers for Disease Control and Prevention
Centers for Medicare & Medicaid Services
Chicago Metropolitan Agency for Planning
DC Public Schools
Georgia Department of Transportation
Internal Revenue Service
Leadership Montgomery
Maryland Cancer Registry
Michigan Department of Health and Human Services
National Science Foundation
NYC Mayor’s Office for Economic Opportunity
Organization for Economic Cooperation and Development
Robert Wood Johnson Foundation
SiriusXM
Social Security Administration
Substance Abuse and Mental Health Services Administration
Teach for America
Texas Education Agency
The Johns Hopkins University
The National Institutes of Health
The Verizon Foundation
Toyota
U.S. Department of Agriculture
U.S. Department of Education
U.S. Department of Health and Human Services
U.S. Department of Justice
U.S. Department of Transportation
U.S. Department of Veterans Affairs
University of Maryland Baltimore Campus
University of Michigan
University System of Maryland
Explore Our Clients

Please wait...

Forbes 2021 The Best Employers for Women Powered by StatistaForbes 2021 The Best Employers for Diversity Powered by StatistaForbes 2021: America's Best Midsize Employer Powered by Statista Forbes 2021 The Best Employers for Veterans Powered by Statista

Westat is an Equal Opportunity Employer and does not discriminate on the basis of race, creed, color, religion, sex, national origin, age, veteran status, disability, marital status, sexual orientation, citizenship status, genetic information, gender identity or expression, or any other protected status under applicable law. Notices to Employees & Applicants.