Average Length of Stay: Nights per Arrival, by Type and Overall
This lesson is part of the course
In this lesson
You build a summary by accommodation type with SUMIFS, compute the average length of stay for campsites and the pooled value for the whole district, and see why averaging the type ratios gives the wrong answer.
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