Question

1. [36 marks] Each year, the business magazine Forbes publishes an annual ranking of the world’s most powerful or valuable brands. The 2018 Ranking of the Top 100 brands is given at the following webpage.

https://www.forbes.com/powerful-brands/list

1. Download this data into a suitable spreadsheet. Please do not spend money, careful copy/paste will do.

2. [7 marks] State and classify the level of measurement for each variable in this data set.

3. [8 marks] Prepare descriptive statistics tables with a comprehensive list of several numerical measures for the variables Brand Revenue, Brand Value, 1-Yr Value Change, and Company Advertising (e.g., number of elements and measures of absolute and relative location, variability and distribution shape). Print all your tables on a single sheet and insert this sheet as page 7 to your assignment submission.
4. [2 marks] Explain how you’ve dealt with different units ($M, $B) or missing data (careful if you haven’t ).

5. [3 marks] Briefly describe your general findings.

[20 marks total]

6. [4 marks] Develop the frequency or percent frequency distribution for the Industry variable and construct its bar and pie charts (sort industries in decreasing order of their number of brands).

Print your distribution and charts on a single sheet and insert this sheet as page 9.

7. [3 marks] Develop the frequency or percent frequency distribution for the Brand Value (BV ) variable and construct its histogram using the following seven intervals (compare to your software’s default classes, if available). Print your distribution and histogram on a single sheet and insert this sheet as page 10.

BV ≤ 8, 8 < BV ≤ 10, 10 < BV ≤ 15, 15 < BV ≤ 25, 25 < BV ≤ 50, 50 < BV ≤ 100, BV > 100.

8. [3 marks] Comment on the shape of this distribution (including potential outliers) and compare to your general findings. If inconsistent, maybe experiment with changes to the number or lengths of intervals.

1. [3 marks] Experiment with other suitable bar charts or dot plots to visualize the distribution of qualitative variables (e.g., along with the horizontal axis, use Rank or Brand for some single or side-by-side bar charts or one of the qualitative variables for a dot plot). Describe your experiences and findings. Print and clearly label any plots that you wish to show or refer to and insert them as page 11 (or 11a, 11b, . . . ).
2. j. [3 marks] Experiment with some other descriptive statistics to visualize or measure association between some of the other pairs of variables (e.g., prepare crosstabulations or scatter diagrams or compute ratios, covariances and correlation coefficients between Brand Value and 1-yr Value Change, Brand Value and Brand Revenue, Brand Revenue and Company Advertising, etc.). Describe your experiences and findings. Print and clearly label any relevant statistics or plots as page 12 (or 12a, 12b, . . . ).

Answer 1

PS: If the image is not visible, right click on image and select open image in new tab option.

After cleaning the data, the data is:

Advertising(In Billions S 3 Reeurants 2.0 Telecom .2 FInancial icrviccs Ccraumer Packaged eccos 0.G14 FInancial crviccs 0.858 Flnancial scrios 43 Automotie 2.9 Flnanclal Scrvics r Packaged GCCC。 2 T Mobllc Conoumar Packzacd Ecces 0.68 Apparal

b)

c)

d)

We have treated missing values as 0.

And Converted M (Millions) to B by dividing the value by 1000 wherever applicable.

e)

Brand Revenue for One Brand (Marlboro) is not available.

Brand Revenue has maximum variation ie the data is most spread out. This can be concluded from the Sample Variation.

f)

Frequency Table

Freq Bar Plot Tobacco Technology Retail Restaurants Media Luxury Leisure Financial Services Diversified Consumer Packaged Goods Business Services Beverages Automotive Apparel Alcohol Aerospace 20 13 12 10 15 20 25

Industry Pie Chart Aerospace Alcohol Apparel Automotive 312% 393% - Beverages 12% 20% | Business Services Consumer Packaged Goods Diversified Financial Services 4%, 1% 11% 996 Leisure 3% 4% Luxury Media Restaurants Retail Technology 6% 2% 13%

PS: We are only allowed to answer 4 parts per question.

We were unable to transcribe this image

Variable Brand Brand Value (in Billion $ 1-Yr Value Change(%) Brand Revenue (In Billions $ Company Advertising (In Billions $) Numcal ad Continuous Variable Industry Level Of Measurement Brand Name Numerical and Continuous Variable Numerical and Continuous Variable Numerical and Continuous Variable Categorical Variable

Brand Value in Billion $) 1-Yr Value Change(%) Brand Revenue (In Billions $) Company Advertising (in Billions $ Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 21.52 2.61 12.15 7.5 26.07 679.47 18.15 3.88 175.4 0.09 0.01 0.09 0.09 0.09 0.01 3,365.26 0.69 0.40 0.46 0.11 0.35 9.28 100 1.43 0.19 0.5575 0 1.95 3.79 2.41 1.67 57.12 5.80 38.9 62.8 58.01 4.95 1.83 335.5 0 182.8 2152.1 100 335.5 5711.7 100 142.974 100

Indust Aerospace Alcohol Apparel Automotive Beverages Business Services Consumer Packaged Goods11 Diversified Financial Services Leisure Luxu Media Restaurants Retail Technolo Telecomm Tobacco Transportation 12 4 4 13 2 2 20

Freq Bar Plot Tobacco Technology Retail Restaurants Media Luxury Leisure Financial Services Diversified Consumer Packaged Goods Business Services Beverages Automotive Apparel Alcohol Aerospace 20 13 12 10 15 20 25

Industry Pie Chart Aerospace Alcohol Apparel Automotive 312% 393% - Beverages 12% 20% | Business Services Consumer Packaged Goods Diversified Financial Services 4%, 1% 11% 996 Leisure 3% 4% Luxury Media Restaurants Retail Technology 6% 2% 13%