[rkward-users] Pareto Analysis using RKward

[Vikas Garud]

Hi,

I am exploring GUI's for doing Quality
Management/Assurance/Improvement activities and this is another mail
in series!

Focus of this mail is Pareto Analysis for following data (Truncated):
Date	Defect code	Operator	Shift	Machine	Cost - Internal	Cost -
External	Cost - Total
8-Jun-2011	410	Joe	1	AAA	5	50	55
8-Jun-2011	465	Joe	1	AAA	1.5	25	26.5
8-Jun-2011	412	Joe	1	AAA	1.5	10	11.5
8-Jun-2011	410	Joe	1	AAA	5	50	55
8-Jun-2011	218	Joe	1	AAA	1	10	11
8-Jun-2011	440	Joe	1	AAA	1	10	11
8-Jun-2011	410	Joe	1	AAA	5	50	55
8-Jun-2011	413	Joe	1	AAA	0.5	5	5.5
8-Jun-2011	410	Joe	1	AAA	5	50	55
8-Jun-2011	465	Moe	1	BBB	1.5	25	26.5
8-Jun-2011	410	Moe	1	BBB	5	50	55
8-Jun-2011	412	Moe	1	BBB	1.5	10	11.5
8-Jun-2011	841	Moe	1	BBB	0.5	5	5.5
8-Jun-2011	410	Moe	1	BBB	5	50	55
8-Jun-2011	413	Moe	1	BBB	0.5	5	5.5
8-Jun-2011	410	Moe	1	BBB	5	50	55
8-Jun-2011	413	Moe	1	BBB	0.5	5	5.5
8-Jun-2011	465	Moe	1	BBB	1.5	25	26.5
8-Jun-2011	410	Moe	1	BBB	5	50	55

In all cases, the qcc package is loaded.

RKward:

I could get nice Pareto Chart, for the variable Defect code.  Is it
possible to plot a Pareto Chart for, say, Total cost?  The attempt of
plotting the same through RKward fails, in the sense that the number
of times a particular cost value appears is used for plotting the
Pareto chart.  I'd like a Pareto plot by defect codes based on Total
cost.  Is this possible?  How?

The data in this example to demonstrate Pareto Chart contains 8 defect
codes and it is possible to make sense of the plot.  Some real data
contains hundreds of records.  (There is file, somewhere on the
internet - sorry, I could not find the link - CFHPareto.xls containing
11099 records in 37 defect codes.)  Doing a Pareto Analysis did give
me nice coloured Pareto Chart, however, the legends are all mixed up
and can not be read.  The utility of the Pareto chart is practically
nil.  For such data, I would like to club categories beyond, say, 80%
in cumulative total, to be clubbed in "Others".    Is it possible?
How?

Any help is appreciated.

Regards
Vikas Garud