<< Chapter < Page Chapter >> Page >

This chapter is published by NCPEA Press and is presented as an NCPEA/Connexions publication "print on demand book." Each chapter has been peer-reviewed, accepted, and endorsed by the National Council of Professors of Educational Administration (NCPEA) as a significant contribution to the scholarship and practice of education administration.

    About the Authors

  • John R. Slate is a Professor at Sam Houston State University where he teaches Basic and Advanced Statistics courses, as well as professional writing, to doctoral students in Educational Leadership and Counseling. His research interests lie in the use of educational databases, both state and national, to reform school practices. To date, he has chaired and/or served over 100 doctoral student dissertation committees. Recently, Dr. Slate created a website ( Writing and Statistical Help ) to assist students and faculty with both statistical assistance and in editing/writing their dissertations/theses and manuscripts.
  • Ana Rojas-LeBouef is a Literacy Specialist at the Reading Center at Sam Houston State University where she teaches developmental reading courses. Dr. LeBoeuf recently completed her doctoral degree in Reading, where she conducted a 16-year analysis of Texas statewide data regarding the achievement gap. Her research interests lie in examining the inequities in achievement among ethnic groups. Dr. Rojas-LeBouef also assists students and faculty in their writing and statistical needs on the Writing and Statistical Help website.

These procedures are to be followed when you have data already entered into an Excel file. In this chapter, you will be provided with steps and screenshots on how to convert the data from an Excel file into an SPSS data file. Open up your SPSS program and this screen will appear. Click on Cancel.

Your screen will now look like this.

The Excel file we will be converting for this example looks like the following:

In this excel file are three variables: AveragedWritingScore, Gone, and Gtwo. All three are numeric variables. The first row contains the variable names. Rows 2 through 14 contain the data for the variables.

Prior to the next steps, make sure that the Excel file that you intend to convert into SPSS is not open. If it is open and in use, SPSS will not be able to convert the file.

Once you are back in the SPSS data view window,

√ Click on File

√ Click on Open

√ Click on Data

A screen similar to the one below will open up on your computer. You need to locate where your Excel file is located. First, you will need to change the Files of type below.

Change from SPSS statistics (*.sav) to Excel (*.xls). Then find where the file is located and its name.

In the case of this example, the Excel file was located on the Desktop and is titled, Practice Excel File.xls. Then click on Open.

After clicking on open, the screen below will appear. For an Excel file to be converted properly into SPSS, the first row in the Excel file should be the names of the variables. All of the other rows in the Excel file should be the data. If you use more than one row to describe your variables, you will not be able to convert your Excel file into SPSS using these steps.

Once this screen has appeared, click on OK.

You should then be sent to the Output window.

Click on the SPSS data button below to get back to your SPSS screen.

Clicking on the SPSS data icon as depicted above should take you to the Data View screen. In this case, three variables were in the Excel data file: AveragedWritingScore, Gone, and Gtwo. These three variables were directly converted from the Excel file into a SPSS datafile.

Now we need to make sure that the variables are correctly identified and labeled in this SPSS dataset. Click on Variable View.

In the case of our example, the screen looks like the following:

All three of the variables have been correctly identified as numeric. The number of decimals needs to be increased to 2, not 1 as shown above.

To change the number of decimal places from 1 to 2, click on one of the decimal cells. In the screen below, the decimal cell for the first row has been clicked on. Once clicked an up and a down arrow will appear.

We need to increase the number of decimal places so we will click on the up arrow.

Clicking one time on the up arrow will change the number of decimals from 1 to 2.

Now we will do the same for row 2 and for row 3.

Viewing the screen below will show you that all three variables now have 2 decimal places.

Prior to conducting any statistical analyses, we recommend that you type in identifying information in the Label column for each variable. The information you type in the Label column will be the information printed out in the SPSS output and will make it easier to interpret.

We have converted our Excel file into a SPSS dataset. Please save it prior to conducting any statistical analyses.

√ Click on File

√ Click on Save

Give it a name of your choosing and save it in a location that you will remember later.

Questions & Answers

Application of nanotechnology in medicine
what is variations in raman spectra for nanomaterials
Jyoti Reply
I only see partial conversation and what's the question here!
Crow Reply
what about nanotechnology for water purification
RAW Reply
please someone correct me if I'm wrong but I think one can use nanoparticles, specially silver nanoparticles for water treatment.
yes that's correct
I think
what is the stm
Brian Reply
is there industrial application of fullrenes. What is the method to prepare fullrene on large scale.?
industrial application...? mmm I think on the medical side as drug carrier, but you should go deeper on your research, I may be wrong
How we are making nano material?
what is a peer
What is meant by 'nano scale'?
What is STMs full form?
scanning tunneling microscope
how nano science is used for hydrophobicity
Do u think that Graphene and Fullrene fiber can be used to make Air Plane body structure the lightest and strongest. Rafiq
what is differents between GO and RGO?
what is simplest way to understand the applications of nano robots used to detect the cancer affected cell of human body.? How this robot is carried to required site of body cell.? what will be the carrier material and how can be detected that correct delivery of drug is done Rafiq
analytical skills graphene is prepared to kill any type viruses .
what is Nano technology ?
Bob Reply
write examples of Nano molecule?
The nanotechnology is as new science, to scale nanometric
nanotechnology is the study, desing, synthesis, manipulation and application of materials and functional systems through control of matter at nanoscale
Is there any normative that regulates the use of silver nanoparticles?
Damian Reply
what king of growth are you checking .?
What fields keep nano created devices from performing or assimulating ? Magnetic fields ? Are do they assimilate ?
Stoney Reply
why we need to study biomolecules, molecular biology in nanotechnology?
Adin Reply
yes I'm doing my masters in nanotechnology, we are being studying all these domains as well..
what school?
biomolecules are e building blocks of every organics and inorganic materials.
anyone know any internet site where one can find nanotechnology papers?
Damian Reply
sciencedirect big data base
Introduction about quantum dots in nanotechnology
Praveena Reply
what does nano mean?
Anassong Reply
nano basically means 10^(-9). nanometer is a unit to measure length.
Got questions? Join the online conversation and get instant answers!
Jobilize.com Reply

Get the best Algebra and trigonometry course in your pocket!

Source:  OpenStax, Calculating advanced statistics. OpenStax CNX. Aug 18, 2011 Download for free at http://cnx.org/content/col11346/1.1
Google Play and the Google Play logo are trademarks of Google Inc.

Notification Switch

Would you like to follow the 'Calculating advanced statistics' conversation and receive update notifications?