SPSSX Discussion

converting 1-5 rating into 1-6 rating scale

Classic

List

Threaded

8 messages Options

ajay atluri

converting 1-5 rating into 1-6 rating scale

Hi Team,

I am working on SPSS 16 Base. I have 500 participants and 70
questions in the data. All these questions are of 1-5 point scale in
2007 data. But, 2009 data we have same set of participants and
questions but rating was changed from 1-5 scale rating to 1-6 rating
scale.

At this juncture, I would like to convert all 2007 data into 6 point
scale. To do this i have defined some formulae.

We need to convert 75% who has given the answer as 5 and 12% who have
given the answer as 4 into 6. And for getting number of responses for
5, I will be converting 5-5, 4-5 and 3-5 by considering the following
percentage of respondents 25%, 70% and 15% into 5. This list will go
on.

Does any one in the forum has done in a similar way? If so, please
share the syntax with me.

Thanks,
Atluri

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

DataMaestro

Re: converting 1-5 rating into 1-6 rating scale

I'm not a statistician, but this sounds like trouble.

Sure you can do this by conditionally selecting respondents based on a random number. However, you are arbitrarily assigning some "fence sitters" to a positive response and others to a negative response - that is just part of it.

Are you deriving a different assignment formula for each of the 70 scales?

Why not NOT recode your data and instead run significance across the years on the means after you factor up 2007's means by .833333...? And then be done with it.

I'd love to hear some stats' folks take on this as I have attempted this in the past on a limited number of scales.

George

--- On Tue, 5/26/09, ajay atluri <[hidden email]> wrote:

From: ajay atluri <[hidden email]>
Subject: converting 1-5 rating into 1-6 rating scale
To: [hidden email]
Date: Tuesday, May 26, 2009, 1:39 PM

Hi Team,

I am working on SPSS 16 Base. I have 500 participants and 70
questions in the data. All these questions are of 1-5 point scale in
2007 data. But, 2009 data we have same set of participants and
questions but rating was changed from 1-5 scale rating to 1-6 rating
scale.

At this juncture, I would like to convert all 2007 data into 6 point
scale. To do this i have defined some formulae.

We need to convert 75% who has given the answer as 5 and 12% who have
given the answer as 4 into 6. And for getting number of responses for
5, I will be converting 5-5, 4-5 and 3-5 by considering the following
percentage of respondents 25%, 70% and 15% into 5. This list will go
on.

Does any one in the forum has done in a similar way? If so, please
share the syntax with me.

