Skip to main content

MBA 650: Research and Statistics: Home

MBA 650: Research and Statistics

This course concentrates on statistical analysis for managers, covering both descriptive and inferential analysis of data, as well as statistical reference techniques. The course covers common research tools and techniques, including qualitative and quantitative methodologies for addressing research problems in business.

Contact us:


Follow us on:


PASW Statistics 18

PASW Statistics 18 is available on all of the computers in both of the TU Library's computer labs: Lab 1 and Lab 2.
If you need additional help navigating the SPSS software, please fill out our Personal Research Instruction Request Form:

Step 1: Microsoft Excel

If you plan to import your Microsoft Excel data into PASW Statistics 18, make sure that your Excel file is properly formatted first!
The SPSS software will automatically read your variables if you allow it to.

The following survey data (which uses randomly-generated statistics) is based on a five-point Likert scale:

  • 1 = Strongly Agree
  • 2 = Agree
  • 3 = Neither Agree Nor Disagree
  • 4 = Disagree
  • 5 = Strongly Disagree

The survey questions for this sample dataset can be viewed below.

Step 2: Importing Microsoft Excel Data into SPSS

If I were to import the above data into SPSS exactly as it appears (by opening an existing data source), I would need to edit it before I could use it.

Start by removing the first column of data (participants) by right-clicking on that column and then selecting Clear from the drop-down menu.

Then remove the first row of data (variables) by right-clicking on that row and then selecting Clear from the drop-down menu.

Your dataset should now look like this.

And now you're ready to edit your variables!
Start by clicking on the Variable View tab in the bottom left-hand corner of the SPSS screen.
Then continue with this tutorial by clicking on the Variables link below.