changing the range in an index

[raw]

hi, I calculated an index, which is simply the mean of some columns, obtained with the count function.

The actual range is 2-12, but I would like to adapt the range to 0-10.

So it's not a recode, but I guess I should apply a mathematical function or formula.

Do you have some suggestions?

Thanks
 

[Andy W]

Are you perhaps overthinking it? Doesn't simply subtracting by 2 give you want you want....

If that does not work if you give an example of what you have now and what you want in the end it would be more clear.

[David Marso]

You need to provide EXACT specifics of what you did if you expect any reasonable response.
Your 'mean of some columns, obtained with the count function' is a rather imprecise statement.

raw wrote

hi, I calculated an index, which is simply the mean of some columns, obtained with the count function.

The actual range is 2-12, but I would like to adapt the range to 0-10.

So it's not a recode, but I guess I should apply a mathematical function or formula.

Do you have some suggestions?

Thanks

[Maguin, Eugene]

Ok, why don't you just subtract 2 from the value of that variable?
Gene Maguin

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of raw
Sent: Thursday, December 17, 2015 4:16 AM
To: [hidden email]
Subject: changing the range in an index

hi, I calculated an index, which is simply the mean of some columns, obtained with the count function.

The actual range is 2-12, but I would like to adapt the range to 0-10.

So it's not a recode, but I guess I should apply a mathematical function or formula.

Do you have some suggestions?

Thanks
 



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/changing-the-range-in-an-index-tp5731138.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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

=====================
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

[John F Hall]

Compute x2 = mean(x)-2.

. . but why not compute an actual score from 12 items (-2) then play with
it?

Check out
http://surveyresearch.weebly.com/351-introduction-to-count-and-compute.html 

John F Hall (Mr)
[Retired academic survey researcher]

Email:   [hidden email]  
Website: www.surveyresearch.weebly.com  
SPSS start page:  www.surveyresearch.weebly.com/1-survey-analysis-workshop




-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of raw
Sent: 17 December 2015 10:16
To: [hidden email]
Subject: changing the range in an index

hi, I calculated an index, which is simply the mean of some columns,
obtained with the count function.

The actual range is 2-12, but I would like to adapt the range to 0-10.

So it's not a recode, but I guess I should apply a mathematical function or
formula.

Do you have some suggestions?

Thanks
 



--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/changing-the-range-in-an-index
-tp5731138.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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

=====================
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

[David Marso]

I don't believe enough information has been provided by OP to consider this a 'reasonable' suggestion ;-)
Ditto to Andy and John.

Maguin, Eugene wrote

Ok, why don't you just subtract 2 from the value of that variable?
Gene Maguin

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of raw
Sent: Thursday, December 17, 2015 4:16 AM
To: [hidden email]
Subject: changing the range in an index

hi, I calculated an index, which is simply the mean of some columns, obtained with the count function.

The actual range is 2-12, but I would like to adapt the range to 0-10.

So it's not a recode, but I guess I should apply a mathematical function or formula.

Do you have some suggestions?

Thanks
 



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/changing-the-range-in-an-index-tp5731138.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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

=====================
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

[raw]

Thanks to all, the original range was only a case, but it can change, so I figured out that it’s more a simple mathematical issue, after investigating I came with the steps to adapt every index to a desidered range

Normalized index= (your original_index – MIN)/( MAX  - MIN)

You obtain values between [0;1]

Adapted to a range= normalized index (delta – gamma) + gamma

Delta: max value of desidered index, e.g. 10
Gamma: min value of desidered index, e.g. 0

Hope this could help someone, may be it was not an appropriate 3d for SPSS, but I was just wandering if there were a specific function...