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.4. Investigating Promotional Activity

Rick's first task is to verify the claims of the marketing group that the test promotion they ran in 2008 was successful. The promotion was run from May through December 2008 in three regions: Midlands, Northern Ireland, and Southern England.

Rick's first thought is to look at total prescriptions written per physician across the eight months for which he has data, and to see if the three promotion regions stand out. To accomplish this, he must construct a summary table giving the sum for the relevant variables over the eight-month period. This will allow him to compare the 2008 physician totals across regions, taking into account physician variability. But Rick is also interested in how prescription totals vary by region when considering the number of visits. Do the promotional regions stand out from the rest in terms of prescriptions written if we account for the number of visits per physician?

7.4.1. Preparing a Summary Table

Rick begins by creating a data table that summarizes his data across physicians. First, he makes sure that colors and markers by Region Name are still applied to his data table. (If yours are not, then please run the script Color and Mark by Region.) To create a summary table, he selects Tables > Summary. Thinking carefully about what to summarize, Rick decides that he will want to sum Visits, Visits with Samples, and Prescriptions across Physician Name. To populate the dialog correctly, he first selects all three ...

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