Skip to Main Content
Visual Six Sigma: Making Data Analysis Lean
book

Visual Six Sigma: Making Data Analysis Lean

by Ian Cox, Marie A. Gaudard, Philip J. Ramsey, Mia L. Stephens, Leo Wright
December 2009
Beginner to intermediate content levelBeginner to intermediate
504 pages
13h 37m
English
Wiley
Content preview from Visual Six Sigma: Making Data Analysis Lean

7.8. Additional Details

In this section, we provide you with details relating to three items, two of which were mentioned in the case study. The first subsection gives a description of a script that provides the number of unique levels for each variable and saves these levels to Column Info. The second subsection explains how to save a script to create a summary table to the main data table, as is done in the data table PharmaSales.jmp. The third subsection sketches how to create a formula for a year-to-date summation.

7.8.1. Unique Levels Script

As we have seen, some of the nominal variables in the PharmaSales.jmp data table have a large number of levels, which makes studying their bar graphs difficult. The data table PharmaSales.jmp contains a script called Unique Levels that produces a table that gives the counts of the number of distinct levels of each variable, sorting the columns in order of decreasing frequency relative to the number of levels. For each variable, the script also places these levels into the Column Info dialog as a column property. When nominal variables have a large number of levels, this script can be useful as a preliminary data check.

When you run this script, the table in Exhibit 7.64 appears.

Figure 7.64. Table Giving Number of Distinct Levels for Each Variable in PharmaSales.jmp

Also, you will note that in PharmaSales.jmp asterisks appear next to ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Statistics for Six Sigma Green Belts with Minitab and JMP

Statistics for Six Sigma Green Belts with Minitab and JMP

David M. Levine
Visual Six Sigma, 2nd Edition

Visual Six Sigma, 2nd Edition

Ian Cox, Marie A. Gaudard, Mia L. Stephens

Publisher Resources

ISBN: 9780470506912Purchase book