Need help with formula to calculate Average Length of Stay
Average length of stay - how do you calculate it?
I mean I know I can have a good idea by figuring out the "average room nights per arrival" or "average room nights per departure" on a yearly basis, and maybe even monthly - however this becomes wildly inaccurate when trying to calculate for a single date.
Even on a monthly basis: If you usually have a lot of guests arriving at the end of December and departing at the beginning of January (New Years example), then depending on if we are using arrivals or departures as the basis for the "average length of stay" we'll have quite different results...
...Do I calculate the "average room nights per arrival" AND "average room nights per departure" and use the average, to get a more accurate result, or how?
Has anyone else run into this little conundrum? Hope someone has an idea!
P.S. I realise to be very exact it would be necessary to average the literal length of all reservations in a timeframe, but the data that is most practical to export has the occupied rooms, arrivals, departures etc. per date and I'm trying to do the best that's possible with that...