Should I use weighted average vs arithmetic average in my data?
Columns(Month, Bookings, Day, Bookings/Day)
Should I do Bookings/Days OR Avg(Bookings/day) to get average by month?
Should I use weighted average vs arithmetic average in my data?
Columns(Month, Bookings, Day, Bookings/Day)
Should I do Bookings/Days OR Avg(Bookings/day) to get average by month?
You have to take Weighted Average for getting average by month [sumof(Day's*Bookings)]/Month