📝 Write-Up Requirement (Max 300 words)
You must include a 300-word write-up that shares the story behind the data and your analysis.
In your write-up:
- 📈 Interpret the scatter plot – What kind of relationship do you see?
- 📊 Interpret the regression output – Is the relationship positive? Statistically significant?
- 🧩 Summarize the story for management – Based on your results, should the company continue investing in advertising at this level?
❗️Important Format Requirement
- You must watch the tutorial video (posted on this page)
- Follow the bullet point prompts given in the video
- Use the same bullet points as headers in your Word document
- Answer each bullet point clearly and directly
⚠️ If you submit a single long paragraph instead of following the bullet format, your write-up will receive zero credit, even if the content is correct.
🧠 Lab Insight
Are revenues dependent on advertising expense? It’s a common belief that the more consumers are aware of a product through advertising, the more they will buy. But how strong is that relationship?
In this lab, you’ll analyze the relationship between advertising expenditures and sales revenue using:
- A scatter plot to visualize the relationship
- A regression analysis to quantify the relationship
This is an important question for any company: 👉 “Are our advertising dollars producing a meaningful return?”
⚙️ What You’ll Do
You will use Excel to:
- Create a scatter plot showing the relationship between advertising expenses (independent variable) and sales revenue (dependent variable)
- Run a regression analysis to model this relationship