This will remove the formula but will keep the values and make data stationary. To make this data static, copy the entire column and Paste Special as Value only. In order to make a histogram, the first step is to get rid of this RANDBETWEEN() formula when we have our data. Generate data and keep only values (NO formula): Let’s take an example of data generated between zero and 25 as shown in the following picture: This function can give you randomly generated numbers between an lower and an upper bounds and you can analyze it with histogram. If not, you can make one using excel function RANDBETWEEN(). If you have a data set for creating histogram that is great. Taking a sample data and working out Histogram: The Y-Axis represents the frequency axis.In above example class 60-65 has frequency of 25. The X-Axis has “Intervals” or it represents the class width for which the frequency is reported.For the fixed interval class, the height is proportional to the frequency of the items. The yellow bars represent the frequency of items.The following picture shows various parts of it! There are some features that can be found in every histogram. The term “class interval ” represents the grouping of data in n-groups where n can be an arbitrary value. In this definition (and for the discrete data sets) the “frequency distribution” is the frequency of how often a number is repeated in a data set. If the class intervals are of equal lengths, then the heights of the rectangles are proportional to the frequencies.” It consists of a sequence of rectangles, each of which has as its base one of the class intervals and is of a height taken so that the area is proportional to the frequency. “A diagram representing the frequency distribution of data grouped by means of class intervals. The “Concise Oxford Dictionary of Mathematics” defines Histogram as: In today’s tutorial, we will learn a little but of theory about histogram, how to read it, few statistical terms and finally, how to plot a histogram using MS Excel. The data such plotted produced graphs of various types – an Excel Histogram is just one of them. This is to see if there are any patterns present or if there is any (apparent) relationship between variables. The data analysts start their analysis by visual examination of the data.

Histogram tool excel