What is Histogram : How to create it in excel by 2 different ways

What is Histogram

Histogram is a chart that helps us discover and present continuous data basis frequency distribution. It is sort of bar chart just the major difference is that histogram used to show frequency of data in the data set which has been divided in classes also known as bin.

Histogram also helps us to find underlying distribution of data, outliers, skewness and kurtosis. It helps us to check how the output of a process looks like, is process able to meet customers requirement and many more other thing.

How to create Histogram in excel

I will explain 2 methods of creating Histogram in excel

  1. by creating frequency table
  2. by excel inbuilt histogram chart

By creating frequency table:

We … Continue Reading