Excel How To: (Grouped) Frequency Table Using Pivot Table Function Instead of Analysis ToolPak’s Histogram Function
You can create a (grouped) frequency table using the Histogram function of Analysis ToolPak. However, one downside of this method is that you need to manually decide the bins. For example, you need to manually list all the possible values for a regular frequency table or manually enter the upper limits of the bins (grouped … Read more