How to plot Histogram in Excel (Step by step guide with example)

How to plot Histogram in Excel (Step by step guide with example)

How to plot Histogram in Excel,Step by step guidance described below

A histograms is a one of the 7QC tools and commonly used graph to show frequency distribution. Helps summarise data from process that has been collected over period of time.

A histogram is a representation of the frequency distribution of numerical data. it was first familiarised by Karl Pearson. Histogram is related to merely one type of variable data. We have to calculate the interval value to represent the bins. Bins will give you idea about the how many data are fallen within selected data range’s width. Histogram gives the indication about data distribution as normal, skewed or bi-modal.

Advantages of histogram:

# To gives idea about data distribution.

# Data distribution can calculate within short time duration.

# Data are normal or abnormal can  identify through graph.

Typical histogram shapes:

1. Symmetric 2. Left skewed 3. Right skewed 4. Bimodal

Bell Shaped/Symmetric:- Data distribution shape of left side from average line is similar with the right side shape , here data normally distributed within the upper and lower specification limits , such types of data distribution is the safe sign to process operation.

Left/Right Skewed:– Generally in left or right shewed , data are distributed in one side either towards left or right, which indicate the data are non-normal and there may chance that data can go out side of specification limits if will presence any special cause in process or any major variation in process characteristics.

Step-by -step guidance to plot the Histogram with example:-

Here is the full description of  How to plot Histogram in Excel / how to make a histogram in excel-

In the below temperature reading we have 100 data but we do not know the data are normal or non-normal and also how many data are within specification limit, after plotting histogram will give you indication about data distribution . as you can see the histogram in below which indicating the data distribution within bin range.

Step -1

Let we are having 100 numbers of temperature readings , so first of all we need to calculate the count , Max, Min & interval of data as per below-

you can use the excel formula to calculate the count, Max and Min. value

(Interval =(max-Min)/9)

Step -2

Now you have to calculate the Bin range of Temp as per the below steps

(445+1.6 I.e (=I5+G7) then enter “F4” key after “+” & before “G7” of above formula to freez the 1.6 interval value in all the column , then drag )

Step-3

In step -3 you have to calculate the frequency distribution w.r.t temperature bin range , just follow the step 3 explanation in excel sheet.

For getting the frequency formula in excel you may follow the below-

( go to the formula then more function next to statistical then frequency and finally enter on frequency)

Step-4

Go to the data section then data analysis bar and select the histogram

Step-5

After selecting the histogram from the data analysis bar , such dialogue box will be appeared, now you have to select the Input range ( select the whole temperature reading ) then select the temperature bin range as describe in arrow as per step -5 and finally enter the ok after selecting the output range( for output range you have to select at any point in excel where you would like to see the graph may be in same sheet or in new excel sheet)

Now the final histogram will look like as

Thank you for your Support and Co-Operation. Keep Visiting Techiequality.Com

1
Leave a Reply

avatar
1 Comment threads
0 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
0 Comment authors
Recent comment authors
  Subscribe  
newest oldest most voted
Notify of
trackback

[…] How to plot Histogram in Excel.(Step by Step Guides) How to Plot Pareto Chart in Excel ( with example) 7 QC Tools Concepts What is SPC […]