Histogram Example | Foundry Industries Examples

Histogram Example | Foundry Industries Examples

Histogram Example: Hello, Readers! Here we will discuss two important industrial examples to prepare a Histogram and its interpretation. If you are interested in downloading the Excel template/format, then go through the beneath links.

DOWNLOAD [Histogram Template in Excel format].

How to Prepare Histogram in Excel?

Histogram Example
Histogram Example

Example-1:

A Process engineer of an organization (XYZ Ltd) had decided to know the bins range [frequency distribution] of pouring temperature of casting and he has started collecting the data of 30 number readings and analyzing that data distribution that histogram graph is normal or non-normal. Illustrations of the same readings are given below,

Histogram Example
Histogram Example

DOWNLOAD Example-1’s Histogram Excel Template.

Parameter: Pouring Temperature of Casting 1390±10°C M/C   Shift   Date  
Sl. No Readings Sl. No Readings
 1 1390 16 1399
2 1389 17 1395
3 1395 18 1397
4 1394 19 1396
5 1393 20 1392
6 1392 21 1393
7 1397 22 1393
8 1398 23 1400
9 1397 24 1389
10 1393 25 1390
11 1396 26 1390
12 1400 27 1391
13 1391 28 1392
14 1400 29 1393
15 1398 30 1397
Min. 1389
Max. 1400
Count 30
Interval 1.2
Parameter Frequency
1389 2
1390.2 3
1391.4 2
1392.7 3
1393.9 5
1395.1 3
1396.3 2
1397.6 4
1398.8 2
1400.0 1
1401.2 3
Sum of frequency 30
 Exmp. of frequency distribution
Example-1

Interpretation of Result: Non-normal data distribution.

Example-2:

We have collected the 30 readings of green sand permeability, details are given below and also, and we have plotted a histogram to know the data frequency distribution.

DOWNLOAD Exanple-2’s Histogram Excel Format.

Parameter: Green sand Permeability 200±10 M/C   Shift   Date  
Sl. No Readings Sl. No Readings
1 201 16 200
2 200 17 201
3 202 18 201
4 201 19 203
5 200 20 201
6 199 21 198
7 199 22 199
8 198 23 197
9 201 24 197
10 200 25 198
11 199 26 199
12 198 27 200
13 197 28 201
14 199 29 203
15 198 30 200
Min. 197
Max. 203
Count 30
Interval 0.7
Parameter Frequency
197 3
197.7 0
198.3 5
199.0 0
199.7 6
200.3 6
201.0 0
201.7 7
202.3 1
203.0 0
203.7 2
Sum of frequency 30
Histogram Example
Example-2
Interpretation of Result: Non-Normal data distribution.

Useful Links:

How to Plot Pareto Chart in Excel ( with example)

OEE Calculation-How To Calculate OEE (Overall Equipment Effectiveness) with Example

Implementation of KAIZEN in Industry

CAPA Process

Thank you for reading…. Keep visiting Techiequality.Com

Let us know if you have any questions…

Popular Post:

Add a Comment

Your email address will not be published. Required fields are marked *

error: Content is protected !!