CUNY · QUEENS COLLEGE · DEPT. OF SOCIOLOGY

40.74° N · 73.82° W

Joseph Nathan Cohen

Sociologist at Queens College in the City University of New York

Posts

/

Percentile-Based Grouping in SCF Analysis

Introducing the percentile cut function.

Working Paper · CUNY Academic Works · 2026
TypeTechnical Note
VenuePublications and Research, CUNY Academic Works
Updated27 May 2026
Length10 pp.
Abstract

This note examines the task of summarizing statistics by percentile-defined groups in Survey of Consumer Finances (SCF) microdata. Percentile-based grouping is a commonplace analytical operation, but its use in SCF analysis is complicated by the data's complex design. This note reviews three methods for making such comparisons: a naive threshold approach, implicate-wise estimation using Rubin's Rules, or the Federal Reserve's official "stacking" method. The function scf::scf_pctile_sum() offers a structured and transparent means for comparisons by percentile-based grouping variables in SCF analysis. The note demonstrates the function by comparing top-decile mean net worth estimates across SCF survey years to Federal Reserve published estimates and to the Federal Reserve-provided nwcat grouping variable.

Citation · BibTeX
@techreport{cohen2026pctile,

author = {Cohen, Joseph N.},
title = {Percentile-Based Grouping in {SCF} Analysis: Introducing the Percentile Cut Function},
year = {2026},
month = {5},
institution = {CUNY Queens College, Publications and Research},
type = {Working Paper},
url = {https://academicworks.cuny.edu/qc_pubs/705}
}

Share / Cite

Joseph Nathan Cohen Avatar

Associate Professor of Sociology at Queens College, CUNY. Writes about household finance, culture, and the tools social scientists use to measure economic life.