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. brand Value ($ billions): A measure of the brand's value in billions of dollars developed by forbes based on a variety of financial information about the brand.
1-Yr Value Change (%): The percentage change in the value of the brand over the previous year.
Brand Revenue ($ billions): The total revenue in billions of dollars for the brand.
a. Prepare a cross tabulation 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).
b. Prepare a frequency distribution for the data on Industry.
c. Prepare a frequency distribution for the data on brand Value ($ billions).
Table 2.12: Data for 82 of the most valuable brands

d. How has the cross tabulation helped in preparing the frequency distributions in parts (b) and (c)?
e. What conclusions can you draw about the type of industry and the brand value?

Brand Value1-Yr Value ($ billions) Change (%) Brand Revenue Brand Accenture Adidas Allianz Amazon.Com Technology Industry Other Other Financial Services ($ billions) 30.4 14.5 130.8 60.6 10 23 9.7 8.4 6.9 14.7 Heinz Herms Consumer Packaged Goods Automotive& Luxury 9.3 20 4.5 Wells Faro Financial Services Zara 91.2 13.5 14 Other 9.4