Data_analysis_homework

Data_analysis_homework - Data analysis homework I am the...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Data analysis homework I am the brand representative of brand A and I am now analyzing the performance of brand A among other four brands, B, C, D, X in 124 stores in two separate markets within 104 weeks to figure out whether our brand had a good performance and how to improve its position. 1. Firstly, I track the sales volume of my brand A through 104 weeks in two markets to know the trend of our sales. Since sales volume is continuous variable, I use Graphics- >Legacy Dialogs->Line. 101 97 93 89 85 81 77 73 69 65 61 57 53 49 45 41 37 33 29 25 21 17 13 9 5 1 Mean Units Sold (A) 250 200 150 100 50 0 32 4 Market ID Week From the chart, it can be concluded that market 4 has a larger average sales volume than Market 32 and the sales volume in both markets have a great deviation. At this point, I make an educational guess that this may be affected by the following factors, price, feature, display, competitors or weather. 2. Besides knowing my brand’s performance in both two markets, I need to know the inter- brand performance in these two markets. So I track the market share in both markets and total market of each brand.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Brand A Brand B Brand C Brand D Brand X Total Market 4 850796 27179 173070 352385 320521 1723951 49.35% 1.58% 10.04% 20.44% 18.59% 100.00% Market 32 263744 75029 68776 506109 214300 1127958 23.38% 6.65% 6.10% 44.87% 19.00% 100.00% Total 1114540 102208 241846 858494 534821 2851909 39.08% 3.58% 8.48% 30.10% 18.75% 100.00% Market Share in Market 4: Market Share in Market 32: Market Share in both Market 4 and Market 32 (Total Market): From this analysis, I know my brand A did a better job in market 4 than in market 32. We have almost 50% of market share in market 4 but less than 24% in market 32 and the leader in market
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/29/2008 for the course BUSI&CS CS559, MTK taught by Professor Lizhang during the Spring '08 term at Wisconsin.

Page1 / 6

Data_analysis_homework - Data analysis homework I am the...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online