Use Microsoft Excel 2007 for analyzing your data in a frequency histogram. Enter your data in column "A." For example, you have a list containing test scores of 16 students (2, 5, 6, 5, 7, 8, 7, 5, 5, 4, 10, 8, 6, 9, 2 and 6) and you want frequency distribution of the grades. Name column A by writing "scores" in cell A1. Enter test scores in the same column from A2 through A17.
Select column B and name cell B1 "bin values." The bin values will help you to evaluate the frequency of occurrence of the test scores. In our example, the lowest score is 2 and the highest is 10, so the bin values will range from 2 to 10. Write bins of test scores ranging from lowest to highest; start with 2 in B2 and end with 10 in B11.
Move to column C; name cell C1 "frequency." In this column you will calculate the frequency of occurrence of bin values entered in column B. Click on C2 and type the formula "=COUNTIF(A2:A17,B2)." You need to copy this formula to the other cells as well. You also can enter it manually in each cell. For copying automatically, take the cursor to the lower right C2. Click the left mouse button, hold and drag it downward and release when you reach C11.
Click the heads of columns B and C. Click the "Insert" tab at the top of the Excel window and select "Column chart." A side menu will appear. Click on "2D chart type" for a basic histogram model.