SPSS Spreadsheets for Practise

This particular site is especially recommended in connection with practising statistical tests with sample data before carrying out these tests for real with your own data.

If you are in the position that you would like to get to grips with performing the relevant tests for your data prior to having collected it, One approach is to form some mock sample data.

You need to know at this stage, however, what format your final data is going to take and, if you are a research student, have agreed with your supervisor what variables you should collect data for, based on what makes sense in connection with the clinical content of your project and what is already known in the relevant published literature for your area.  Ideally, your supervisor will be an expert in your chosen field. They may therefore wish to advise you on relevant clinical variables over and above choices which are already implicit from the literature to date. Be sure to have all of this sorted out before requesting statistical advice.  

You may also find it helpful, however, to consider practising statistical procedures using spreadsheets that have already been designed for this purpose.

One useful source of such spreadsheets is The SPSS Survival Manual by Julie Pallant.

If you are registered with the University of Edinburgh, you can check on the availability of this book via the University’s library discovery system, DiscoverEd.

Here are some reference details:

  • Title: SPSS survival manual : a step by step guide to data analysis using IBM SPSS
  • Author: Julie. Pallant
  • Statement of responsibility: Julie Pallant
  • Publisher: Maidenhead, Berkshire, England : McGraw Hill
  • Publication Date: 2013
  • Edition: Fifth edition

To access the relevant spreadsheets, please refer to the SPSS Survival Manual Website and choose the button entitled Data files from the left-hand menu.

This will allow you to access named spreadsheets from the manual pertaining to examples from the relevant pages of the above book.  You can  then focus on the layout of data that you require and practise the procedures in these examples so as to confirm that you are able to generate the SPSS output illustrated and explained in the manual.

The SPSS  spreadsheets provided under the links below may be downloaded onto your computer for practising recommended statistical techniques. They may be used both independently and in conjunction with the examples and exercises in the book SPSS Analysis without Anguish by Sheridan Coakes and Clara Ong.

If you are registered with the University of Edinburgh, you can check on the availability of this book via the University’s library discovery system, DiscoverEd.

Here are some reference details:

  • Title: SPSS : analysis without anguish :version 18.0 for windows
  • Author: Sheridan J. Coakes and Clara Ong
  • Publisher: Milton, Qld. : John Wiley & Sons Australia
  • Publication Date: 2011
  • Edition: Version 18.0..
  • Format: viii, 279 pages : illustrations ; 30 cm..

In addition, should you wish to locate SPSS files suited to practising particular statistical procedures in SPSS, you ought to find the companion site for the book SPSS Analysis Without Anguish useful.

For your convenience the spreadsheets at this site are listed below with hyperlinks to the spreadsheets  attached to the corresponding filenames – just click!  Further, suggested procedures are listed alongside the filenames as an indication of statistical procedures for which the corresponding procedures might be used. Please note that you are free to adapt and use the spreadsheets for other statistical procedures too! Some examples are provided here by way of guidance but they are not intended to comprise an exhaustive list.

Spreadsheet(s)                                                 Statistical  procedure

1991 General Social Survey.sav         complete
Work3.sav
         Prac3.sav                        testing for Normality
Work4.sav         Prac4.sav                       calculating descriptive statistics
Work5.sav         Prac5.sav                      linear correlation
Work6.sav         Prac6.sav                     ‘t-tests (one-sample,                                                                                                           two- sample: independent and                                                                                      paired (related))’
Work7.sav         Prac7.sav                     One-way between groups ANOVA
Work8.sav         Prac8.sav                    As above
Work9.sav         Prac9.sav                    Two-way between groups ANOVA
Work10.sav      Prac10.sav                One-way within groups ANOVA
Work11.sav      Prac11.sav                Two-way within groups ANOVA
Work12.sav      Prac12.sav                trend analysis for one-way ANOVA
Work13.sav      Prac13.sav               Mixed factorial (split-plot) ANOVA
Work14.sav      Prac14.sav               ANCOVA
Work15.sav      Prac15.sav               Reliabilty analysis
Work16.sav      Prac16.sav               Factor analysis
Work17.sav      Prac17.sav               Multiple regression analysis
Work18.sav      Prac18.sav               MANOVA
Work19a.sav   Prac19a.sav             Analysis of non-parametric data
Work19b.sav   Prac19b.sav
Work19c.sav    Prac19c.sav
Work19d.sav   Prac19d.sav
Work19e.sav   Prac19e.sav
Work19f.sav    Prac19f.sav
Work19g.sav   Prac19g.sav
Work20a.sav   Prac20a.sav      Multiple response/dichotomy analysis
Work20b.sav  Prac20b.sav
Work21.sav     Prac21.sav         Multidimensional scaling

Allfiles.zip          Allfiles.zip

Dugong take home.sav
Dugong take home.doc

Homework exercise1.sav
Homework exercise2.sav
Homework exercise3.sav
Homework exercise4.sav
Research Scenario Student Version.sav
Allfiles.zip

 

 

CC BY-NC-ND 4.0 SPSS Spreadsheets for Practise by Margaret MacDougall is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

The WordPress site for supporting undergraduate medical student learning in statistics for short research projects

  • If you are visiting StatsforMedics for the first time, welcome!
  • Please take time to visit the page SCOPE OF SITE (see menu bar, below) for advice on how to make best use of the site and how to contact me.
  • University of Edinburgh undergraduate medical students: feel free to contact me if you need further assistance with your *curricular* activities.