Tag: distribution
-
How Advance do People Make Rental Car Reservations? The Result May Surprise You!
Spring break is upon us. Many students of mine are heading to exotic location, and quite a few of them have reserved rental cars many weeks earlier. But here is the question: When do most people make rental reservations? A week in advance? Or, just a few days in advance? I have worked with a…
-
The New Histogram Tool in Excel 2016 is Handy-Dandy
Let’s face it. The old histogram tool in Excel – the one hidden in Data Analysis – is a pain to use. You need to prepare a ‘Bin range’ to start with, which requires you to know the minimum, maximum, and the width of bin. Then PivotTable came along, and provided a quite handy…
-
To build a frequency distribution chart, do NOT use Excel’s Histogram add-in tool
A histogram (also called a frequency distribution chart) shows how many times a specific value occurs within a certain range. It is super-useful if you want to know how a variable is statistically distributed. But Excel’s built-in histogram tool is not the best tool to use: It requires you to specific “bin values” before hand, which requires…