Using the results of the survey I need to create the rating of governmental organizations. The experts in survey were estimating the organizations by giving each of them the number ranging between 1 and 10. The answers of those who gave no answer was indicated in dataset as 99. How to calculatethe weighted mean ignoring 99?
You don't actually have to use "select cases" (and depending on data layout maybe shouldn't, as it will exclude the entire case/line based on one missing value). Instead, under "variable view", find the column "missing values". In there, click "single missing values" and enter the code, here "99" in one of the three fields. SPSS will ignore the fields with "99" in that particular variable from then on.
You don't actually have to use "select cases" (and depending on data layout maybe shouldn't, as it will exclude the entire case/line based on one missing value). Instead, under "variable view", find the column "missing values". In there, click "single missing values" and enter the code, here "99" in one of the three fields. SPSS will ignore the fields with "99" in that particular variable from then on.
- Badges
- Science topic
- Similar topics
- Mathematical Sciences
- Statistics
- Statistical Software