Wrong number of cases on frequency table

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Wrong number of cases on frequency table

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


Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Wrong number of cases on frequency table

Bruce Weaver
Administrator
In reply to this post by sgcorreia14
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
--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Wrong number of cases on frequency table

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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Wrong number of cases on frequency table

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


Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Wrong number of cases on frequency table

sgcorreia14
Hi Rick,

IT WORKED! THANK YOU EVER SO MUCH!

Sara
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Wrong number of cases on frequency table

Bruce Weaver
Administrator
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
--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Wrong number of cases on frequency table

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