A SU Brand Value Q- Search Sheet Home Insert Draw Page Layout Formulas Data Review View 2+ Share a Out 12 Times New... A- A .itasun General Wrap Text 47. Copy Paste B 1 U EE Merge Center S. % 2 00 . .30 Insert Format Delete Conditional Format Formatting as Table Format Styles Clear. Sort & Filter Find & Select 11 x - 7 A B C D E F G H 1 J K L M N 0 O R S T U w 1-Yr Value Chunge (%) 10 23 Brand Revenues billions) 31.4 Brand Value (S billions) 9.7 8.4 6.9 147 18 10.9 5.6 7.7 5 44 5 ] LO -9 12 14.5 1508 606 33.8 S5.2 149.3 83.3 KL.7 3 41.8 15.9 4.4 568 13 5.3 8.7 8.5 7 -11 21 13 6. -9 1 1 7 7 51 1 Industry 2 Accenture Other 3 Adidas Othe 4 Allianz Financial Services 3 Amazoo, Technology 6 American Financial Savo 7 Audi Automotive & Luxury 8 AXA Financial Savas 9 Bank of A Financial Services 10 Beeing Other 11 Burberry Automotive & Luxury 12 Canan Technology 1 Caterpillar Other 14 Chanel Automotive & Luxury 15 Chase Financial Services 16 Coach Automotive & Luxury IT Colete Consult Packaged Goods 18 Calil Sus Financial San 19 Danone Consult Packaged Goods 20 Du Technology 21 buy Technology 22 Triesun Technology 2.1 ESPN Other 24 Testee Lane Consumer Packaged Gands 25 Facebook Technology 26 FedEx Other 27 Ford Automwitive & Luxury 28 Fox Other 29 Frio-Lay Consulta Packaged Goods 30 daril ElUhE 3. Gillette Consumer Packaged Goods 32 Goldman ! L'inancial Services 31 Gaugle Technology .34 Gucci Automotive & Luxury 35 H&M Other 36 Heineken Other Data + -9 13 -73 39 42 13.3 S6.9 6.3 34.6 10.4 14 15 7.9 5.7 11.. 6.1 8.5 5.9 12.9 5.4 13.7 S. 10.6 10.2 11.6 34.2 18.3 12 15 4 10 14 2 6 5.1 443 130 117 11.1 132.1 8 41.7 43.5 4.7 18.3 47.3 12.1 16.1 7 9 9 -15 26 1 12 7 6 Entor + 100% A SU Brand Value Q- Search Sheet Home Insert Draw Page Layout Formulas Data Review View 2+ Share a Out Times New... 12 - A- AT Wrap Text General 47. 0 .itasun Till Clear Copy Paste BI U A- Merge Center S. 00 . .30 Insert Format Delete Conditional Format Formatting as Table Format Styles Sort & Filter Find & Select 11 X - 7 A B D E F H 1 X L M N 0 P R S T U V w X 7 7 5.6 2 20 -16 12 21 5 5 153 10.1 152 6.5 50.2 IIS 52 109 1 6.4 8.7 9.1 6.2 7 16.9 6 44 4.5 119.9 71.8 1049 49.7 104.5 35.5 1182 33 43.1 36.2 7.1 7.1 8 4 -30 14 -6 13 1 1 16 16.6 9 36 Heincs Other 37 Heinz Court Packaged Goods 38 Horas Automotive & Luxury 39 Hewlett-P. Testinulogy 10 lume Dor Other 41 TISEC Financial Services 42 Hyundai Automotive & Luxury 42 IBM Teamlogy 44 IKEA Other 45 ING Financial Services 46 Intel Technology 47 J.P. Morg: Financial Services 48 Jotun Deon Other 49 Kellogg's Con Packaged Goods 50 Kual Cunun Packaged Goods 51 Lancomo Consumer Packaged Goods 52 Lexus Auctive & Luxury 5.2 L'Oral Corner Packaged Goods 54 Louis Vuit Automotive & Luxury 55 Marlboro Other 56 Mastercare Financial Services 57 McDonalther 38 Microsoft Technology 59 MTV Other 60 Nate Congrike Packaged Goods 61 NIKE Other 62 Nintendo Testinulogy 61 Nissam Auctive & Luxury 64 Nokia Technology 65 Pampers Consumer Packaged Goods 66 Philips Other 67 Porsche Automotive & Luxury GR Prada Automotive & Luxury 6) Ralph Lau Other 70 Rolex Automotive & Luxury 71 Sanamke Fixial Servic's 72 SAP Testimology 71 Since Other 74 Sony Testimulogy Data + 8 5 4 194 567 5.6 11.8 18 2 8 6.9 7 9.6 7.1 -7 18 14 -39 17 55 12 14 18.7 10.6 9.4 21.11 74 883 77.8 3.1 11.3 22.7 7.6 108.5 38. . 104 31.9 17.8 24 23 28 14 71 64 74 6 19.6 13.7 6.6 -2 28 1 20 4.5 57.3 20.3 100.6 69.5 Entor EP + 100% A SU Brand Value Q- Search Sheet Home Insert Draw Page Layout Formulas Data Review View 2+ Share a Out AutoSum Times New... 12 A- A Wrap Text General 47. 0 Copy Paste U A- $. Merge Center % 2 00 . Inser .30 Format Conditional Format Formatting as Table Delete Format Styles Clear Sort & Filter Find & Select 11 X 7 C D E F G H 1 J K L M N 0 O R S T U V w 9.1 -10 1.3 1 1 7.1 4 7 18. 28.4 166 16 9 8 + -7 7.4 39.4 56.7 5.6 11.8 18.2 8 8 6.9 7 9.6 2.1 5.7 7 6.4 18 14 19 17 -55 A B 50 kr Consumer Packaged Goods 51 Lancome Consumer Packaged Goods 51 Lexus Automotive & Luxury 52 L'Orbal Consumer Packaged Goods 54 Lorais Vuir Automotive & Trxury 35 Marlboro Other 56 Mastercard Financial Savice 57 McDecek Othe 58 Microsoll Toluciology 59 MIV Othe 60 Nestle Consumer Packaged Goods 61 NIKE Other 62 Nintendo Technology 16 Nissan Automotive & Luxury 64 Nokin Technology 65 Pampers Consumer Packaged Goods 66 Philips Other 67 Porsche Automotive & Luxury 68 Pada Automotive & LUXURY 69 Halph Lau Out 70 Rolex Automotive & Luxury 71 Santander Financial Services 72 SAP Technology 7.! Siemens Other 74 Sony Technology 75 Sturhucks Other 76 Sulway Other 77 Thomson Other 78 UPS Orhy 9 Varizon Other 80 Visa Financial Sarxes 8. Volkswag Automotive & LUCY 82 Wells Far Financial Services 81 Zara Other 84 10.6 9.4 236 7.4 88.3 77.8 3.1 11.3 23.7 7.6 109.5 38.8 10.4 19 178 3.+ 6.7 4.5 57.3 20.3 100.6 19.5 12 14 16 23 28 1-4 6 18 1 1 20 9 9 17 19.6 13.7 1.6 6.9 5.7 9.4 10.2 193 14.2 8.: 9 -10 13 0 18.1 72 541 115.8 10.4 145.7 91.2 13.5 12 16 -1.1 11 86 87 88 Data + Enter + 100% Each year Forbes ranks the world's most valuable brands. A portion of the data for 82 of the brands in the 2013 Forbes list is shown in Table 2.12 (Forbes website, February, 2014). The data set includes the following variables: Brand: The name of the brand. Industry: The type of industry associated with the brand, labeled Automotive & Luxury, Consumer Packaged Goods, Financial Services, Other, Technology. A measure of the brand's value in billions of dollars developed billions of dollars developed by Forbes based on a variety of financial information about the brand. Brand Value ($ billions): 1-Yr Value Change (%): The percentage change in the value of the brand over the previous year. The total revenue in billions of dollars for the brand. . Brand Revenue ($ billions): Click on the datafile logo to reference the data. DATA file TABLE 2.12 DATA FOR 82 OF THE MOST VALUABLE BRANDS Brand Industry Accenture Other Adidas Other Allianz Financial Services Amazon.Com Technology Brand Value ($ billions) 9.7 8.4 6.9 14.7 1-Yr Value Change (%) 10 23 5 44 Brand Revenue ($ billions) 30.4 14.5 130,8 60.6 . Heinz Herms Consumer Packaged Goods Automotive & Luxury 5.6 9.3 4.4 4.5 20 Wells Fargo Zara Financial Services Other 9 9.4 -14 11 91.2 13.5 a. Prepare a crosstabulation of the data on Industry (rows) and Brand Value ($ billions). Use classes of 0-10, 10-20, 20-30, 30-40, 40-50, and 50-60 for Brand Value ($ billions). If an amount box does not require an entry, leave it blank or enter "0". Brand Value ($ billions) Industry 0-9.9 10-19.9 20-29.9 30-39.9 40-49.9 50-60 Total Automotive & Luxury 3 2 0 0 a. Prepare a crosstabulation of the data on Industry (rows) and Brand Value ($ billions). Use classes of 0-10, 10-20, 20-30, 30-40, 40-50, and 50-60 for Brand Value ($ billions). If an amount box does not require an entry, leave it blank or enter "O". Brand Value ($ billions) Industry 0-9.9 10-19.9 20-29.9 30-39.9 40-49.9 50-60 Total Automotive & Luxury 3 2 1 0 0 0 Consumer Packaged Goods 3 1 0 M 0 0 0 4 Financial Services 0 0 0 0 % 0 0 0 Other o 0 0 0 0 0 o Technology 3 0 0 0 0 0 o 0 Total 0 o 0 0 b. Prepare a frequency distribution for the data on Industry. Industry Total Automotive & Luxury 0 Consumer Packaged Goods 0 Financial Services 0 Other 0 Technology o Total 0 C. Prepare a frequency distribution for the data on Brand Value ($ billions). | Brand Value (8 billions) Frequency 0-10 0 10-20 Industry Total Automotive & Luxury o Consumer Packaged Goods Financial Services .... Other X Technology Total 0 X c. Prepare a frequency distribution for the data on Brand Value ($ billions). Brand Value ($ billions) Frequency 0-10 0 10-20 0 20-30 0 X 30-40 0 40-50 0 50-60 0 Total 0 d. How has the crosstabulation helped in preparing the frequency distributions in parts (b) and (c)? The right margin shows the frequency distribution for the fund type variable and the bottom margin shows the frequency distribution for the brand value e. What conclusions can you draw about the type of industry and the brand value? Higher brand values are associated with the technology brands. A SU Brand Value Q- Search Sheet Home Insert Draw Page Layout Formulas Data Review View 2+ Share a Out 12 Times New... A- A .itasun General Wrap Text 47. Copy Paste B 1 U EE Merge Center S. % 2 00 . .30 Insert Format Delete Conditional Format Formatting as Table Format Styles Clear. Sort & Filter Find & Select 11 x - 7 A B C D E F G H 1 J K L M N 0 O R S T U w 1-Yr Value Chunge (%) 10 23 Brand Revenues billions) 31.4 Brand Value (S billions) 9.7 8.4 6.9 147 18 10.9 5.6 7.7 5 44 5 ] LO -9 12 14.5 1508 606 33.8 S5.2 149.3 83.3 KL.7 3 41.8 15.9 4.4 568 13 5.3 8.7 8.5 7 -11 21 13 6. -9 1 1 7 7 51 1 Industry 2 Accenture Other 3 Adidas Othe 4 Allianz Financial Services 3 Amazoo, Technology 6 American Financial Savo 7 Audi Automotive & Luxury 8 AXA Financial Savas 9 Bank of A Financial Services 10 Beeing Other 11 Burberry Automotive & Luxury 12 Canan Technology 1 Caterpillar Other 14 Chanel Automotive & Luxury 15 Chase Financial Services 16 Coach Automotive & Luxury IT Colete Consult Packaged Goods 18 Calil Sus Financial San 19 Danone Consult Packaged Goods 20 Du Technology 21 buy Technology 22 Triesun Technology 2.1 ESPN Other 24 Testee Lane Consumer Packaged Gands 25 Facebook Technology 26 FedEx Other 27 Ford Automwitive & Luxury 28 Fox Other 29 Frio-Lay Consulta Packaged Goods 30 daril ElUhE 3. Gillette Consumer Packaged Goods 32 Goldman ! L'inancial Services 31 Gaugle Technology .34 Gucci Automotive & Luxury 35 H&M Other 36 Heineken Other Data + -9 13 -73 39 42 13.3 S6.9 6.3 34.6 10.4 14 15 7.9 5.7 11.. 6.1 8.5 5.9 12.9 5.4 13.7 S. 10.6 10.2 11.6 34.2 18.3 12 15 4 10 14 2 6 5.1 443 130 117 11.1 132.1 8 41.7 43.5 4.7 18.3 47.3 12.1 16.1 7 9 9 -15 26 1 12 7 6 Entor + 100% A SU Brand Value Q- Search Sheet Home Insert Draw Page Layout Formulas Data Review View 2+ Share a Out Times New... 12 - A- AT Wrap Text General 47. 0 .itasun Till Clear Copy Paste BI U A- Merge Center S. 00 . .30 Insert Format Delete Conditional Format Formatting as Table Format Styles Sort & Filter Find & Select 11 X - 7 A B D E F H 1 X L M N 0 P R S T U V w X 7 7 5.6 2 20 -16 12 21 5 5 153 10.1 152 6.5 50.2 IIS 52 109 1 6.4 8.7 9.1 6.2 7 16.9 6 44 4.5 119.9 71.8 1049 49.7 104.5 35.5 1182 33 43.1 36.2 7.1 7.1 8 4 -30 14 -6 13 1 1 16 16.6 9 36 Heincs Other 37 Heinz Court Packaged Goods 38 Horas Automotive & Luxury 39 Hewlett-P. Testinulogy 10 lume Dor Other 41 TISEC Financial Services 42 Hyundai Automotive & Luxury 42 IBM Teamlogy 44 IKEA Other 45 ING Financial Services 46 Intel Technology 47 J.P. Morg: Financial Services 48 Jotun Deon Other 49 Kellogg's Con Packaged Goods 50 Kual Cunun Packaged Goods 51 Lancomo Consumer Packaged Goods 52 Lexus Auctive & Luxury 5.2 L'Oral Corner Packaged Goods 54 Louis Vuit Automotive & Luxury 55 Marlboro Other 56 Mastercare Financial Services 57 McDonalther 38 Microsoft Technology 59 MTV Other 60 Nate Congrike Packaged Goods 61 NIKE Other 62 Nintendo Testinulogy 61 Nissam Auctive & Luxury 64 Nokia Technology 65 Pampers Consumer Packaged Goods 66 Philips Other 67 Porsche Automotive & Luxury GR Prada Automotive & Luxury 6) Ralph Lau Other 70 Rolex Automotive & Luxury 71 Sanamke Fixial Servic's 72 SAP Testimology 71 Since Other 74 Sony Testimulogy Data + 8 5 4 194 567 5.6 11.8 18 2 8 6.9 7 9.6 7.1 -7 18 14 -39 17 55 12 14 18.7 10.6 9.4 21.11 74 883 77.8 3.1 11.3 22.7 7.6 108.5 38. . 104 31.9 17.8 24 23 28 14 71 64 74 6 19.6 13.7 6.6 -2 28 1 20 4.5 57.3 20.3 100.6 69.5 Entor EP + 100% A SU Brand Value Q- Search Sheet Home Insert Draw Page Layout Formulas Data Review View 2+ Share a Out AutoSum Times New... 12 A- A Wrap Text General 47. 0 Copy Paste U A- $. Merge Center % 2 00 . Inser .30 Format Conditional Format Formatting as Table Delete Format Styles Clear Sort & Filter Find & Select 11 X 7 C D E F G H 1 J K L M N 0 O R S T U V w 9.1 -10 1.3 1 1 7.1 4 7 18. 28.4 166 16 9 8 + -7 7.4 39.4 56.7 5.6 11.8 18.2 8 8 6.9 7 9.6 2.1 5.7 7 6.4 18 14 19 17 -55 A B 50 kr Consumer Packaged Goods 51 Lancome Consumer Packaged Goods 51 Lexus Automotive & Luxury 52 L'Orbal Consumer Packaged Goods 54 Lorais Vuir Automotive & Trxury 35 Marlboro Other 56 Mastercard Financial Savice 57 McDecek Othe 58 Microsoll Toluciology 59 MIV Othe 60 Nestle Consumer Packaged Goods 61 NIKE Other 62 Nintendo Technology 16 Nissan Automotive & Luxury 64 Nokin Technology 65 Pampers Consumer Packaged Goods 66 Philips Other 67 Porsche Automotive & Luxury 68 Pada Automotive & LUXURY 69 Halph Lau Out 70 Rolex Automotive & Luxury 71 Santander Financial Services 72 SAP Technology 7.! Siemens Other 74 Sony Technology 75 Sturhucks Other 76 Sulway Other 77 Thomson Other 78 UPS Orhy 9 Varizon Other 80 Visa Financial Sarxes 8. Volkswag Automotive & LUCY 82 Wells Far Financial Services 81 Zara Other 84 10.6 9.4 236 7.4 88.3 77.8 3.1 11.3 23.7 7.6 109.5 38.8 10.4 19 178 3.+ 6.7 4.5 57.3 20.3 100.6 19.5 12 14 16 23 28 1-4 6 18 1 1 20 9 9 17 19.6 13.7 1.6 6.9 5.7 9.4 10.2 193 14.2 8.: 9 -10 13 0 18.1 72 541 115.8 10.4 145.7 91.2 13.5 12 16 -1.1 11 86 87 88 Data + Enter + 100% Each year Forbes ranks the world's most valuable brands. A portion of the data for 82 of the brands in the 2013 Forbes list is shown in Table 2.12 (Forbes website, February, 2014). The data set includes the following variables: Brand: The name of the brand. Industry: The type of industry associated with the brand, labeled Automotive & Luxury, Consumer Packaged Goods, Financial Services, Other, Technology. A measure of the brand's value in billions of dollars developed billions of dollars developed by Forbes based on a variety of financial information about the brand. Brand Value ($ billions): 1-Yr Value Change (%): The percentage change in the value of the brand over the previous year. The total revenue in billions of dollars for the brand. . Brand Revenue ($ billions): Click on the datafile logo to reference the data. DATA file TABLE 2.12 DATA FOR 82 OF THE MOST VALUABLE BRANDS Brand Industry Accenture Other Adidas Other Allianz Financial Services Amazon.Com Technology Brand Value ($ billions) 9.7 8.4 6.9 14.7 1-Yr Value Change (%) 10 23 5 44 Brand Revenue ($ billions) 30.4 14.5 130,8 60.6 . Heinz Herms Consumer Packaged Goods Automotive & Luxury 5.6 9.3 4.4 4.5 20 Wells Fargo Zara Financial Services Other 9 9.4 -14 11 91.2 13.5 a. Prepare a crosstabulation of the data on Industry (rows) and Brand Value ($ billions). Use classes of 0-10, 10-20, 20-30, 30-40, 40-50, and 50-60 for Brand Value ($ billions). If an amount box does not require an entry, leave it blank or enter "0". Brand Value ($ billions) Industry 0-9.9 10-19.9 20-29.9 30-39.9 40-49.9 50-60 Total Automotive & Luxury 3 2 0 0 a. Prepare a crosstabulation of the data on Industry (rows) and Brand Value ($ billions). Use classes of 0-10, 10-20, 20-30, 30-40, 40-50, and 50-60 for Brand Value ($ billions). If an amount box does not require an entry, leave it blank or enter "O". Brand Value ($ billions) Industry 0-9.9 10-19.9 20-29.9 30-39.9 40-49.9 50-60 Total Automotive & Luxury 3 2 1 0 0 0 Consumer Packaged Goods 3 1 0 M 0 0 0 4 Financial Services 0 0 0 0 % 0 0 0 Other o 0 0 0 0 0 o Technology 3 0 0 0 0 0 o 0 Total 0 o 0 0 b. Prepare a frequency distribution for the data on Industry. Industry Total Automotive & Luxury 0 Consumer Packaged Goods 0 Financial Services 0 Other 0 Technology o Total 0 C. Prepare a frequency distribution for the data on Brand Value ($ billions). | Brand Value (8 billions) Frequency 0-10 0 10-20 Industry Total Automotive & Luxury o Consumer Packaged Goods Financial Services .... Other X Technology Total 0 X c. Prepare a frequency distribution for the data on Brand Value ($ billions). Brand Value ($ billions) Frequency 0-10 0 10-20 0 20-30 0 X 30-40 0 40-50 0 50-60 0 Total 0 d. How has the crosstabulation helped in preparing the frequency distributions in parts (b) and (c)? The right margin shows the frequency distribution for the fund type variable and the bottom margin shows the frequency distribution for the brand value e. What conclusions can you draw about the type of industry and the brand value? Higher brand values are associated with the technology brands