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

Get Visual Six Sigma: Making Data Analysis Lean now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.