Hello, in this video i want to show you

how to compute a new variable in SPSS, my data set includes four variables the first two variables are nominal and they represent the names of the states, the first one is an abreviation of the state and the second one includes the full names of the state the third variable represents the number of registered nurses in each state and the fourth variable represents the number of nursing aids in each state now, what I’m interested in is to find out how many nursing aids are available for a certain number of registered nurses in each state so, I want to compute a ratio between the two variables to do that I have to go to the transformed menu, click on compute variable and in this area, here, I have to type the name of my new variable so i want to call my new variable ratio, I’m going to type ratio here in this area I have to tell SPSS how to compute my new variable or to give a formula for this variable. Now my formula is the number of registered nurses divided by the number of nursing aids so the first step is to select the variable, number of registered nurses from mylist of variables, this is a list of all variables in the data set, so I’m selecting the number of registered nurses and then click on this arrow now, as I mentioned before I want to divide this by the number of nursing aids, so I am selecting the sign for division from this set of symbols, so I click on division and then I select the variable number of nursing aids from the list of variables and click on the arrow so this is my formula, so for each state the ratio variable will be the number of registered nurses divided by the number of nursing aids, and then I click OK and I can see in my output window that this operation has been completed but I don’t see any other output to see my new variable I have to go to the data view and I can see now my Ratio variable, for instance for Alabama I can see that my ratio is 2.16 which means that one nursing aid is available for aproximately two registered nurses

## 3 Comments

## Ahmad Al-Tamimi

Is the value of the ' compute' variable updated if the original variables are changed ?

## Ola

how do i create a proxy variable? thanks

## Stefanie Duvouche

Hit me up with the ranch