In: Math
Hello! I was asked to use spss to find the percentage of people that are over 51 years old in a variable of people of different ages. Can someone tell me how to do this in spss? thanks!
Hello! I was asked to use spss to find the percentage of people that are over 51 years old in a variable of people of different ages. Can someone tell me how to do this in spss? thanks!
One easy method is run Analyze--- Descriptive statistics—Frequencies
Select the age variable and OK.
You will get the Frequencies table. In that look for the last column Cumulative percent.
Take the cumulative percentage value corresponding the age 51 ( or if 51 is not present the number smaller than 51).
The required percentage is (100 - cumulative percentage value corresponding the age 51 or below).
Other method is
Categories the age variable into two groups ≤51 and > 51. Then run the frequencies for the coded variable.
You can use
Transform recode in different variable menu for this.
SPSS command for this
RECODE age (MISSING=COPY) (LO THRU 51=1) (LO THRU HI=2) (ELSE=SYSMIS) INTO age.coded.
VARIABLE LABELS age.coded 'Age (coded)'.
VALUE LABELS age.coded 1 '<= 51.00' 2 '52.00+'.
After recoding you run Analyze--- Descriptive statistics—Frequencies for the new variable to get the required frequencies.