2.2.3 Distribution graph

Course subject(s) Module 2: Dashboard Set-Up

Select the Distribution

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.

Creative Commons License
Data Analysis: Building your own Business Dashboard by TU Delft OpenCourseWare is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Based on a work at https://ocw.tudelft.nl/courses/data-analysis-bu…siness-dashboard/.
Back to top