Weekday vs Weekend: Day Types, Average Days and the Weekly Pattern
This lesson is part of the course
In this lesson
You label two weeks of daily counts as weekday or weekend, average each day type and each day of the week with WEEKDAY inside SUMPRODUCT, and chart the fortnight to see the weekly rhythm.
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
- From 15-Minute Counts to Hourly Volumes: Rolling Hours, Clock Hours and the Peak Hour Locked
- Peak-Hour Factor: How Peaky Is the Peak Hour? Locked
- Directional Splits and Heavy Vehicles: Shares by Direction, Class and the Peak Hour Locked
- Weekday vs Weekend: Day Types, Average Days and the Weekly Pattern Locked
- Short Counts to Annual Averages: Month and Day Factors and the AADT Estimate Locked
- Junction Turning Counts: the Movement Matrix, Arm Totals and Turning Shares Locked
- Growth Projections and the Design Hour: Compound Growth, Peak Direction and the Threshold Year Locked
- Capstone: Count Quality Checks, Spike Flags, the PM Peak and the Daily Profile Locked