ExcelSPSS Tutorial 1

1
Excel/SPSS Tutorial (1)

• Research Methods Data Analysis

2
Excel basics

• Calculating means
• Calculating variance/standard deviations
• Pivot tables
• Graphs

3
Open file

• Download the file
• www.rdg.ac.uk/aes02mm/Tutor.xls
• Split panels

4
Split panels
5
Calculating means

• Function
• AVERAGE(starting cell,final cell)
• Automatic fill in data bases based on adjacent
  cells

6
(No Transcript)
7
Calculating variances/standard deviation

• Functions (based on a random sample)
• VAR(starting cell,final cell)
• STDEV(starting cell,final cell)
• Functions (based on the population)
• VARP(starting cell,final cell)
• STDEVP(starting cell,final cell)

8
Pivot tables
9
Choice of statistic(s)
10
Pivot tables
11
Histograms

• Calculating variance/standard deviations
• Pivot tables
• Graphs

12
SPSS

• You can open an excel file directly from SPSS
• However, SPSS files contain additional
  information on the variables
• Open the following file
• www.rdg.ac.uk/aes02mm/Tutor.sav

13
SPSS basics

• Opening SPSS files
• Defining variables
• Restructuring data
• Saving data
• The output window
• Cross-tabulation
• Graphs

14
Variable view
15
Data view
16
Case summaries

• Analyze / Report / Case summaries
• Select target variable(s)
• Select grouping variable(s)
• Include additional statistics

17
Variable(s) you are interested in
Grouping variables
Do not limit/display cases
Click here to choose the statistics you need
18
Output window
19
Categorising variables

• Transform/categorize variables
• Select variable
• Choose number of categories

20
Computing new variables

• Transform/Compute
• Choose expression
• Define if category

21
Define a numeric expression to compute it
Name the new variable

• Define a condition

22
If you want to work with stores as rows

• Data / Aggregate

Aggregating variable
Name the new file
23
Frequency tables

• Analyze / Descriptive Statistics / Frequencies
• Choose target variable(s)

24
Basic descriptive statistics

• Analyze / Descriptive Statistics / Descriptives
• Choose target variables
• Choose statistics

25
Tables

• Analyze / Custom Tables / General Tables
• Choose variables to be represented
• Tick summary option
• Choose summary statistic
• Choose layer
• Example average amount spent for each store size
  by sex

26
Basic statistics and confidence intervals

• Analyze / Descriptive Statistics / Explore
• Choose variables
• Choose factor(s)
• Chose level of confidence

27
Graphs

• Graphs / Histogram
• Graphs / Pie or
• Graphs / Interactive / Pie