[R] Pareto Chart using GUI

[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?

R Commander (with qcc plugin):

I could not get Pareto Chart in R Commander.  Under the Quality
Control Menu, The choice for variables is limited to Date, Machine and
Operator.  This does not change even after the defect code is set to
"Character" type.  I tried the other data (CFHPareto.xls) and I could
get a Pareto Chart of defect code - with bars for all 37 defect codes,
but legends only for 4 codes, which could fit the space available.
Though there is Pareto chart, its practical utility is nil for large
number of categories.

JGR-Deducer:

I could not get any option for plotting Pareto chart.  The
"Frequencies" under the "Analysis" menu computed the number of times a
particular defect code occurs.  This could be used for plotting Bar
chart - though not Pareto chart with the lines above the bars.
However, I could not sort the output table.  I could also not get any
way to compute values for plotting bar plot of defect codes based on
total cost.  Is there a way to accomplish Pareto Chart, may be through
couple of stages?

Any help is appreciated.

Regards
Vikas Garud