O'Reilly logo

Visual Six Sigma: Making Data Analysis Lean by Leo Wright, Mia L. Stephens, Philip J. Ramsey, Marie A. Gaudard, Ian Cox

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required