• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
The Analysis Factor

The Analysis Factor

Statistical Consulting, Resources, and Statistics Workshops for Researchers

  • Home
  • About
    • Our Programs
    • Our Team
    • Our Core Values
    • Our Privacy Policy
    • Employment
    • Guest Instructors
  • Membership
    • Statistically Speaking Membership Program
    • Login
  • Workshops
    • Online Workshops
    • Login
  • Consulting
    • Statistical Consulting Services
    • Login
  • Free Webinars
  • Contact
  • Login

Rescaling Sets of Variables to Be on the Same Scale

by guest 2 Comments

by Christos Giannoulis, PhD

Attributes are often measured using multiple variables with different upper and lower limits. For example, we may have five measures of political orientation, each with a different range of values.

Each variable is measured in a different way. The measures have a different number of categories and the low and high scores on each measure are different.

  Low Score High Score Variable Name
Trust in Government 1 10 (high trust) TRUST
Political Efficacy 0 4 (high efficacy) POLEF
Feeling towards President 0 100 (positive energy) LEAD
Alienation from politics 8 24 (not alienated) ALIEN
Frequency of reading about politics per week 0 20 (frequent) POLR

The different scales of the variables present two important problems.

1. Comparison

It is very difficult to compare across these variables. The usual way of comparing across variables is to calculate the mean for each variable and to compare the means.

However, since each of the variables is measured on a different scale these means will be extremely difficult to compare.

For example, the mean on trust in government might be 4. The mean for alienation might be 10. But because the scales are different length and have different starting points comparisons of means are not meaningful.

Since each question is measured in different units, it is like comparing apples with oranges.

2. Creating Indices

When creating multi-item scales, items that have different lower and upper points will contribute differently to the final multi-item scale score if used in their raw form.

This means that some items will count for more in the computation of a final score. This is usually not what we want.

It is similar to having three pieces of assessment to arrive at a final mark for a subject at a university. One piece of work might be marked out of 80, another out of 10 and another out of 20.

If we simply added up raw scores, then the piece of work marked out of 80 would count for much more in the final mark.

If this is what was desired then all is well, but if each piece of work was meant to contribute equally to the final mark then we would need to adjust the items to equalize the contribution.

How to make Variables more comparable

The solution to these problems is to convert the scales into a common measurement scale so that they can be compared. This can be achieved in two ways:

  • Converting each scale to have the same lower and upper levels
  • Standardizing the variables and expressing scores at standard deviation units. (z-scores)

You are probably familiar with the latter option, so let me describe the former.

How to Convert Variables to have the same Lower and Upper Limits

This solution involves adjusting the scale on each variable, “stretching” some measures and “squeezing” others. For any numerical scale the conversion is achieved using this formula:

Rescaling-Sets-of-Variables-Formula

Where Y is the adjusted variable, X is the original variable, Xmin is the minimum observed value on the original variable and Xrange is the difference between the maximum potential score and the minimum potential score on the original variable and n is the upper limit of the rescaled variable.

This conversion can easily be accomplished with a variable transformation in any statistical software.

For example, let’s suppose we want all variables converted to a scale of 0-10. Let us convert POLEF (table above). From the table with see that the minimum potential score was 0, and the maximum observed score was 4. The range therefore is 4. Our formula is thus:

Rescaling-Sets-of-Variables-Formula-2

An individual with a score 4 on POLEF would score (4/4) x 10 = 10 on POLEFADJ; a score of 0 on POLEF would convert to (0/4) x 10 = 0 on POLEFADJ, while a score of 2 on POLEF would become a POLEFADJ score on (2/4) x 10 = 5.

Having converted all five variables to a range of 0-10, it becomes much easier to compare scores and averages across them… It may be possible to compare apples and oranges after all!

Principal Component Analysis
Summarize common variation in many variables... into just a few. Learn the 5 steps to conduct a Principal Component Analysis and the ways it differs from Factor Analysis.

Tagged With: data preparation, index variable, rescaling variables

Related Posts

  • Preparing Data for Analysis is (more than) Half the Battle
  • The Difference Between Model Assumptions, Inference Assumptions, and Data Issues
  • Member Training: Determining Levels of Measurement: What Lies Beneath the Surface
  • Tricks for Using Word to Make Statistical Syntax Easier

Reader Interactions

Comments

  1. Shannon Swan says

    November 23, 2019 at 2:36 pm

    this works better for me: Y is the new adjusted value of the item response. X is the original item value, range of the new scale, Xmin is the original minimal possible value, and X range is the original range. This is also shown on the IBM SPSS site under their support page: “Transforming different Likert scales to a common scale” .

    Y = range of new scale* (X-Xmin)/(Xrange) +1, so going from a 1-4 likert scale to a 1-5 likert scale is:

    (5 – 1) * (x – 1) / (4 – 1) + 1 = 4 * (x – 1) / 3 + 1 = (4/3) * x – (4/3) + 1 = (4/3) * x – (1/3)

    Reply
  2. JSS says

    November 22, 2019 at 3:51 pm

    What if both scales start at 1 and have different maximums (say one scale has a max of 4 and the other 5)? Wouldnt this make an original 1 into a 0 in the new scale?

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Please note that, due to the large number of comments submitted, any questions on problems related to a personal study/project will not be answered. We suggest joining Statistically Speaking, where you have access to a private forum and more resources 24/7.

Primary Sidebar

This Month’s Statistically Speaking Live Training

  • January Member Training: A Gentle Introduction To Random Slopes In Multilevel Models

Upcoming Workshops

  • Logistic Regression for Binary, Ordinal, and Multinomial Outcomes (May 2021)
  • Introduction to Generalized Linear Mixed Models (May 2021)

Read Our Book



Data Analysis with SPSS
(4th Edition)

by Stephen Sweet and
Karen Grace-Martin

Statistical Resources by Topic

  • Fundamental Statistics
  • Effect Size Statistics, Power, and Sample Size Calculations
  • Analysis of Variance and Covariance
  • Linear Regression
  • Complex Surveys & Sampling
  • Count Regression Models
  • Logistic Regression
  • Missing Data
  • Mixed and Multilevel Models
  • Principal Component Analysis and Factor Analysis
  • Structural Equation Modeling
  • Survival Analysis and Event History Analysis
  • Data Analysis Practice and Skills
  • R
  • SPSS
  • Stata

Copyright © 2008–2021 The Analysis Factor, LLC. All rights reserved.
877-272-8096   Contact Us

The Analysis Factor uses cookies to ensure that we give you the best experience of our website. If you continue we assume that you consent to receive cookies on all websites from The Analysis Factor.
Continue Privacy Policy
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.