19 November 2018 2 3K Report

Why? You might ask … We are currently developing an index with several socioeconomic indicators (e.g., income, education, employment, etc.). The basic idea is to conduct a regression analysis for each indicator with geography (e.g., province) as a key independent variable. Then we want to take the average across all indicator scores (e.g., standardized betas) and rank-order these scores according to geography (e.g., 1 to 10 scale for ten provinces).

The issue we encounter is that some of our regression analysis are based on linear scales (i.e., income) whereas other measures are based on binary scales (e.g., unemployed or employed). We would use linear regression for income and logistic regression for employment status. Thus the results are interpreted differently (coefficients vs. odds ratios) and are on different scales. Prior to averaging these scores across indicators, we want to transform the values to all be on the same scale. We can do this using the min-max normalization procedure so that all indicators values fall on the same scale (0,1). But is this appropriate? Is there a better alternative?

More Paul Holley's questions See All
Similar questions and discussions