coinbad.blogg.se

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. Video on how to create a Frequency Table and Histogram.