PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
CHARTS are the graphic representation of any data . As we know that EXCEL is a super analytical tool.
Analysis of data is the process of deriving the inferences by finding out the trends, averages etc. about different parameters.
Excel provides us with a variety of charts and graphs to make our life easier. Although any chart can be used for any type of data, even then there are certain types which are apt for a particular type of data.
This is a standard excerpt for the charts.
Now, in this article , we will discuss about the HISTOGRAM CHART which are specifically designed to show the frequency of the data in certain bins.[Intervals]. Histogram is a statistical chart useful in statistics.
The histogram chart shows the bars showing the frequency in a particular interval.
HISTOGRAMS are used at many places.
HISTOGRAMS shows the data distribution. It shows the frequency of any particular value.
Histograms are most helpful in random surveys. For example, if we want to know the random temperatures of a group of human beings.
Histograms are also used in photography. It shows the tonal distribution of the image.
So, when we have a study in which we need to find out the most frequent data or least frequent data, we can make use of histograms.
The button for column chart is found under the INSERT TAB >CHARTS SECTION under the button INSERT STATISTICAL CHARTS >HISTOGRAM CHART. The location is shown in the picture below.
MARKS OF 100 STUDENTS | ||||
65 | 98 | 91 | 75 | 73 |
62 | 61 | 100 | 77 | 51 |
80 | 56 | 71 | 63 | 93 |
97 | 77 | 67 | 50 | 57 |
59 | 81 | 92 | 79 | 77 |
60 | 75 | 70 | 62 | 53 |
88 | 86 | 55 | 66 | 95 |
81 | 76 | 78 | 56 | 71 |
63 | 54 | 92 | 96 | 92 |
93 | 69 | 96 | 64 | 88 |
98 | 95 | 78 | 95 | 80 |
100 | 79 | 63 | 71 | 89 |
52 | 55 | 89 | 74 | 68 |
67 | 80 | 94 | 76 | 66 |
91 | 97 | 80 | 75 | 69 |
97 | 77 | 67 | 50 | 57 |
59 | 81 | 92 | 79 | 77 |
60 | 75 | 70 | 62 | 53 |
88 | 86 | 55 | 66 | 95 |
81 | 76 | 78 | 56 | 71 |
The procedure to insert a HISTOGRAM chart are as follows:
So , we have successfully created a HISTOGRAM CHART.
We can see that a histogram has been created automatically. It is showing the data in the three columns which we can call as the bins. So these columns tells about the frequency of the numbers falling inside the given bins.
Let us change the bin size and check the chart after setting the bins.
Follow the steps to configure the bin size.
Bins can be adjusted by many ways. For example,
by
FOR ALL OTHER TASKS LIKE CHANGING THE NAME OF THE CHART, CHANGING THE AXIS , CHANGING THE CHART STYLE ETC. VISIT HERE [HOW TO CREATE A CHART IN EXCEL].
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE