Wrong number of cases on frequency table

[sgcorreia14]

Dear all,

I am really new to SPSS and I'm using PASW Statistics 18. I am only doing simple frequency analysis to start with, but even here I'm having trouble. For some reason the number of cases on the frequency tables does not match the actual number of cases in my data. I have already double checked that there are no extra live cells in my Data View. Can you suggest any other possibilities as to why I'm getting N = 138 even though there are only 100 cases in my data?

Thank you in advance!
Sara

[Rick Oliver-3]

Are both the Valid N and Total N 138?

Are the data weighted by a weight variable?

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]



From:        sgcorreia14 <[hidden email]>
To:        [hidden email],
Date:        12/05/2012 09:11 AM
Subject:        Wrong number of cases on frequency table
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Dear all,

I am really new to SPSS and I'm using PASW Statistics 18. I am only doing
simple frequency analysis to start with, but even here I'm having trouble.
For some reason the number of cases on the frequency tables does not match
the actual number of cases in my data. I have already double checked that
there are no extra live cells in my Data View. Can you suggest any other
possibilities as to why I'm getting N = 138 even though there are only 100
cases in my data?

Thank you in advance!
Sara



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Wrong-number-of-cases-on-frequency-table-tp5716680.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Bruce Weaver]

Have you used the WEIGHT command, by any chance (DATA - WEIGHT CASES in the menus)?  

sgcorreia14 wrote

Dear all,

I am really new to SPSS and I'm using PASW Statistics 18. I am only doing simple frequency analysis to start with, but even here I'm having trouble. For some reason the number of cases on the frequency tables does not match the actual number of cases in my data. I have already double checked that there are no extra live cells in my Data View. Can you suggest any other possibilities as to why I'm getting N = 138 even though there are only 100 cases in my data?

Thank you in advance!
Sara

[sgcorreia14]

Hi Bruce & Rick,

Thank you for your replies. The Total N is the same as the Valid N. As to the weighting, I have not run a command like that; when i follow the menu the option ticked is "Do not weight cases" and it tells me that the current status is "data weighted by status".

Many thanks,
Sara

[Rick Oliver-3]

If "Weight on" appears in the status bar of the Data Editor, then the data file is currently weighted -- but the fact that the dialog indicates the current selection is "Do not weight cases" is a bit odd.

Weight conditions are saved with the data; so weighting is on every time you re-open a data file until you explicitly turn it off. Try running this command in a syntax window: WEIGHT OFF.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]



From:        sgcorreia14 <[hidden email]>
To:        [hidden email],
Date:        12/05/2012 09:48 AM
Subject:        Re: Wrong number of cases on frequency table
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Hi Bruce & Rick,

Thank you for your replies. The Total N is the same as the Valid N. As to
the weighting, I have not run a command like that; when i follow the menu
the option ticked is "Do not weight cases" and it tells me that the current
status is "data weighted by status".

Many thanks,
Sara



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Wrong-number-of-cases-on-frequency-table-tp5716680p5716685.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[sgcorreia14]

Hi Rick,

IT WORKED! THANK YOU EVER SO MUCH!

Sara

[Bruce Weaver]

If there was an annual award for the post expressing the most delight, I think Sara would be a strong contender.  ;-)

sgcorreia14 wrote

Hi Rick,

IT WORKED! THANK YOU EVER SO MUCH!

Sara

[Omotayo Muritala]

You still have to click OK option, even when the current status is 'Do not weight cases'