Microsoft Excel is used for financial matters has got all the functionalities needed for financial, accounting as well as statistical functions there by giving flexibility to the users to solve out any financial terms. Whether be it calculations, documentations or presentations, it’s a solution to all factors related to finance. It can generate pie diagram, bar diagram, histogram and many more. The main emphasis of this topic is to guide the user how to make Histogram in Microsoft Excel.
User can analyze their data and display it in a Histogram with the help Histogram tool available in Microsoft Excel. Histogram is an additional tool of Analysis ToolPak. Sometimes although the data analysis add-in is available in Excel, it may happen like the add-in may not be loaded automatically. In that case follow the simple step as given:
As we are talking about Microsoft Excel so to follow the step obviously you need to open MS Excel. After you have opened Excel go to “Tools” and then “Add-ins”. Tick/Check the box beside “Analysis ToolPak” and then hit Ok.
Now as we are all set with the settings, the next point that comes to mind is how to create a histogram and view it. Don’t overload yourself with all this thoughts. Just follow the simple steps and you will be done with it.
Create any table with columns in it. Obviously you need to give name to the columns you will create. Let’s take an example of class attendance and the columns names are as Date, Regular, Irregular, Range. Enter data in the columns.
Figure out the button named “Data Analysis” or “Data” on the tool bar and click. On click you will get a list of which you have to select “Histogram” and then Ok.
Most Regular, Regular, Irregular, Range
Now click on the box beside “Input Range” and draw attention to “Regular” and “Irregular” and then click on the box beside “Bin Range” and highlight “Range” data. Input Range is the raw data whereas Bin Range provides the % of attendance to make the difference. If it happens like you leave the Bin Range, the software will do the default Histogram and will its own Bin Range
Next step is to choose the output where in the “Output options” choose “Output Range”. Within the worksheet, select an empty cell and then click on Ok. This will keep the Histogram as well as the Histogram and other corresponding tables on the same worksheet in their original form. Now by viewing the Histogram you can make out the difference between the regular and irregular students.
In the Histogram you will notice that there are gaps between the blocks. So as to get rid of those gaps you need to right click on the blocks in the plot and have to choose “Format Data Series” and then define the gap to “0” instead of the default. i.e.: 150.