How to construct Histogram? For BBA 3rd semester, Statistics

TU BBA 2016 Question: To Construct Histogram

Col/Row	A	B	C	D	E	F	G	H	I	J
3	22	16	26	33	33	37	9	23	32	17
4	20	13	12	18	19	10	21	22	25	22
5	22	22	34	24	23	21	38	31	41	20

Constructing a histogram,

Step 1

Determining the maximum, minimum, and the numbers of items. This step is optimal.

Maximum value		41	=MAX($A$3:$J$5)
Minimum value		9	=MIN($A$3:$J$5)
Number of items		30	=COUNT($A$3:$J$5)

Source: Excel 2013

Step 2

Range	Lower Limit (LL)	Upper Limit (UL)	Frequency	Formula
0-10	0	10	1	=COUNTIF($A$3:$J$5,">="&0)-COUNTIF($A$3:$J$5,">="&10)
10-20	10	20	7	=COUNTIF($A$3:$J$5,">="&10)-COUNTIF($A$3:$J$5,">="&20)
20-30	20	30	14	=COUNTIF($A$3:$J$5,">="&20)-COUNTIF($A$3:$J$5,">="&30)
30-40	30	40	7	=COUNTIF($A$3:$J$5,">="&30)-COUNTIF($A$3:$J$5,">="&40)
40-50	40	50	1	=COUNTIF($A$3:$J$5,">="&40)-COUNTIF($A$3:$J$5,">="&50)
			30	=SUM(D12: D16)

Source: Excel 2013

After finding out the maximum and minimum value, we obtained the clue for construction of range. We arranged a range with a gap of 10 starting from 0 to 50.

After creating a range, we calculated the frequency using the formula shown in the table.

Step 3: Construction of Histogram

To construct the histogram,

1. select the data you want to present in the chart or histogram,


2. Go to insert tab


3. Go to the charts and click on the bar chart


4. Remove any unwanted charts (if any)


5. To remove the gap between the bars, click on the bars in the chart and right click on it, a dialogue box with appear and click on format data series.


6.  Set the gap to "0" and its done.

Source: Excel 2013

Following these 3 steps, you can easily create a histogram.

For more clarification, watch our video tutorial,