← Back to QUESTIONSTAR
Chapter 5 · Data Analysis: A Concise Overview of Statistical Techniques · Slide 214/274

Regression Analysis

How many product units will we sell if we spend €85.000 on advertising?

5.2.3 · Relationship between Two VariablesWorked Example

Regression Analysis


How many product units will we sell if we spend €85.000 on advertising?

Advertising spend,
€1.000
Sales,
€1.000
40377
60507
70555
110779
150869
160818
190862
200817
Collected Data
Relationship between Sales and Advertising Spend
0 200 400 600 800 1000 0 50 100 150 200 250 y = 2.8239x + 352.07 R² = 0.8364 Sales, €1,000 Advertising spend, €1,000
  • Advertising spend explains 83.6% of the variance in sales.
  • Every additional euro invested in advertising brings €2.82 of additional sales.
  • €85.000 of advertising spend results in 2.8239 · 85 + 352.07 = 592.1 (thousand €) of sales.
QUESTIONSTAR · Dr. Paul Marx214 / 274
To the full presentation