Survey monitor: Boomers and Gen the most spend hai als by mu po trip. 2010. May in Marc 12 13 14 15 16 18 19 20 21 Benz Stadium's food and beverage program ranko Short, K. 2015. Rewary beads, perpare 10 Tools, D. H. & Vanshy.S. 3. 2010. The grand mer: A financial goldmine with gray hair? The anal 118 CHAPTER 5. SECONDARY DATA AND PACKAGED INFORMATION 4. Table D displays the top six brands in the Gourmet of Sy? Which brand sells the highest percent of dollar Coffee category at McConnell's. Calculate the average volume on promotion (sum of any promo ). Whichte % discount (average of promo S) for each brand. The sells the lowest percent of dollar volume on promet average discount for Brand ABC has already been Which brand has the highest average percent discount calculated for you. Which brand has the top sales (sum Which brand has the lowest average percent discount TABLE D Sales on Promotion CATEGORY BRAND Sum of s Sum of Any Promo 5 Average of % Promos GOURMET COFFEE BRAND ABC S10.966.198 S8.061.744 73.54 BRAND DEF $6,040.463 S4,116,035 PRIVATE LABEL 54.136,165 $2.380,499 BAND GHI $3.094,665 SI 215.228 BRAND JKL 52.363,166 $1,333,725 BRAND MNO $2.292.106 $1.607.167 5. Table E displays the total revenue for coffee sold on and the average promotion price per ounce (Promo promotion for different sizes of Brand VAZ Gourmet Price/OZ. Which size has the highest promoted price Coffee sales at McConnell's for the latest 52 weeks. per ounce? Which size has the lowest promoted price Calculate the average promotion price (Promo Price). per Ounce? TABLE E Promotion Sales of Brand VAZ Gourmet Coffee by Size BASE SIZE Sum of Any Promo 5 Sum of Any Promo Units Promo Price Promo Price OZ 12 OUNCE 55,359,134 829,263 56.46 $0.54 20 OUNCE $1.503,100 132,883 11 OUNCE $1.002.204 154.987 10 OUNCE $196,976 29.234 16 OUNCE 5301 4.86 OUNCE S29 5 Endnotes 1. Lohr, S. (2013, Juary 1). The origins of "Big Data: An ety. nyport.com/2015/04/02/join-baseball-state-revolution mological detective story. The New York Times. Retrieved from 12-nifty-metrie littp://bit. blogi nytimes.com/2013/02/01/the-origins-of-big- 7. Mercedes-Benz Stadium (2018. January 25). Fun Survey Me data-an-etymological detective Rubus, 5. & Totty, M. (2013, March 11). From a molchill to MLS. Retrieved from http://mercedesben stadium.com most The Wall Street Journal, p. 31 mercedes-ben-vtitium-food beverage-program-fuck 3. IBM Cloud (2017). 10 litrende for 2017 and went for en citomer apetition. Retrieved from haps://www.ol. ihm.com/cgi-bin/milli-WR123ASUSEN Review 14.10.59 Groot (2017). God daty Trends Report 034 22nd ed. New York. p. 75 Hartwall. L. 2016 March 29. US certes world's largest quirks.com wewe pedomande tracking device partnership with statsport Proglice Sport. Retrieved from httpimofficesport comes ALA 500 Survey monitor: Boomers and Gen the most spend hai als by mu po trip. 2010. May in Marc 12 13 14 15 16 18 19 20 21 Benz Stadium's food and beverage program ranko Short, K. 2015. Rewary beads, perpare 10 Tools, D. H. & Vanshy.S. 3. 2010. The grand mer: A financial goldmine with gray hair? The anal 118 CHAPTER 5. SECONDARY DATA AND PACKAGED INFORMATION 4. Table D displays the top six brands in the Gourmet of Sy? Which brand sells the highest percent of dollar Coffee category at McConnell's. Calculate the average volume on promotion (sum of any promo ). Whichte % discount (average of promo S) for each brand. The sells the lowest percent of dollar volume on promet average discount for Brand ABC has already been Which brand has the highest average percent discount calculated for you. Which brand has the top sales (sum Which brand has the lowest average percent discount TABLE D Sales on Promotion CATEGORY BRAND Sum of s Sum of Any Promo 5 Average of % Promos GOURMET COFFEE BRAND ABC S10.966.198 S8.061.744 73.54 BRAND DEF $6,040.463 S4,116,035 PRIVATE LABEL 54.136,165 $2.380,499 BAND GHI $3.094,665 SI 215.228 BRAND JKL 52.363,166 $1,333,725 BRAND MNO $2.292.106 $1.607.167 5. Table E displays the total revenue for coffee sold on and the average promotion price per ounce (Promo promotion for different sizes of Brand VAZ Gourmet Price/OZ. Which size has the highest promoted price Coffee sales at McConnell's for the latest 52 weeks. per ounce? Which size has the lowest promoted price Calculate the average promotion price (Promo Price). per Ounce? TABLE E Promotion Sales of Brand VAZ Gourmet Coffee by Size BASE SIZE Sum of Any Promo 5 Sum of Any Promo Units Promo Price Promo Price OZ 12 OUNCE 55,359,134 829,263 56.46 $0.54 20 OUNCE $1.503,100 132,883 11 OUNCE $1.002.204 154.987 10 OUNCE $196,976 29.234 16 OUNCE 5301 4.86 OUNCE S29 5 Endnotes 1. Lohr, S. (2013, Juary 1). The origins of "Big Data: An ety. nyport.com/2015/04/02/join-baseball-state-revolution mological detective story. The New York Times. Retrieved from 12-nifty-metrie littp://bit. blogi nytimes.com/2013/02/01/the-origins-of-big- 7. Mercedes-Benz Stadium (2018. January 25). Fun Survey Me data-an-etymological detective Rubus, 5. & Totty, M. (2013, March 11). From a molchill to MLS. Retrieved from http://mercedesben stadium.com most The Wall Street Journal, p. 31 mercedes-ben-vtitium-food beverage-program-fuck 3. IBM Cloud (2017). 10 litrende for 2017 and went for en citomer apetition. Retrieved from haps://www.ol. ihm.com/cgi-bin/milli-WR123ASUSEN Review 14.10.59 Groot (2017). God daty Trends Report 034 22nd ed. New York. p. 75 Hartwall. L. 2016 March 29. US certes world's largest quirks.com wewe pedomande tracking device partnership with statsport Proglice Sport. Retrieved from httpimofficesport comes ALA 500