A Simple Projection: Linear Trend, Trend Factor and Next Season by Month
This lesson is part of the course
In this lesson
You fit a linear trend to seven years of district nights with FORECAST.LINEAR and SLOPE, turn it into a trend factor and project 2026 month by month from the 2025 seasonal pattern.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- The Raw Data: Arrivals, Overnight Stays and Accommodation Types Locked
- Average Length of Stay: Nights per Arrival, by Type and Overall Locked
- Bed and Room Occupancy: Capacity, Open Days and Calendar Days Locked
- Seasonality: Monthly Index, Peak and Low Season, Peak-to-Trough Ratio Locked
- Year over Year: Change %, Same-Period Comparisons and Contributions to Growth Locked
- Tourism Intensity: Nights per 1,000 Residents, per km² and Rankings Locked
- A Simple Projection: Linear Trend, Trend Factor and Next Season by Month Locked
- The Regional Report: KPI Table, Top-3 List and a Chart Locked