Converting scores to an index of 0-100
Locked
Converting scores to an index of 0-100
 
|
I have performance scores ranging from min of 43 to max of 258 - N=450.
I want to convert these to an index where min [43] = 0 and max [258] = 100 and the scores in between will range from >0 to <100. Any pointers how I can do this in SPSS? Regards -- Mark Webb +27 21 786 4379 +27 72 199 1000 Skype - webbmark [hidden email] ===================== 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 |
Re: Converting scores to an index of 0-100
|
|
Hi Mark
Compute newscore = 100 * (score - 43) / (258 - 43). Best regards, Jan -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Mark Webb Sent: Tuesday, August 25, 2009 12:43 PM To: [hidden email] Subject: Converting scores to an index of 0-100 I have performance scores ranging from min of 43 to max of 258 - N=450. I want to convert these to an index where min [43] = 0 and max [258] = 100 and the scores in between will range from >0 to <100. Any pointers how I can do this in SPSS? Regards -- Mark Webb +27 21 786 4379 +27 72 199 1000 Skype - webbmark [hidden email] ===================== 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 _____________ Tato zpráva a všechny připojené soubory jsou důvěrné a určené výlučně adresátovi(-ům). Jestliže nejste oprávněným adresátem, je zakázáno jakékoliv zveřejňování, zprostředkování nebo jiné použití těchto informací. Jestliže jste tento mail dostali neoprávněně, prosím, uvědomte odesilatele a smažte zprávu i přiložené soubory. Odesilatel nezodpovídá za jakékoliv chyby nebo opomenutí způsobené tímto přenosem. Jste si jisti, že opravdu potřebujete vytisknout tuto zprávu a/nebo její přílohy? Myslete na přírodu. This message and any attached files are confidential and intended solely for the addressee(s). Any publication, transmission or other use of the information by a person or entity other than the intended addressee is prohibited. If you receive this in error please contact the sender and delete the message as well as all attached documents. The sender does not accept liability for any errors or omissions as a result of the transmission. Are you sure that you really need a print version of this message and/or its attachments? Think about nature. -.- -- ===================== 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 |
Re: Converting scores to an index of 0-100
|
|
In reply to this post by Mark Webb-5
To convert the least value into zero you must detract 43 from all values.
Then you should divide every value by 258, so the maximum is 1 and the minimum is zero. Finally, multiply everything by 100. Syntax: COMPUTE NEWSCALE = (OLDSCALE - 43) * (100/258). Hector -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Mark Webb Sent: 25 August 2009 05:43 To: [hidden email] Subject: Converting scores to an index of 0-100 I have performance scores ranging from min of 43 to max of 258 - N=450. I want to convert these to an index where min [43] = 0 and max [258] = 100 and the scores in between will range from >0 to <100. Any pointers how I can do this in SPSS? Regards -- Mark Webb +27 21 786 4379 +27 72 199 1000 Skype - webbmark [hidden email] ===================== 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 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.409 / Virus Database: 270.13.64/2321 - Release Date: 08/24/09 12:55:00 ===================== 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 |
Re: Converting scores to an index of 0-100
|
|
|
Re: Converting scores to an index of 0-100
|
|
In reply to this post by Hector Maletta
I think you probably have a typo in the syntax - denominator should be 215 instead of 258, which would yield the same result as that submitted by Jan Spousta unless I misread it(?)
Test case: old scale value 258-43 we get 215*(100/258)=new scale value 83.xxx instead of 100; mike -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Hector Maletta Sent: Tuesday, August 25, 2009 2:26 PM To: [hidden email] Subject: Re: Converting scores to an index of 0-100 To convert the least value into zero you must detract 43 from all values. Then you should divide every value by 258, so the maximum is 1 and the minimum is zero. Finally, multiply everything by 100. Syntax: COMPUTE NEWSCALE = (OLDSCALE - 43) * (100/258). Hector -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Mark Webb Sent: 25 August 2009 05:43 To: [hidden email] Subject: Converting scores to an index of 0-100 I have performance scores ranging from min of 43 to max of 258 - N=450. I want to convert these to an index where min [43] = 0 and max [258] = 100 and the scores in between will range from >0 to <100. Any pointers how I can do this in SPSS? Regards -- Mark Webb +27 21 786 4379 +27 72 199 1000 Skype - webbmark [hidden email] ===================== 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 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.409 / Virus Database: 270.13.64/2321 - Release Date: 08/24/09 12:55:00 ===================== 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 |
Re: Converting scores to an index of 0-100
|
|
In reply to this post by King Douglas
King is right in one point: I divided by
258 (the original max score) whereas I should have divided by 215 (the new max
score after subtracting 43). But I do not see why King puts OLDSCALE-150.5
instead of -43. These are NOT z-scores, they are raw scores ranging from 43 to
258; all is needed is to set the minimum at zero (i.e. subtract 43) and the
maximum at 100 (i.e. multiply by 100 and divided by the maximum which is now
215). That’s all. The corrected formula is COMPUTE NEWSCALE = (OLDSCALE-43)*(100/215). There is no need to “preserve z-scores” or bother with old
and new midpoints linear transformations like this do not alter z scores. Or am I wrong? Hector From: King Douglas
No
virus found in this incoming message. |
Error Checking Pane in Syntax V17
|
|
In reply to this post by Spousta Jan
Hello,
Has anyone else had problems with the line numbers in the syntax error checking pane not corresponding to the line where the actual error occurs? For example, the following code lies on lines Line Command Information 3051 ADD value label The (ADD) VALUE LABELS command specifies an unknown variable name. The name will be ignored. However, when I go to line 3051 (by clicking or scrolling) I find this line of syntax OR Entity_ID=543188 I have copy and pasted my syntax file today from notepad into the syntax editor to check for errors, but am now having a difficult time finding where they fall within the syntax file. Any suggestions ? Thanks, Natalie Spring ===================== 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 |
| Free forum by Nabble | Edit this page |