Question

You're employed in the marketing department of an international car dealer. Your boss asks you to determine the most important factors influencing car sales. You receive the following data: Advertising budget in 100,000 s of MUs] Unit price [in 1,000 s of MUs Sales lin 1,000 s of units Number of dealerships Country 45 32 1 6 35 33 2 4 25 34 3 3 4 40 32 32 5 2 36 2 43 6 3 36 7 56 31 6 8 37 39 23 9 40 10 1 34 39 (a) What are the average sales (in 1,000s of units)? (b) What is the empirical standard deviation and the coefficient of variation? (c) What would be the coefficient of variation if sales were given in a different unit of quantity? (d) Determine the lower, middle, and upper quartile of sales with the help of the "weighted average method". (e) Draw a boxplot for the variable sales. (f) Are sales symmetrically distributed across the countries? Interpret the boxplot. (g) How are company sales concentrated in specific countries?Determine and interpret the Herfindahl index (h) Assume that total sales developed as follows over the years: 1998: +2 %; 1999: +4 %; 2000: +1 %. What is the average growth in sales for this period?