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 BOX AND WHISKER CHARTS which are specifically designed to present many statistical values at once which are very helpful in comparison of the data.
The BOX AND WHISKER has been given such name as it contains a BOX and the two lines are behaving like WHISKERS which gives some more information about the chart.
The upper end of the whisker gives the highest value in the series.
The lower end of the whisker gives the lowest value in the series.
A horizontal line shows the median of the data and a symbol X shows the average of the data.
The portion above the horizontal line is UPPER QUARTILE and lower of the line is LOWER QUARTILE.
So, we can see that this type of chart gave us FIVE DIFFERENT STATISTICAL INFORMATION at once.
Let us get more information about BOX AND WHISKER chart in excel.
The button for BOX AND WHISKER chart is found under the INSERT TAB >CHARTS SECTION under the button INSERT STATISTICAL CHARTS >BOX AND WHISKER CHART. The location is shown in the picture below.
Before we start the example of the box and whisker chart, let us understand its structure.
VEHICLE SALE DATA | |||
TEAM | APRIL | MAY | JUNE |
ABC | 43 | 77 | 85 |
DEF | 32 | 95 | 84 |
XYZ | 12 | 90 | 62 |
DEF | 54 | 76 | 86 |
ABC | 66 | 65 | 86 |
XYZ | 65 | 87 | 67 |
DEF | 54 | 71 | 97 |
XYZ | 34 | 58 | 94 |
ABC | 23 | 61 | 89 |
ABC | 45 | 79 | 52 |
ABC | 65 | 98 | 96 |
XYZ | 67 | 94 | 83 |
DEF | 98 | 64 | 84 |
ABC | 78 | 69 | 79 |
XYZ | 67 | 73 | 57 |
DEF | 56 | 78 | 90 |
ABC | 45 | 92 | 72 |
DEF | 34 | 85 | 52 |
XYZ | 23 | 56 | 55 |
DEF | 23 | 88 | 56 |
ABC | 45 | 74 | 72 |
The procedure to insert a BOX AND WHISKER chart are as follows:
So , we have successfully created a BOX AND WHISKER CHART.
We can see that the data of all the teams for all the months has been plotted. The data is really easy to interpret and to compare. The highest and lowest values can be checked up easily.
The data can be compared easily too. The number is shown by the size of the box which can also be checked easily.
After applying styles and different layouts, here is our final chart.
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