# RMDA Tutorial1

Document Sample

```					Excel/SPSS Tutorial (1)

Research Methods & Data
Analysis
Excel basics
• Calculating means
• Calculating variance/standard
deviations
• Pivot tables
• Graphs
Open file
www.rdg.ac.uk/~aes02mm/Tutor.xls
• Split panels
Split panels
Calculating means
• Function:
AVERAGE(starting cell,final cell)

• Automatic fill in data bases based
Calculating variances/standard
deviation
• Functions (based on a random sample):
VAR(starting cell,final cell)
STDEV(starting cell,final cell)     n
1
s 
2
 ( xi  x )
n  1 i 1
2

• Functions (based on the population):
VARP(starting cell,final cell)
STDEVP(starting cell,final cell)
N
1
 2

N
 (x
i 1
i    )   2
Pivot tables
Choice of statistic(s)
Pivot tables
Histograms

• Calculating variance/standard
deviations
• Pivot tables
• Graphs
SPSS
• You can open an excel file directly
from SPSS
• However, SPSS files contain
variables
• Open the following file:
www.rdg.ac.uk/~aes02mm/Tutor.sav
SPSS basics
•   Opening SPSS files
•   Defining variables
•   Restructuring data
•   Saving data
•   The output window
•   Cross-tabulation
•   Graphs
Variable view
Data view
Case summaries
• Analyze / Report / Case
summaries
– Select target variable(s)
– Select grouping variable(s)
Variable(s) you are
interested in

Grouping
variables

Do not limit/display
cases
the statistics you
need
Output window
Categorising variables
• Transform/categorize variables
– Select variable
– Choose number of categories
Computing new variables
• Transform/Compute
– Choose expression
– Define “if” category
Define a
Name the new     numeric
variable       expression to
compute it

Define a condition
If you want to work with
‘stores’ as rows
• Data / Aggregate   Aggregating variable

Name the
new file
Frequency tables
• Analyze / Descriptive Statistics /
Frequencies
– Choose target variable(s)
Basic descriptive statistics
• Analyze / Descriptive Statistics /
Descriptives
– Choose target variables
– Choose statistics
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
Basic statistics and
confidence intervals
• Analyze / Descriptive Statistics /
Explore
– Choose variables
– Choose factor(s)
– Chose level of confidence
Graphs

• Graphs / Histogram

• Graphs / Pie or
• Graphs / Interactive / Pie

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 1 posted: 8/7/2012 language: English pages: 27
How are you planning on using Docstoc?