Hello, I am trying to run a t-test on differences in mental well-being in the last month (average of 14 sentences) between two groups, women I have 200 and men I have only 34 who answered on the questionnaire. when processing SPSS shows me that there are only 12 men, why is that? Frustrated from a whole day of trying to understand where the problem is and why 22 more people ( that I really need) are disappearing in the data analysis
Dear Ornat Turin
This result is common if there is an error in entering data and defining variables, If the data is incorrectly copied from Excel to the program, it is natural that the cases that the program sees as numbers on which the test can be applied will disappear.
Do not forget that your test requires quantitative data and a normal distribution. If these conditions are not met, the results are fundamentally incorrect.
If you have any other need for assistance, you can gladly ask me more questions to share the details that arise when working on the program.
Good luck
There are some problems that may occur if you have a Mac (especially if you performed an update recently), or don't have the most recent edition, but this doesn't sound like one of those issues (SPSS would typically just not open at all for you). If there is a problem with data entry, SPSS will remove the data during data analysis, so you'll want to double check variable and data view to make sure there is nothing amiss. SPSS is not intuitive, meaning it doesn't automatically know what the problem is and will thusly not counteract the problem. It will either remove problematic data or tell you there was an error (even if the latter occurs, it won't tell you what the error is).
If the file was originally created in an older version of SPSS or Excel, there might be a problem there, as well. I don't know of any work arounds for that, though. And once again, if that were the issue, it would most likely result in the data not being able to be opened in SPSS in the first place.
It shouldn't be automatically removing outliers or rows with missing data, although I'm sure you checked for missing data in the first place. Just in case, here is the tutorial on SPSS filter settings, so you can check on anything you may have done while setting up your data: https://www.spss-tutorials.com/spss-filter-tutorial/
Good luck!
- Badges
- Science topic
- Similar topics
- Mathematics