MCQ exit ticket on forecasting logic and common misconceptions
Forecasting Logic Exit Ticket
Short MCQ check on trend line interpretation and forecasting concepts
This assessment checks your understanding of what forecasting can and cannot do - the foundational concepts you need before building Excel models in upcoming lessons.
What This Assessment Tests
Conceptual Understanding
- What trend lines do and don't show
- Positive vs. negative relationships
- What R-squared means (and doesn't mean)
- When predictions become unreliable
Applied Skills
- Calculating predictions from slope
- Interpreting slope in business terms
- Recognizing patterns like diminishing returns
- Identifying forecasting limitations
Focus on understanding the concepts, not just memorizing formulas. These ideas will make your Excel forecasting work much more meaningful.
1. A trend line shows sales increasing by $200 per month. If this month's sales are $10,000, what would you predict for 3 months from now?
2. What does a trend line with a negative slope tell you?
3. R-squared = 0.4. What does this tell you about the pattern?
4. Why is predicting 5 years into the future from 6 months of data problematic?
5. You find that more staff = more sales, but the relationship flattens out at higher staffing levels. What is this called?
6. What is the most important thing to remember about any forecast?
7. A scatter plot shows a strong positive relationship between advertising spend and sales. What does this mean?
8. When interpreting a trend line, what does the slope tell you?
Your performance on this assessment indicates your readiness for the Excel forecasting tools coming next.
Expert (7-8 correct)
Ready for Excel forecasting. You understand the logic behind the tools you'll use.
Proficient (5-6 correct)
Good foundation. Review any missed concepts before Excel lessons.
Developing (1-4 correct)
Review phases 1-3 before continuing. Make sure you understand the concepts.
Now that you understand what forecasting does (and doesn't do), you're ready to learn the Excel tools that automate this process. In upcoming lessons, you'll use Excel to:
What's Coming in Lessons 5-6
Data Cleaning
- Import and organize café data
- Handle missing or unusual values
- Prepare data for analysis
Statistical Analysis
- Build scatter plots automatically
- Add trend lines with R-squared
- Use FORECAST and TREND functions
The concepts from this lesson - slope, fit, danger zones - will now have real Excel implementations. Understanding the logic first makes you a better analyst than just clicking buttons without knowing what they do.