and then Frequencies and then go ahead and move gender and ethnicity over and
then the default for Statistics
there are none here and for now we'll just leave it as is
we'll just go ahead and get Display frequency tables so click OK and then we
have our output window that opens and we can see here that we have one male, two
females for total of three and it says missing system 2 and I'll show you
about that in a minute and then for ethnicity we have one Caucasian, one
Hispanic, one Other and we see this missing 2 again.
This means that we don't have for some reason two of our ethnicities are not
reported.
Let's try and figure out what was going on there. So I'll go back to my Data
Editor window.
Well if you recall a minute ago I entered 004 and 005 right
and I said let's go ahead and delete those. Well if you notice here it's kind
of hard to see but there's little periods here. When I deleted these values
SPSS still kept these two rows active in a sense
notice that 4 and 5 here are in boldface type whereas these are
grayed out so SPSS is treating these as if we have two observations here and
there just calling those missing.
Now we can get rid of that very easily if we just select and drag on these two
rows on the row headings here which is what these are called right click select
Clear now notice the periods are gone.
Let's go back and rerun our Frequencies so Analyze, Descriptive Statistics,
Frequencies and then just click OK and then now notice
do you see the missing anymore it's not there right?
That removed it and that was the reason why it was there in the first place
because we entered those ID numbers deleted them but the rows were still
active from the perspective of SPSS so it interpreted those two rows as missing.
But now that's gone.
And notice here one other thing we have male and female not 1 and 2.
That's another benefit of creating these Value Labels here. Behind the scenes SPSS
displays or knows that are 1 is male and 2 is female.
So when we run our analysis instead of having a 1 here we have male instead of
2 we have female and the same thing with ethnicity and that really helps
when you're interpreting your results especially if you go back to the data
after some time.
It's easy to forget who was a 1 and who was a 2,
for example, so by coding males 1 females 2
we always have that memory in our data file so we don't have to try and go back
and figure out who was who.
OK one last analysis go to Analyze, Descriptive Statistics and then this
time choose descriptives. Let's go to move age and all the satisfaction with life
variables over and if you're curious I grabbed all those by clicking on age
pressing and holding the Shift key and then clicking on the last value and that
grabs them all at once. It's kind of nice.
It saves us a little bit of time. So then move that over
click on Options we get the Mean or the arithmetic average, Standard deviation,
Minimum, and Maximum by default.
We'll go ahead and leave those on that's fine so click continue and then OK and
then here we can see the mean for age we have a mean age of 26 with a minimum of
21 and a maximum of 32
and then we see our satisfaction with life values the smallest was 3 for
one, two, and three and 4 for four and five and the largest was 7 for all of them
and then you can see the means here as well and the standard deviations.
Alright so that's about it for entering and creating a data file from questionnaire
or survey data in SPSS. Thanks for watching.