Assessing compensation and organizational variation with imperfect data: An application of count-based indices of variation

Main Article Content

Salomon Alcocer Guajardo

Abstract

An accurate assessment of human capital or labor force variation in organizations is predicated upon collecting error-free data. When organizations report imprecise human capital or labor force data, problematic data analytic issues arise because the application of frequency-based indices of variation obtain questionable measures of variation. This article addresses the assessment of vertical pay variation in organizations with count-based indices of heterogeneity. In doing so, this article demonstrates how imprecise categorical pay dispersion data negatively impacts the ability of logarithm-, mode-, and probability-based indices of variation to obtain accurate and reliable measures of pay variation. More importantly, this article demonstrates how count-based indices of variation overcome data analytic issues presented by imprecise data reported by organizations. In demonstrating their appropriateness to assess variation in organizations, the article assesses the measurement validity and reliability of unstandardized and generalized scores of pay dispersion obtained with count-based indices. By applying count-based indices to imprecise pay dispersion data reported by New York City municipal departments, this article addresses an important data analytic issue and shows that count-based indices are a viable alternative method for assessing variation in organizations when imprecise data limit the use of logarithm-, mode-, or probability-based indices. As an alternative method to frequency-based indices of variation, count-based indices provide additional data analytic techniques for assessing how pay and other forms of variation directly or indirectly affect organizational stability and performance.

Article Details

How to Cite
Assessing compensation and organizational variation with imperfect data: An application of count-based indices of variation. (2025). International Journal of Management and Data Analytics, 5(1), 1-21. http://ijmada.com/index.php/ijmada/article/view/65
Section
Regular Paper

How to Cite

Assessing compensation and organizational variation with imperfect data: An application of count-based indices of variation. (2025). International Journal of Management and Data Analytics, 5(1), 1-21. http://ijmada.com/index.php/ijmada/article/view/65

References

Agresti, A., & Agresti, B. F. (1978). Statistical analysis of qualitative variation. Sociological Methodology, 9, 204-237.

Abdulkadiroglu, A., Pathak, P. A., & Roth, A. E. (2005). The New York City high school match. American Economic Review, 95, 364 – 367.

Alexander, J., Nuchols, B., Bloom, J., & Lee, S. Y. (1995). Organizational demography and turnover: An examination of multiform and nonlinear heterogeneity. Human Relations, 48, 1455-1480.

Biemann, T., & Kearney, E. (2010). Size does Matter: How varying group sizes in a sample affect the most common measures of group diversity. Organizational Research Methods, 13, 582-599.

Bloom, M. (1999). The performance effects of pay dispersion on individuals and organizations. Academy of Management Journal, 42, 25 – 40.

Bloom, M., & Michel, J. G. (2002). The relationships among organizational context, pay dispersion, and managerial turnover. Academy of Management Journal, 45, 33 – 42.

Bossert, W., D’Ambrosio, C., & La Ferrara, E. (2011). A generalized index of ethno-linguistic fractionalization. Economica, 78, 723-750.

Brown, T. A. (2006). Confirmatory factor analysis. The Guilford Press.

Bucciol, A., Foss, N. J., & Piovesan, M. (2014). Pay dispersion and performance in teams. PLOS One, 9, e112631.

Carnahan, S., Agarwal, R., & Campbell, B. (2012). Heterogeneity in turnover: The effect of relative compensation structures of firms on the employee mobility and entrepreneurship of extreme performers. Strategic Management Journal, 33, 1411 – 1430.

Caruso, R., Carlo, B. P., & Marco, D. D. (2016). Does diversity in the payroll affect soccer teams’ performance? Evidence from the Italian Serie A. MPRA Paper No. 75644.

Choi, S., & Rainey, H. G. (2010). Managing diversity in US federal agencies: Effects of diversity and diversity management on employee perceptions of organizational performance. Public Administration Review, 70, 109-121.

Conroy, S. A., Gupta, N., Shaw, J. D., & Park, T. Y. (2014). A multilevel approach to the effects of pay variation. Research in Personnel and Human Resources Management, 32, 1 – 64.

DCAS. (2024). Fiscal Year 2022 New York City government workforce profile report. New York City Department of Citywide Administrative Services.

De Veaux, R. D., & Hand, D. J. (2005). How to lie with bad data. Statistical Science, 20, 231 - 238, DOI 10.1214/088342305000000269.

Downes, P. E., & Choi, D. (2014). Employee reactions to pay dispersion: A typology of existing research. Human Resource Management Review, 24, 53 – 66.

Fitz-enz, J. (2009). ROI of human capital: Measuring the economic value of employee performance. Second edition. American Management Association.

