How to calculate seasonal indexes (indices) using the simple average method in Excel or Google Sheet. This approach assumes there is no trend.
00:00 – Intro
00:37 – Seasonal relative/ Index
01:15 – Interpretation of seasonal indices
1:44 – Annual projection