Dear friends,
I need your help in following example.
Suppose I have data relating temperature and percent of defects at that temperature. Last column gives total parts at that temperature. I want a graph of temp v/s defect percentage and giving weightage to total parts produced.
temperature, defect Percent, Number of parts produced
640, 10, 10
645, 15, 50
650, 3, 200
655, 3.2, 1000
660, 3, 2000
665, 2, 100
670, 10, 10
If I don't consider weights(total parts produced) the trend is misleading. For instance at 640 deg, total parts produced is 10, but just one defect makes defect percentage 10%. Which affects the trendline. Is there any way to give weightage based on number of parts produced at that temperature.
In other words 650, 655. 660 actually represent the trend as number of parts produced are high and give clear picture, increase in temperature reduces defects. Also I cannot discard first two and last two points.
Thanks for your help
San
I need your help in following example.
Suppose I have data relating temperature and percent of defects at that temperature. Last column gives total parts at that temperature. I want a graph of temp v/s defect percentage and giving weightage to total parts produced.
temperature, defect Percent, Number of parts produced
640, 10, 10
645, 15, 50
650, 3, 200
655, 3.2, 1000
660, 3, 2000
665, 2, 100
670, 10, 10
If I don't consider weights(total parts produced) the trend is misleading. For instance at 640 deg, total parts produced is 10, but just one defect makes defect percentage 10%. Which affects the trendline. Is there any way to give weightage based on number of parts produced at that temperature.
In other words 650, 655. 660 actually represent the trend as number of parts produced are high and give clear picture, increase in temperature reduces defects. Also I cannot discard first two and last two points.
Thanks for your help
San