I need help with the following Case Study!

Vehicle colors differ among types of vehicle in different regions. Here are data on the most popular colors in 2007 for several different regions of the world: Color NorthAmerica SouthAmerica Europe China SouthKorea Japan

Silver 19 26 28 24 21 27 White 16 11 4 16 18 24 Gray 13 14 16 3 19 12 Black 13 20 24 19 20 16 Blue 11 8 13 17 9 10 Red 7 10 6 9 6 3 Brown 7 7 4 1 6 2 Other 9 4 5 11 1 6

• Suppose you work for a paint supplier and you wish to analyze the colors of international vehicle sales. Analyze the data provided in the chart above. Prepare a short 3 - 5 page report of your findings.

  The report should contain at a minimum the following:

  Summary of findings or report graphs charts data set

Compare the vehicle color preferences for the regions of the world presented in this table. Include pie charts and bar charts in your comparisions. Write a repoty of your findings with an emphasis on similarities and differences across regions. Include recommendations related to marketing and advertising of vehicles in these regions. You need to look at the data and ask yourself some questions so you can prepare a report. Here are some sample questions. You can make up your own. 1. Are the best selling colors the same for all the countries? 2. If you had to eliminate three color offerrings which three would you chose? 3. What countries have the most similar color distribution?