Graph for several variables

[Andreas Schuehly]

Dear all,

I'm struggling a bit with an assignment task, as I'm not sure how to solve it.
I'm using Data from Dominick's Database from Chicago's Kilt Center.
My task I'm struggling with is the following:
"Draw a meaningful plot that shows the effect of promotions on sales for one selected brand."

I have generated a column calculating the sales, and now I have a column for the promotions. The values of the promotions(=called sale) are either 0, coupon, bonus or price reduction.

I already decided to use only the first year (=52 weeks). But now, I do not know, how I can create meaningful plot

I tried the following:
tw sc sales sale if week<53 if nitem=9013201

but it does not work.
Thanks for your support.

Best regards,
Andreas

[Nick Cox]

Doing your assignments for you isn't a responsibility for us: indeed, your institution may have (should have) rules on plagiarism and collusion. But as a small matter of Stata syntax I guess your command should end

if week < 53 & nitem == 9013201

Please do read the FAQ Advice, as requested, and never say "does not work" without saying exactly what happens.