Data Management with Six Sigma – Marissa Langford and Dr. Jeff Joines
September 23-26, 2008 - Register Now!

Future Course Offerings:
June 9-12, 2009 - Register Now!

Who Should Attend:

This course is intended for any Six Sigma professional who needs to manipulate data for analysis. Prior experience using Excel, Minitab or JMP is not required.

Overview:

Successful Six Sigma projects require data to be collected or created, analyzed in order to make improvements and assessed to determine whether implemented solutions made a difference. Performing the statistical analysis in Minitab™ or SAS JMP™ is often the easy part once you have the data in the proper form for these software solutions.  Often the data needed to perform the statistical analysis is never in the correct form, needs to be filtered (i.e., exclude or combine certain fields and/or rows), or resides in external sources (i.e., databases, spreadsheets, internet, etc.) as well as multiple sources. The ability to acquire the data and then manipulate it into the correct format to be analyzed in Minitab™ or SAS JMP™ is quite critical. This workshop will assist you in developing strategies for manipulating the data within Microsoft Excel, importing the data into Excel, Minitab, and JMP from various sources as well as performing additional data and table manipulations within Minitab and JMP.

Topics Include:

• Manipulating and analyzing data within Excel
• Modeling using named ranges
• Efficiently moving around and manipulating Excel
• Utilizing data Tables
• Analyzing using Pivot Charts and Tables
• Recording macros to automate data manipulation
• Importing data into Excel, JMP, and/or Minitab from external sources
• Internet, Excel, Text Files, Databases
• Understanding basics of querying databases for the information you need
• Relational database Basics (Tables, Fields, Records, etc.)
• Using the Query Wizards in Excel, JMP, and Minitab
• Basics of the Sequential Query Language (SQL)
• Manipulating and analyzing data in JMP and Minitab
• Creating subsets and summary tables
• Adding formulas to columns
• Stacking and splitting columns
• Filling columns with random or patterned data
• Using scripts in JMP to automate importing data

Prerequisites:

Familiarity and use of Microsoft Excel along with JMP or Minitab.

Software:

Microsoft Excel and JMP or Minitab.

Register Now! (September 23-26, 2008)