I will explain my question with a simple hypothetical example.
I have a dataset with nodules of the thyroid gland, containing the next three categorical variables:
1. Scan. The value is either "cold" or "hot".
2. Size. The value is either "small" or "big".
3. Risk. The value is either "benign" or "cancer".
Now, I would like to combine the values of the first two variables, to create four new categories:
1. "cold" nodules that are "big"
2. "cold" nodules that are "small"
3. "hot" nodules that are "big"
4. "hot" nodules that are "small"
I want to do this in order to create a crosstab:
The columns would include the 4 new categories I created by combining the values of the two categorical variables "Scan" and "Size". The rows would include only "Risk" ("benign" or "cancer").
How could I do this in SPSS, starting with the original dataset?
Use excel instead, calculate all the expected values, rearrange all the data vertically in a row and subtract expected values from observed in a new row. In short, I will use the data in the picture to compute using excel and send the screen shots later
Elias De Meyst code the major groups of your variables following the screenshot below.
Valentine Joseph Owan Thank you very much for you answer! However, I am not sure that this is exactly what I am looking for.
I included a hypothetical crosstab with the kind of output I would like to get. I do know how the coding system works for the major groups of variables.
Okay if the contingency table is structured as the hypothesized one in the picture above, then i will recommend you use excel. However, how did you sum to get the values, what instrument did you use for data collection?
SPSS is better to crosstab with raw scores that are coded, it will prepare the contingency table to appear as the one in the picture by itself. Use the raw scores.
Send a sample of the instrument used
Valentine Joseph Owan, I used Excel. My dataset looks a bit like the one I added in the picture. The real one contains a lot more variables. I just need this is an example. Thanks!
Use excel instead, calculate all the expected values, rearrange all the data vertically in a row and subtract expected values from observed in a new row. In short, I will use the data in the picture to compute using excel and send the screen shots later
Follow these stages using excel and the data in the picture you sent above
- Badges
- Science topic
- Similar topics
- Mathematical Sciences
- Statistics
- Statistical Software
- SPSS