paxutah.blogg.se

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.