Fitz-enz, J., & Davison, B. (2002). How to measure human resources management. Third edition. McGraw-Hill.

Gini, C. (1921). Measurement of Inequality of Incomes. Economic Journal, 31, 124 – 126.

Grabner, I., & Martin, M. A. (2020). The effect of horizontal pay dispersion on the effectiveness of performance-based incentives. WU Vienna University of Economics and Business. Department of Strategy and Innovation Working Paper Series No. 06/2020 https://doi.org/10.57938/978c8319-ec46-4099-8421-9513a4f5533f

Guajardo, S. A. (2016). Ethnic diversity in policing: An application of quantile regression to the New York City Police Department. Journal of Ethnicity in Criminal Justice, DOI: 10.1080/15377938.2016.1187236

Guajardo, S. A. (2023a). Assessing organizational diversity with the Shannon index. Cambridge Scholars Publishing, Inc.

Guajardo, S. A. (2023b). Assessing organizational diversity with the Simpson index. Cambridge Scholars Publishing, Inc.

Guajardo, S. A. (2023c). Assessing organizational diversity with the Smith and Wilson indices. Cambridge Scholars Publishing, Inc.

Guajardo, S. A. (2024a). Assessing age diversity in municipal departments: New count-based indices of diversity. [Unpublished paper].

Guajardo, S. A. (2024b). Assessing organizational diversity with structural equation modeling. Cambridge Scholars Publishing, Inc.

Guajardo, S. A. (2024c). Assessing workforce diversity in organizations: A case for the utilization of count-based indices of diversity. [Unpublished paper].

Guajardo, S. A. (2024d). Assessing the validity of diversity indices. Cambridge Scholars Publishing, Inc.

Hair, J. F., Hult, T. M., Ringle, C. M., & Sarstedt, M. (2022). A primer on partial least squares structural equation modeling (PLS-SEM). Third edition. Sage Publishing, Inc.

Harrison, D. A., & Klein, K. J. (2007). What’s the difference? Diversity constructs as separation, variety, or disparity in organizations. Academy of Management Review, 32, 1199–1228.

Harrison, D. A., & Sin, H. (2006). What is diversity and how should it be measured. In A. M. Konrad, P. Prasad, & J. K. Pringle (Eds.), Handbook of workplace diversity (pp. 191–216). SAGE Publications.

Hussain, Z., & Khan, A. A. (2019). A new index for measuring evenness. Communications in Statistics - Theory and Methods, 48, 354-36.

Lieberson, S. (1969). Measuring population diversity. American Sociological Review, 34, 850-862.

McCausland, T. (2021). The bad data problem, Research-Technology Management, 64:1, 68 – 71, DOI: 10.1080/08956308.2021.1844540.

Meyer, B., & Glenz, A. (2013). Team faultline measures: A computational comparison and a new approach to multiple subgroups. Organizational Research Methods, 16, 393 – 424.

Meyer, P. (2010). Reliability. Oxford University Press, Inc.

Mueller, J. H., & Schuessler, K. F. (1961) Statistical reasoning in sociology. Houghton Mifflin Company.

Pielou, E. C. (1966). The measurement of diversity in different types of biological collections. Journal of Theoretical Biology, 13, 131-144.

Raganella, A. J., & White, M. D. (2004). Race, gender, and motivation for becoming a police officer: Implications for building a representative police department. Journal of Criminal Justice, 32, 501 – 513.

Shannon, C. E. (1948). A mathematical theory of communication. The Bell System Technical Journal, 27, 379-423.

Shaw, J. D. (2015). Pay dispersion, sorting, and organizational performance. Academy of Management Discoveries, 1, 165 – 179.

Shaw, J. D., & Gupta, N. (2007). Pay system characteristics and quit patterns of good, average, and poor performers. Personnel Psychology, 60, 903 – 928.

Shaw, J. D., Gupta, N., & Delery, J. E. (2002). Pay dispersion and workforce performance: Moderating effects of incentives and interdependence. Strategic Management Journal, 23, 491 – 512.

Simpson, E. H. (1949). Measurement of diversity. Nature, 163, 688.

Stirling, A. (2007). A general framework for analysing diversity in science, technology and society. Journal of the Royal Society Interface, 4, 707 – 719.

Taylor, C. S. (2013). Validity and validation. Oxford University Press, Inc.

Theil, H. (1967). Economics and information theory. Rand McNally and Company.

Wilcox, A. R. (1967). Indices of qualitative variation. U.S. Atomic Energy Commission.

Zhang, Z., He, W., Park, T., Xing, Z., & Wu, X. (2023). The effects of between-group pay dispersion. Academy of Management Journal, 66, 1860 – 1895.