Thanks,
Atluri

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@... (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

Guerrero, Rodrigo

Re: converting 1-5 rating into 1-6 rating scale

Can this data be converted to Z-scores and then analyzed?

Rodrigo A. Guerrero | Director Of Marketing Research and Analysis | The Scooter Store | 830.627.4317

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of George Musick
Sent: Tuesday, May 26, 2009 3:41 PM
To: [hidden email]
Subject: Re: converting 1-5 rating into 1-6 rating scale

I'm not a statistician, but this sounds like trouble.

Are you deriving a different assignment formula for each of the 70 scales?

Why not NOT recode your data and instead run significance across the years on the means after you factor up 2007's means by .833333...? And then be done with it.

I'd love to hear some stats' folks take on this as I have attempted this in the past on a limited number of scales.

George

--- On Tue, 5/26/09, ajay atluri <[hidden email]> wrote:

From: ajay atluri <[hidden email]>
Subject: converting 1-5 rating into 1-6 rating scale
To: [hidden email]
Date: Tuesday, May 26, 2009, 1:39 PM

Hi Team,

I am working on SPSS 16 Base. I have 500 participants and 70
questions in the data. All these questions are of 1-5 point scale in
2007 data. But, 2009 data we have same set of participants and
questions but rating was changed from 1-5 scale rating to 1-6 rating
scale.

At this juncture, I would like to convert all 2007 data into 6 point
scale. To do this i have defined some formulae.

We need to convert 75% who has given the answer as 5 and 12% who have
given the answer as 4 into 6. And for getting number of responses for
5, I will be converting 5-5, 4-5 and 3-5 by considering the following
percentage of respondents 25%, 70% and 15% into 5. This list will go
on.

Does any one in the forum has done in a similar way? If so, please
share the syntax with me.

Thanks,
Atluri

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@... (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

The information transmitted is intended only for the addressee(s) and may contain confidential or privileged material, or both. Any review, receipt, dissemination or other use of this information by non-addressees is prohibited. If you received this in error or are a non-addressee, please contact the sender and delete the transmitted information.

DataMaestro

Re: converting 1-5 rating into 1-6 rating scale

In reply to this post by ajay atluri

That might work - someone must have attempted this in the past.

--- On Tue, 5/26/09, Guerrero, Rodrigo <[hidden email]> wrote:

From: Guerrero, Rodrigo <[hidden email]>
Subject: RE: Re: converting 1-5 rating into 1-6 rating scale
To: "George Musick" <[hidden email]>, [hidden email]
Date: Tuesday, May 26, 2009, 4:52 PM

Can this data be converted to Z-scores and then analyzed?

RG

Rodrigo A. Guerrero | Director Of Marketing Research and Analysis | The Scooter Store | 830.627.4317

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of George Musick
Sent: Tuesday, May 26, 2009 3:41 PM
To: [hidden email]
Subject: Re: converting 1-5 rating into 1-6 rating scale

I'm not a statistician, but this sounds like trouble.

Sure you can do this by conditionally selecting respondents based on a random number. However, you are arbitrarily assigning some "fence sitters" to a positive response and others to a negative response - that is just part of it.

Are you deriving a different assignment formula for each of the 70 scales?

Why not NOT recode your data and instead run significance across the years on the means after you factor up 2007's means by .833333...? And then be done with it.

I'd love to hear some stats' folks take on this as I have attempted this in the past on a limited number of scales.

George

--- On Tue, 5/26/09, ajay atluri <[hidden email]> wrote:

From: ajay atluri <[hidden email]>
Subject: converting 1-5 rating into 1-6 rating scale
To: [hidden email]
Date: Tuesday, May 26, 2009, 1:39 PM

Hi Team,

I am working on SPSS 16 Base. I have 500 participants and 70
questions in the data. All these questions are of 1-5 point scale in
2007 data. But, 2009 data we have same set of participants and
questions but rating was changed from 1-5 scale rating to 1-6 rating
scale.

At this juncture, I would like to convert all 2007 data into 6 point
scale. To do this i have defined some formulae.

We need to convert 75% who has given the answer as 5 and 12% who have
given the answer as 4 into 6. And for getting number of responses for
5, I will be converting 5-5, 4-5 and 3-5 by considering the following
percentage of respondents 25%, 70% and 15% into 5. This list will go
on.

Does any one in the forum has done in a similar way? If so, please
share the syntax with me.

Thanks,
Atluri

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@... (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

The information transmitted is intended only for the addressee(s) and may contain confidential or privileged material, or both. Any review, receipt, dissemination or other use of this information by non-addressees is prohibited. If you received this in error or are a non-addressee, please contact the sender and delete the transmitted information.

King Douglas

Re: converting 1-5 rating into 1-6 rating scale

In reply to this post by ajay atluri

Ajay,

Is there any reason you need the new values to be integers? If you are going to aggregate the data and report means, then the converted scale should maintain the z-score for each case. The following formula does the trick for converting a 5-pt scale to a 6-pt scale. Scale end-points are maintained and the converted z-scores will match the original z-scores.

COMPUTE NEWSCORE = (OLDSCORE-3)*(5/4) + 3.5.

What the preceding does is subtract from each original score the original scale midpoint, then multiplies the result by (the range of the new scale divided by the range of the old scale), then adds to that result the midpoint of the new scale.

To check the accuracy of the conversions, run descriptives of old and new variables. Include the subcommand /SAVE in order save the z-scores of both the original and the converted scores. Any score that is an endpoint on the original scale should be an endpoint on the new scale.

DESCRIPTIVES VARIABLES = OLDSCORE NEWSCORE
/SAVE
/SORT.

Next, run descriptives of the saved z-score variables to check the high and low z-scores, which should be the same for the original and the converted scales.

DESCRIPTIVES VARIABLES = ZOLDSCORE ZNEWSCORE
/SORT.

--- On Tue, 5/26/09, ajay atluri <[hidden email]> wrote:

From: ajay atluri <[hidden email]>
Subject: converting 1-5 rating into 1-6 rating scale
To: [hidden email]
Date: Tuesday, May 26, 2009, 12:39 PM

Hi Team,

I am working on SPSS 16 Base. I have 500 participants and 70
questions in the data. All these questions are of 1-5 point scale in
2007 data. But, 2009 data we have same set of participants and
questions but rating was changed from 1-5 scale rating to 1-6 rating
scale.

At this juncture, I would like to convert all 2007 data into 6 point
scale. To do this i have defined some formulae.

We need to convert 75% who has given the answer as 5 and 12% who have
given the answer as 4 into 6. And for getting number of responses for
5, I will be converting 5-5, 4-5 and 3-5 by considering the following
percentage of respondents 25%, 70% and 15% into 5. This list will go
on.

Does any one in the forum has done in a similar way? If so, please
share the syntax with me.

Thanks,
Atluri

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@... (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

ViAnn Beadle

Re: converting 1-5 rating into 1-6 rating scale

Also I'd look at the frequencies for both samples. Odd scales tend to show larger hits for the middle point--which is frequently a proxy answer for "I don't know" or "I don't care". Even scales force the respondent to a make a positive or negative choice.

----- Original Message -----

From: [hidden email]

To: [hidden email]

Sent: Tuesday, May 26, 2009 3:05 PM

Subject: Re: converting 1-5 rating into 1-6 rating scale

Ajay,

Is there any reason you need the new values to be integers? If you are going to aggregate the data and report means, then the converted scale should maintain the z-score for each case. The following formula does the trick for converting a 5-pt scale to a 6-pt scale. Scale end-points are maintained and the converted z-scores will match the original z-scores.

COMPUTE NEWSCORE = (OLDSCORE-3)*(5/4) + 3.5.

What the preceding does is subtract from each original score the original scale midpoint, then multiplies the result by (the range of the new scale divided by the range of the old scale), then adds to that result the midpoint of the new scale.

To check the accuracy of the conversions, run descriptives of old and new variables. Include the subcommand /SAVE in order save the z-scores of both the original and the converted scores. Any score that is an endpoint on the original scale should be an endpoint on the new scale.

DESCRIPTIVES VARIABLES = OLDSCORE NEWSCORE
/SAVE
/SORT.

Next, run descriptives of the saved z-score variables to check the high and low z-scores, which should be the same for the original and the converted scales.

DESCRIPTIVES VARIABLES = ZOLDSCORE ZNEWSCORE
/SORT.

--- On Tue, 5/26/09, ajay atluri <[hidden email]> wrote:

From: ajay atluri <[hidden email]>
Subject: converting 1-5 rating into 1-6 rating scale
To: [hidden email]
Date: Tuesday, May 26, 2009, 12:39 PM

Hi Team,

I am working on SPSS 16 Base. I have 500 participants and 70
questions in the data. All these questions are of 1-5 point scale in
2007 data. But, 2009 data we have same set of participants and
questions but rating was changed from 1-5 scale rating to 1-6 rating
scale.

At this juncture, I would like to convert all 2007 data into 6 point
scale. To do this i have defined some formulae.

We need to convert 75% who has given the answer as 5 and 12% who have
given the answer as 4 into 6. And for getting number of responses for
5, I will be converting 5-5, 4-5 and 3-5 by considering the following
percentage of respondents 25%, 70% and 15% into 5. This list will go
on.

Does any one in the forum has done in a similar way? If so, please
share the syntax with me.

Thanks,
Atluri

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@... (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

Swank, Paul R

Re: converting 1-5 rating into 1-6 rating scale

In reply to this post by DataMaestro

If you are looking at data over time, I am not sure that using z scores will help you since the mean at each time will be the same.

Dr. Paul R. Swank,

Professor and Director of Research

Children's Learning Institute

University of Texas Health Science Center-Houston

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of George Musick
Sent: Tuesday, May 26, 2009 4:03 PM
To: [hidden email]
Subject: Re: converting 1-5 rating into 1-6 rating scale

That might work - someone must have attempted this in the past.

--- On Tue, 5/26/09, Guerrero, Rodrigo <[hidden email]> wrote:

From: Guerrero, Rodrigo <[hidden email]>
Subject: RE: Re: converting 1-5 rating into 1-6 rating scale
To: "George Musick" <[hidden email]>, [hidden email]
Date: Tuesday, May 26, 2009, 4:52 PM

Can this data be converted to Z-scores and then analyzed?

Rodrigo A. Guerrero | Director Of Marketing Research and Analysis | The Scooter Store | 830.627.4317

I'm not a statistician, but this sounds like trouble.

Are you deriving a different assignment formula for each of the 70 scales?

Why not NOT recode your data and instead run significance across the years on the means after you factor up 2007's means by .833333...? And then be done with it.

I'd love to hear some stats' folks take on this as I have attempted this in the past on a limited number of scales.

George

--- On Tue, 5/26/09, ajay atluri <[hidden email]> wrote:

From: ajay atluri <[hidden email]>
Subject: converting 1-5 rating into 1-6 rating scale
To: [hidden email]
Date: Tuesday, May 26, 2009, 1:39 PM

Hi Team,

I am working on SPSS 16 Base. I have 500 participants and 70
questions in the data. All these questions are of 1-5 point scale in
2007 data. But, 2009 data we have same set of participants and
questions but rating was changed from 1-5 scale rating to 1-6 rating
scale.

At this juncture, I would like to convert all 2007 data into 6 point
scale. To do this i have defined some formulae.

We need to convert 75% who has given the answer as 5 and 12% who have
given the answer as 4 into 6. And for getting number of responses for
5, I will be converting 5-5, 4-5 and 3-5 by considering the following
percentage of respondents 25%, 70% and 15% into 5. This list will go
on.

Does any one in the forum has done in a similar way? If so, please
share the syntax with me.

Thanks,
Atluri

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@... (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

ajay atluri

Re: converting 1-5 rating into 1-6 rating scale

In reply to this post by King Douglas

hi Team,

Thanks for helping me and make me understand to my problem .

My special thanks to King Douglas and George Musick.

But, as Douglas asked me to have the new values to be integers. I would say YES for this question. Then please suggest how to proceed on this particular scenario.

As my Z scores coming out to be correct with the formulae suggested by douglas, but my final scores which are calculcated on 5 point scale and 6 point scale are coming out to be very different. Where we have kept a buffer of + or -3% change in these values.

Thanks,

Ajay Atluri

On Wed, May 27, 2009 at 2:35 AM, King Douglas <[hidden email]> wrote:

Ajay,

Is there any reason you need the new values to be integers? If you are going to aggregate the data and report means, then the converted scale should maintain the z-score for each case. The following formula does the trick for converting a 5-pt scale to a 6-pt scale. Scale end-points are maintained and the converted z-scores will match the original z-scores.

COMPUTE NEWSCORE = (OLDSCORE-3)*(5/4) + 3.5.

What the preceding does is subtract from each original score the original scale midpoint, then multiplies the result by (the range of the new scale divided by the range of the old scale), then adds to that result the midpoint of the new scale.

To check the accuracy of the conversions, run descriptives of old and new variables. Include the subcommand /SAVE in order save the z-scores of both the original and the converted scores. Any score that is an endpoint on the original scale should be an endpoint on the new scale.

DESCRIPTIVES VARIABLES = OLDSCORE NEWSCORE
/SAVE
/SORT.

Next, run descriptives of the saved z-score variables to check the high and low z-scores, which should be the same for the original and the converted scales.

DESCRIPTIVES VARIABLES = ZOLDSCORE ZNEWSCORE
/SORT.

--- On Tue, 5/26/09, ajay atluri <[hidden email]> wrote:

From: ajay atluri <[hidden email]>
Subject: converting 1-5 rating into 1-6 rating scale
To: [hidden email]

Date: Tuesday, May 26, 2009, 12:39 PM

Hi Team,

I am working on SPSS 16 Base. I have 500 participants and 70
questions in the data. All these questions are of 1-5 point scale in
2007 data. But, 2009 data we have same set of participants and
questions but rating was changed from 1-5 scale rating to 1-6 rating
scale.

At this juncture, I would like to convert all 2007 data into 6 point
scale. To do this i have defined some formulae.

We need to convert 75% who has given the answer as 5 and 12% who have
given the answer as 4 into 6. And for getting number of responses for
5, I will be converting 5-5, 4-5 and 3-5 by considering the following
percentage of respondents 25%, 70% and 15% into 5. This list will go
on.

Does any one in the forum has done in a similar way? If so, please
share the syntax with me.

Thanks,
Atluri

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@... (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD