QDA2 · Bonus case file · Prepared for Simon Nicholas Hill
THE SOPRANOS
QDA2 LAB
“Never rat on your friends. Always check your measurement level.”
Bada Bing, Bivariate Analysis
Simon, you said you were watching The Sopranos.
Unfortunately, this means The Sopranos is now homework.
Your task is to determine whether six seasons of organized crime can survive quantitative analysis.
No prior knowledge of New Jersey waste management is required.
StatusOptional practice. Not graded.
CoversEverything in QDA2 so far, from measurement levels to t-tests.
ProgressSaved in this browser only. No login.
/bonus/sopranosThe dataset
Read this first
Synthetic teaching dataset inspired by The Sopranos. Values are created for statistical practice and are not factual episode statistics.
74 synthetic episode observations across 6 seasons. Episode labels are generic (S1E01 …) and do not refer to real episodes; the number of episodes per season is also synthetic.
0
Public facts about the episodes (titles, air dates, runtimes, ratings). None are used in this version: they could not be checked reliably when the lab was built, and invented ‘facts’ are worse than none.
0
Counts a person would code by watching the episodes or reading licensed transcripts. None are used in this version.
24
Generated by a seeded script so that the exercises have realistic structure. Every variable in this dataset is synthetic.
Measurement levels, then roles
Classify the variables
Classify variable
season (1, 2, 3, 4, 5, 6). What is its measurement level?
Measurement level ≠ variable role
In each research question, which is X and which is Y?
Identify X and Y
Research question: “Are later seasons more violent than earlier seasons?” Which is X and which is Y?
How peaceful is The Sopranos, statistically speaking?
Never rat on your friends. Always report N.
Research question
How peaceful is The Sopranos, statistically speaking?
| Value | Frequency | Percent | Cumulative Percent |
|---|---|---|---|
| 0 | 5 | 6.8 | 6.8 |
| 1 | 16 | 21.6 | 28.4 |
| 2 | 19 | 25.7 | 54.1 |
| 3 | 15 | 20.3 | 74.3 |
| 4 | 5 | 6.8 | 81.1 |
| 5 | 8 | 10.8 | 91.9 |
| 6 | 4 | 5.4 | 97.3 |
| 7 | 1 | 1.4 | 98.6 |
| 9 | 1 | 1.4 | 100.0 |
| Total | ? | 100.0 |
Read the frequency table (no calculator needed) and fill in four statistics.
Mean, median and skew
Mean or median?
If the distribution of violence counts is strongly right-skewed, would the mean or the median better describe a typical episode?
Are later seasons more likely to contain major violence?
Check the denominator before you disrespect the family.
Research question
Are later seasons more likely to contain major violence?
X in the rows, Y in the columns
| Ymajor_violence | |||
|---|---|---|---|
| Xearly_late | No major violence | Major violence | Total |
| Seasons 1–3 | 23 | 16 | 39 |
| Seasons 4–6 | 11 | 24 | 35 |
| Total | 34 | 40 | 74 |
Raw counts. The two periods contain different numbers of episodes (39 vs 35), so counts alone cannot be compared.
Seven questions about one table
Question 1
Research question: “Are later seasons more likely to contain major violence?” What is the independent variable?
Tempting interpretation
A classmate writes: “60% of the episodes with major violence occurred in later seasons.” Does this answer whether later seasons are more likely to be violent?
SPSS mode
Now, and only now, the software
Choose the method
Both variables are dichotomous (nominal). Which analysis fits before we touch SPSS?
The People of New Jersey v. H₀
The defendant (H₀)
Major violence is independent of whether an episode comes from an early or late season.
The evidence
χ²(1) = 5.64, p = .018
Cramer's V = .28, N = 74
The verdict
p = .018. Which conclusion is correct?
The ruling
Sentencing
p = .018, Cramer's V = .28, N = 74. Which summary is correct?
What happens to X → Y when Z walks in?
Bivariate analysis. Whatever happened there.
Zero-order relationship (from the dataset)
| Seasons 1–3 | Seasons 4–6 | Difference | |
|---|---|---|---|
| All episodes | 41.0% | 68.6% | +27.5 points |
Lazarsfeld visualizer
Four ways a story can end
The original two-variable relationship: later seasons, more major violence. Everything that follows is compared with this.
Where does Z live in the story?
No Z yet.
Scenarios
Same X and Y, four hypothetical sets of partial tables
Hypothetical tablesThe partial tables in scenarios A–D are invented to illustrate each pattern. They are not computed from the dataset.
Scenario A
Z = finale episode. The early/late difference is about the same among finales and ordinary episodes. Which Lazarsfeld pattern?
| Seasons 1–3 | Seasons 4–6 | Difference | |
|---|---|---|---|
| Zero-order (all episodes) | 41.0% | 68.6% | +27.5 |
| Ordinary episodes | 39% | 66% | +27 |
| Finales | 62% | 90% | +28 |
Scenario B
Same X, Y and Z, different hypothetical data. Which Lazarsfeld pattern?
| Seasons 1–3 | Seasons 4–6 | Difference | |
|---|---|---|---|
| Zero-order (all episodes) | 41.0% | 68.6% | +27.5 |
| Ordinary episodes | 47% | 51% | +4 |
| Finales | 25% | 92% | +67 |
Scenario C · Where does Z live in the story?
Suppose the production budget increased over the course of the series. Proposed story: season period → production resources → visually elaborate (major) violence. Where does Z = production budget live in the story?
Scenario C
Controlling for production budget, the season–violence relationship disappears. Which Lazarsfeld pattern?
| Seasons 1–3 | Seasons 4–6 | Difference | |
|---|---|---|---|
| Zero-order (all episodes) | 41.0% | 68.6% | +27.5 |
| Lower budget | 37% | 39% | +2 |
| Higher budget | 70% | 72% | +2 |
Scenario D · Where does Z live in the story?
Suppose a broader change in HBO programming policy came before both the later seasons and the change in content intensity. Where does Z = programming policy live in the story?
Scenario D
Controlling for the programming-policy period, the original relationship disappears. Which Lazarsfeld pattern?
| Seasons 1–3 | Seasons 4–6 | Difference | |
|---|---|---|---|
| Zero-order (all episodes) | 41.0% | 68.6% | +27.5 |
| Before policy change | 36% | 38% | +2 |
| After policy change | 71% | 73% | +2 |
Same tables, different story
Five steps, one correct sequence
Put the five steps of the Lazarsfeld analysis in order.
Drag the steps, or use the arrow buttons to move them.
- 1A. Analyze the partial tables and compare them with the zero-order relationship.
- 2B. Formulate and interpret the two- and three-variable model and identify the role of the control variable.
- 3C. Set up the two-dimensional and three-dimensional model.
- 4D. Summarize the findings and classify the result using Lazarsfeld's paradigm.
- 5E. Analyze the original two-dimensional crosstab.
Why the 2D table comes first
Do longer episodes contain more violence?
Correlation does not imply whacking.
Research question
Do longer episodes contain more violence?
Measurement levels
Research question: “Do longer episodes contain more violence?” What are the measurement levels of runtime_minutes and violence_event_count?
Pearson or Spearman?
Two scale variables, and the scatterplot shows a roughly linear cloud without extreme outliers. Pearson or Spearman?
Does Tony swear more in longer episodes?
Estimate Pearson's r from the cloud.
Pearson or Spearman?
fuck_count is strongly right-skewed and two episodes are extreme outliers. Pearson gives r = .45, Spearman gives rho = .36. Which should you report?
Is violence unrelated to the passage of the series?
r = .00
Pearson, N = 74
Mean violent events by season
- Season 13.69
- Season 22.69
- Season 31.23
- Season 42.50
- Season 52.58
- Season 63.55
Nonlinearity trap
Position in the series vs number of violent events: r = .00. Does r ≈ 0 prove there is no relationship?
Two measures of ‘violence’, two stories
One mean, two groups, or two measurements?
Question A
Question A
“Is the average Sopranos episode longer than a hypothetical 50-minute benchmark?” Which test?
Question B
Question B
“Do episodes with a therapy scene have a different average violence count from episodes without a therapy scene?” Which test?
Question C
Question C
Every episode has two coded counts: family_conflict_count and crime_conflict_count. “Within the same episodes, are crime-related conflicts more frequent than family-related conflicts?” Which test?
Therapy scenes and violent events
Statistically significant. Emotionally complicated.
| therapy_scene | N | Mean | Std. Deviation | Std. Error Mean |
|---|---|---|---|---|
| 1 = therapy scene | 25 | 2.08 | 1.824 | 0.365 |
| 0 = no therapy scene | 49 | 3.00 | 1.780 | 0.254 |
| Levene's Test | t-test for Equality of Means | |||||
|---|---|---|---|---|---|---|
| F | Sig. | t | df | Sig. (2-tailed) | Mean Difference | |
| Equal variances assumed | 0.334 | .565 | -2.086 | 72 | .041 | -0.920 |
| Equal variances not assumed | -2.069 | 47.385 | .044 | -0.920 | ||
- 1Levene's p = .565 ≥ .05: read the ‘Equal variances assumed’ row.
- 2Sig. (2-tailed) = .041.
| Standardizer | Point Estimate | |
|---|---|---|
| Cohen's d | 1.794 | -.513 |
| Hedges' correction | 1.813 | -.507 |
- 3Hedges' g: Cohen's d with a small-sample correction. Ignore the sign when judging size.
Four questions about the output
Output · 1
Is the difference statistically significant at α = .05?
Before you interpret the t-test, Paulie has one more question.
Paulie's question
Levene's test: p = .62. Which row do you read?
Paulie's follow-up
Levene's test: p = .012. Which row now?
Did later seasons become more violent, or is it the finales?
Research question
Did later Sopranos seasons become more violent, or is the apparent relationship mainly due to season finales?
The tables (from the dataset)
| No major violence | Major violence | Total | |
|---|---|---|---|
| Seasons 1–3 | 23 (59.0%) | 16 (41.0%) | 39 |
| Seasons 4–6 | 11 (31.4%) | 24 (68.6%) | 35 |
| Layer (Z) | Seasons 1–3 | Seasons 4–6 | n |
|---|---|---|---|
| Ordinary episodes | 38.9% | 65.6% | 68 |
| Finales | 66.7% | 100.0% | 6 |
Zero-order: χ²(1) = 5.64, p = .018, V = .28. Ordinary episodes: χ²(1) = 4.85, p = .028, V = .27. Finales: too few episodes for a χ² test.
Synthetic dataThe case, step by step
Step 1 · roles
“Did later Sopranos seasons become more violent, or is the apparent relationship mainly due to season finales?” Identify X, Y and Z.
SPSS mode
The three-dimensional crosstab
Same dialog as Part 3, with finale_episode in the Layer box: SPSS prints one partial table (with χ² and V) per category of Z.
Final report
Case closed (for now)
Simon's Sopranos statistical profile
0 / 58 questions attempted
- Measurement levels & roles0 / 0 of 13
- Frequencies0 / 0 of 3
- Crosstabs0 / 0 of 10
- p-values0 / 0 of 3
- Lazarsfeld0 / 0 of 11
- Correlation0 / 0 of 6
- t-tests0 / 0 of 12
Strongest area
Not enough answers yet
Practice only: this is not a course grade. Only first attempts count, and they are stored in this browser and nowhere else.
Synthetic teaching dataset inspired by The Sopranos. Values are created for statistical practice and are not factual episode statistics. This page is an independent teaching exercise. It is not affiliated with or endorsed by HBO or the makers of The Sopranos, and it uses no images, logos or scripts from the show.