This document serves as an addition to the lecture summary of customer and marketing analytics from the academic year 2019/2020. It includes a detailed summary of the steps discussed in class for the program SPSS. The document is especially helpful for students not too familiar with SPSS.
Grade ach...
SPSS General Tasks
• Variable names must be unique, begin with a letter and cannot include full stops, blanks or
other characteristics.
• If your variable has decimal places, change this to suit your needs.
• Label column allows you to provide a longer description for your variable which will be used in
the output.
• Values column allows you define the meaning of the values you have used to code your
variables.
• SPSS will recognize any blank cell as missing data. Sometimes researchers assign specific values
to indicate missing values for their data.
• Measure column refers to the level of measurement of each of your variables. The default is
Scale (interval/ratio level of measurement). Choose Nominal for categorical data, Ordinal if your
data involve rankings.
Lecture 2: Basic Data Analytics
• Screen dataset: Investigate quality of data
o Errors, missing values, inconsistencies
• Explore and analyze the data:
o Describe and summarize data: A complete run-down analysis of all the variables in
your dataset one-at-a-time (univariate statistics)
o Inferential analysis: Learning about “the world” (univariate statistics)
o Differential analysis (bivariate statistics)
o Associative analysis (bivariate statistics)
Taste Evaluations of Beer Brands - Findings Allison & Uhl (1964)
• Beer drinkers could not distinguish taste differences among beers from unlabeled bottles
• Brand label increases evaluation of beer: increase differs per brand
Dataset: Taste evaluations (Beer.sav)
• Gender (female/male)
• Age (open ended question)
• Household Size (open ended question)
• Region (A’dam, R’dam, Utrecht/West/North/East/South)
• Social Class (A/BB/BO/C, D)
• Unbranded evaluation of beer A & B (10-point scale, 1 = poor; 10 = excellent)
• Branded evaluation of beer A & B (10-point scale, 1 = poor; 10 = excellent)
Switch between Data View (shows all data) and Variable View (shows
details of the variables/columns)
Data File >Variable View*
1
, Variable View
Define Name (no space etc.)
Shown in case of e.g. !Always define
Numbers of decimal
reverse coding. measurement
places shown Could define
level!
Further Description missing values
1. Screening the data set
1.1. Check for missing data
• In long surveys, participants accidentally or deliberately miss out questions
• Responses other than original scale (e.g., ‘don’t know’, ‘not applicable’ )
• Survey flow logic
Example:
Any response other than the original scale (e.g. 1-5) should be coded as missing in “missing” column
in the variable view.
2
, The “missing” values will be shown as dots
in the dataset.
Dealing with missing data
▪ Is the missing data ignorable?
- If they are part of the research design, YES. Otherwise, NO and you have the
following options:
▪ Assign missing values:
- Calculating replacement values (e.g., mean/mode substitution)
- Delete missing values:
Options button in the SPSS statistical procedures offers you choices
- Exclude cases listwise: If a person has a missing value for any variable, then they are
excluded from the whole analysis.
- Exclude cases pairwise: A person’s data is excluded only for analyses for which she
has missing data.
1.2. Find ´strange codes´ and errors (visual if manageable)
Consistency checks (out of range, logically inconsistent, extreme values)
In most cases no out of range, illogically inconsistent, extreme values (check especially open ended
questions – age and household size)
1.3. Screening data with SPSS via analyzing frequencies, and plots (scatterplot, boxplot)
1.4. Reverse coding (e.g. reversing negatively worded items)
• Social Class (A/BB/BO/C, D): coded from highest to lowest 1=A (highest), 2=BB, 3=BO, 4=C or D
(lowest)
• Reverse coding can be easily done in SPSS:
Transform > Recode > Into Different Variable> pull variable in variable box > Old and New Values
> define old and new value > add > Continue > Define Output Variable Name and Label > OK (alte
Variable evtl. Löschen)
3
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller danobasch96. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $6.94. You're not tied to anything after your purchase.
