Assume that you are a data analyst and that the owners of the car sales data have approached you because they want to get more insights into their operations. When you click below, you will see the questions the data owners want to see answered. In all cases, they are only interested in actual Sales.

Question 1

The data owners are interested in determining whether there are differences between countries in terms of average sales price and average cost price. They also want to know whether they are differences between makes in a country. They are considering simply withdrawing from a country if average cost price is less than $300 below the average sales price, or to stop selling a make in a country if the average cost price for that make in that country is less than $300 the average sales price, but they are willing to reconsider in light of the data that you are gathering.

Question 2

The data owners have some concerns about their labor costs. They are therefore considering re-engineering their labor operations for at least some makes possibly for some countries. They therefore want to know the average labor costs by make overall and within a country for each make. They are considering simply outsourcing labor operations if the labor cost for a make or a make in a country is over $500, but they are willing to reconsider these limits in light of the data that you are gathering.

Question 3

The data owners want to know which proportion of Sales are generated for each make. They are interested in both the total sales price, and the number of sales. They are considering stop selling makes with very low proportion of sales.

Write a brief report (double spaced). The report should contain six sections. The first three sections should address the data owners and report what your visualizations say about the three questions the data owners were interested in. Please include the visualizations and dashboard you created in this part of the report.