Fraction

[Joanna Targosz]

Hi All,

I need to create a fraction= number of optimistic people minus number of
pessimistic people from my survey.
I can do it in Excel but I'm sure there is a clever way to perform this
in SPSS.
Below is an example:

                Gender
        Total   Male    Female  Prefer no to say
        1074    540     519     15
        1074    540     519     15
        %       %       %       %
                                       
How optimistic or pessimistic are you about how Britain's overall
standing in the world will develop over the next 12 months?

Optimistic      68      68      68      80
Pessimistic     32      32      32      20
Fraction/Net optimistic 36      36      36      60


I am a new at this forum and this is my first request :-)

Hope this make sense.

Thank you in advance for your help!

Regards

Joanna Targosz



----------------------------------------------------------------------------

Disclaimer

This email and the information it contains are confidential and may be privileged, if you have received this email in error please notify us immediately. You should not copy it for any purpose, or disclose its contents to any other person. Internet communications are not secure and therefore YouGov does not accept legal responsibility for the contents of this message as it has been transmitted over a public network. If you suspect the message may have been intercepted or amended, please call the sender.

Any views or opinions are solely those of the author and do not necessarily represent those of YouGov plc unless specifically stated. This email and any files transmitted are confidential and intended solely for the use of the individual or entity to which they are addressed.

This message has been scanned for viruses by MailControl - www.mailcontrol.com

----------------------------------------------------------------------------

[King Douglas]

Hi, Joanna,

Which version of SPSS are you using?

Here's one (untested) way to accomplish what you want:

First, recode your OPTIMISM variable into two new variables (E.G., OPTPCT, PSMPCT) with opposite endpoints.  If your present values are, for instance, Optimistic = 1 and Pessimistic = 2:

DO IF OPTIMISM GE 1.
COMPUTE OPTPCT = 0.
COMPUTE PSMPCT = 0.
END IF.
IF OPTIMISM = 1 OPTPCT = 100.
IF OPTIMISM = 2 PSMPCT = 100.

VARIABLE LABELS
  OPTPCT 'Percent Optimistic'
  PSMPCT 'Percent Pessimistic'.

(The average score of each will represent percentages).

Now simply aggregate your two new variables and subtract one from the other.

COMPUTE NOBREAK = 1.

AGGREGATE OUTFILE = *
 /BREAK = NOBREAK
 /OPTPCT = MEAN(OPTPCT)
 /PSMPCT = MEAN(PSMPCT).

COMPUTE NETOPT = OPTPCT-PSMPCT.

VARIABLE LABELS
  NETOPT 'Net percentage optimistic'.

You can split your file by gender (or any other variable) to get net optimism scores for each, and you can add the new optimism scores back to your original data file, if desired.

Hope this helps,

King Douglas
American Airlines Customer Research





AGGREGATE

Joanna Targosz <[hidden email]> wrote: Hi All,

I need to create a fraction= number of optimistic people minus number of
pessimistic people from my survey.
I can do it in Excel but I'm sure there is a clever way to perform this
in SPSS.
Below is an example:

                Gender
        Total   Male    Female  Prefer no to say
        1074    540     519     15
        1074    540     519     15
        %       %       %       %

How optimistic or pessimistic are you about how Britain's overall
standing in the world will develop over the next 12 months?

Optimistic      68      68      68      80
Pessimistic     32      32      32      20
Fraction/Net optimistic 36      36      36      60


I am a new at this forum and this is my first request :-)

Hope this make sense.

Thank you in advance for your help!

Regards

Joanna Targosz



----------------------------------------------------------------------------

Disclaimer

This email and the information it contains are confidential and may be privileged, if you have received this email in error please notify us immediately. You should not copy it for any purpose, or disclose its contents to any other person. Internet communications are not secure and therefore YouGov does not accept legal responsibility for the contents of this message as it has been transmitted over a public network. If you suspect the message may have been intercepted or amended, please call the sender.

Any views or opinions are solely those of the author and do not necessarily represent those of YouGov plc unless specifically stated. This email and any files transmitted are confidential and intended solely for the use of the individual or entity to which they are addressed.

This message has been scanned for viruses by MailControl - www.mailcontrol.com

----------------------------------------------------------------------------