Forum Discussion
Intro to Analyzing Data in Excel
In the last lab of 3 we will look at Intro to Analyzing Data in Excel This lab is intended as an introduction to Analyzing Data in Excel. In the previous labs we have discussed getting data into ...
I am looking for a formula to analyze a promotion we did last Xmas. For the 3 months previous to Xmas, we had the promo Buy 3/Get 1 free. After Xmas, we changed to Buy 2/Get 1 free, for another 3 months. I need a formula to find out what each promo mean in the total result of the shops sales, to decide the promo for this coming Xmas, if we should stick to Buy 3/Get 1 free or change to Buy 2/Get 1 free, before Xmas. What should be done is get the sales result and set that as a % of total sales. In addition get the number of times we gave the free one (combination) and compare that as a percentage of total units sold…
Thanks,
Lulu