In this video I'd like to show you how
to export an SPSS file into a Microsoft
Excel file. And it's really quite simple
you just want to have your SPSS data
file open and then go to File and then
Export and then go ahead and select
Excel. So here you just want to select
where you want to save your file to, your
new excel file. And then here we'll use
the name, notice the name from SPSS by
default becomes the excel file name.
Notice the excel extension here. So this
will be an excel file, so let's go ahead and
click Save.
And then you want to go ahead and locate
where you have that file saved, and mine's
right here, so I'm going to go ahead and
open that. And then here's my excel file
and let's compare the two.
So notice it does get that name that we
saw earlier with the excel extension and
then notice how we have, I'm going to go
ahead and make a little more room here
for our variables, SAT, social support, and
college GPA, these agree with the variable
names that were in SPSS. And then see how
these are in the first row, whereas in 28 00:01:12,950 --> 00:01:17,390 SPSS they're above the first row, but in
Excel you can't have your variable names
up here, these are just going to be A, B,
and C. So Excel puts the variable name in
row 1. So let's look down here and we can
see that we have 36 rows of values and
the first row is for the variable names.
So 36-1, we have 35 rows of data, so let's
make sure that's the case in SPSS. Notice
how we have 35 rows of data here,
980 is the last value, we have a last
value of 980 here. And then moving up
here, just quickly, we have 1200, 62, and 3.45,
those agree.
Check one more to make sure:
990, 44, and 2.32.
OK so that's how you export an SPSS data
file into Microsoft Excel.
Thanks for watching.
Không có nhận xét nào:
Đăng nhận xét