BookmarkSubscribeRSS Feed
kurofufu
Calcite | Level 5

Suppose a company has retail stores in two regions, A & B and ran a marketing campaign in region B for 3 months.

The average monthly store sales of last three months BEFORE the campaign of A is 5% higher than those of B.

The average monthly store sales of last three months AFTER the campaign of A is 8% higher than those of B.

I would like to know how to test 8% is significantly higher than 5%.

3 REPLIES 3
kurofufu
Calcite | Level 5

suppose the data look like below and month 1, 2,3 are before the marketing campaign and month 4, 5, 6 doing marketing campaign.

region, store#, month, sales

A, 001, 1, 100

A, 002, 1, 102

....

B, 101, 1, 67

B, 102, 1, 105

....

A, 001, 4, 99

A, 002, 4,110

...

B, 101, 4, 105

B, 102, 4, 121

....

ballardw
Super User

My first question would be: did the marketing campaign affect the sales in B? If so by how much?

And instead of worrying about the 5% and 8% difference I would look first if the mean sales in A changed significantly regarless of what happened in B.

There is a time factor here as well. By any chance was there a similar change in the ratio of sales between A and B the same time last year?

SteveDenham
Jade | Level 19

I hate it when this happens.  Region and marketing campaign are completely confounded in this design.  I do not see how you can attribute any differences found to the effect of the marketing campaign when there are certain to be regional differences.  You may be saved by the time factor, if the measures of sales in each region are pre and post campaign values.  A repeated measures model that looks at the interaction between time and campaign, with region as a random effect might be able to salvage your data.

Steve Denham

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1259 views
  • 0 likes
  • 3 in conversation