Click the box next to the Chart Output option to display a graph with the numerical results. Next, tell Excel where to put the results for the Frequency Table. The next option tells Excel where to find the ending values for each class. The first option tells Excel where to find the data. Step 11: A dialog box will appear with the following options. Step 10: Select Histogram on the Data Analysis Menu and click the OK button. Step 9: Click on the Data Tab and select Data Analysis. Step 8: Enter the classes into the Excel spreadsheet starting with cell C1 through D6 Continue adding 15, creating classes until the ending class value of 101.

The next class begins with the ending class value and adds 15 to the ending. Step 7: Start with the beginning class value for the start value and add the class width, 15, to get the ending value. Step 6: Determine the class width by applying the following formula, (101 - 11)/6 = 15. This value makes sure the largest value is in the final class.

In this case, the ending value is 101, one more than the maximum value. Step 5: Decide where the last class will end. In this case, the beginning value will be the minimum value, 11.

Step 4: Decide where the first class will begin. To find the maximum value enter the formula into a cell =max(A1:A60). To find the minimum value enter =min(A1:A60) in a cell. Step 3: Determine the minimum (11) and maximum (100) data values. As a result, the number of classes is six, which is the next integer greater than 5.9068. The number of classes, k, must be an integer. The rule states 2 k > n, where n is the total number of data points. k is the minimum number of classes to use for the data set.

Why six classes? We will use the 2 k rule. In this example, we will create six classes. Step 2: Determine the number of classes to use for the Frequency table. Then move to the new Excel Spreadsheet, click cell A1, and paste the data. To copy the data, highlight the data in cells A1:A60 in the FreqData.xls Excel file and click the copy button. Step 1: Open an Excel spreadsheet and copy the data from this file FreqData.xlsx (click the link to download the file) to your spreadsheet. Once the Data Analysis Toolpak is installed, you can create a frequency table.įollowing the steps below to create a frequency table and histogram.

Histograms in excel