You realize the distribution of stay durations might have an impact on the hotel business. For example, if many people stay for long periods of time the frequency of cleaning rooms could be decreased.

Determine this distribution. Creating a histogram: Excel does currently (version used in the course: 2013) not provide a built-in feature for creating histogram charts directly. You can however create a frequency table with the array formulaFREQUENCY or using COUNTIFS and create a column chart from that table. Both methods are explained here.