How to construct Histogram? For BBA 3rd semester, Statistics1 min read

  • 1
    Share

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 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,


  • 1
    Share
READ  Statistics Practical: Mean and Variance (Statistics, BBA 3rd Semester)

Leave a Reply

avatar
  Subscribe  
Notify of

StudyDeeper

I enjoy sharing ideas, knowledge, and information. I believe that "sharing of knowledge removes the barriers of expansion of one's knowledge."
Close Menu