Data Analysis- Details – Quantitative

Data Analysis

Quantitative Data Analysis

How is your knowledge of statistics? Try this quick test.

A good summary at (Miller & Salkind, 2002, Part 6)

The main types of analysis you will need are:

Description

• Frequency Count -Tally
• Central Tendency – Mean, Median, Mode
• Dispersion – Range, Standard Deviation, IQR

Inference

• Exploring Relationships
  • Correlation – Pearson or Spearman
  • Regression
• Comparing Groups
  • t-Test or Mann-Whitney U
  • ANOVA or Kruskal-Wallis

Analysing quantitative data – mainly from surveys – Analysing Quantitative Data. (and Dörnyei, 2007, Section 9)

Analysing Quantitative Data: Introduction to Statistics

• • 1a. Analysing Quantitative Data 1: Introduction and Descriptive Statistics – Video
  • 1b. Analysing Quantitative Data 2: Inferential Statistics – Exploring Relationships – Video
  • 1c. Analysing Quantitative Data 3: Inferential Statistics – Comparing Groups – Video

PowerPoint Slides for 1a, 1b & 1c

Quick Summary

You can do the analysis with either:

MS Excel

• • 2. Microsoft Excel: Introduction – Video – PowerPoints – Summary
  • 3. Factor Analysis – PowerPoint Slides
  • 4. Cronbach’s Alpha – PowerPoint Slides

OR

IBM SPSS Statistics

10. IBM SPSS Statistics: Introduction – Video – PowerPoints– Summary – IBM Brief Guide to SPSS – StatsGuru

• • with 11. Effect Size – Video, PowerPoints
  • with 12. Confidence Intervals – Video – PowerPoints
  • 13. SPSS Statistics – Assumptions – PowerPoint Slides – Video
  • 14. Multiple Regression – Video – PowerPoints
  • 15. Factor Analysis – Video – PowerPoints
  • 16. Cluster Analysis – Video – PowerPoints
  • 17. Path Analysis with IBM SPSS AMOS – Video – PowerPoints
  • 18. Confirmatory Factor Analysis (CFA) with IBM SPSS AMOS – Video – PowerPoints
  • 19. Structural Equation Modelling (SEM) with SPSS AMOS – Video – PowerPoints
  • 20. Scale Development with SPSS-  Video, PowerPoint Slides

OR

JASP

• • 30. JASP Statistics – Introduction – Video – PowerPoints
    • 31. JASP Statistics – Assumptions  – PowerPoint Slides – Video
    • with 32. Effect Size – Video, Power Point Slides
    • with 33. Confidence Intervals – Video – Power Point Slides
  • 34. Factor Analysis with JASP – Video – PowerPoint Slides
  • 35. Scale Development with JASP –  Video, PowerPoint Slides

OR

R

• • 40. R. Introduction to R – Video – Notes – R Source Code
  • 41. Doing Statistical Analysis with R – Video – Notes – PowerPoints– R Source Code
    • with 42. Effect Size – Video – PowerPoints – R Source Code
    • with 43. Confidence Intervals – Video – PowerPoints – R Source Code
    • 44. Factor Analysis with R – Video – PowerPoints – R Source Code
    • 45. Cluster Analysis with R – Video – PowerPoints – R Source Code

Excel will be quite familiar to most people, and it is good for simple tasks and charts. However, SPSS is much easier in the long run, as long as you have time to learn how to use it .

• • 50. Importing Excel Sheets into SPSS – Video

For more info:

• • 60. Analysing Survey Data with SPSS 1 – Video – Summary
  • 61. Analysing Survey Data with SPSS 2 – Video – Summary
    • 62 Converting a Continuous Variable into a Categorical Variable – Video
    • 63 Transforming Variables – Video – Summary
  • 64. Analysing Survey Data with Excel 1 – Video – Summary
  • 65. Analysing Survey Data with Excel 2 – Video
  • 66. Analysing Survey Data with R 1 – Video – PowerPoints – R Source Code
  • 67. Analysing Survey Data with R 2 – Video – PowerPoints – R Source Code
  • 68. Analysing Survey Data with JASP 1 – Video – Summary
  • 69. Analysing Survey Data with JASP 2 – Video – Summary

for constructing and analysing Likert Scales.

If you want to learn SPSS, this guide – produced by University of Hertfordshire Statistical Services & Consultancy Unit – is very useful. IBM also has some guides here. This is their brief guide – PDF.

IBM SPSS Statistics is available on the PCs in most university libraries and is sometimes available to install on your own computer.

If you use Qualtrics, you can do some simple statistical analysis with Stats IQ.

70. Statistical Analysis with Stats IQ – Video – Stats IQ Guide