Guidance and Requirements • This consists of five questions. All questions are compulsory. Please make sure your answer to each question follows a clear and logical approach. • The computations, analysis and charts should be done in Excel or any other application with similar capabilities (Numbers, SPSS, R, MiniTaB). • Work should be presented and submitted as PDF file. Please be careful to preserve your original formatting when converting your Excel file into PDF. In the Applewood Auto Group data set, there are four variables for each vehicle sale for last month: age of buyer, amount of profit, location and type of vehicle sold. You are required to put together a report that summarises the data and presents it in a logical manner keeping in mind the following requirements: 1. Your manager would like you to summarise last month's sales by location and a. Create a frequency table for vehicles sold last month at Applewood Auto Group by Location b. Create a Relative frequency table showing the percentage of total cars sold at each of the four locations c. Create a Bar chart of the Number of Vehicles Sold by Location d. Determine the mean, median, mode, starndard deviation, range of profits including the total profit, lowest amount of profit and highest amount of profit. 2. We return to the situation where the boss of the Applewood Auto Group wants you to develop tables, charts and graphs to show the typical profit for each sale. The data set reports the profit on each of the 180 vehicles sold last month at the four Applewood locations. a. Construct a histogram of the Profits on 180 vehicles sold at Applewood Auto Group b. Discuss the histogram results 3. Refer to the Applewood Auto Group data. Your manager would like to know more about the variable, age of the buyer. a. Develop a box plot to show the distribution of the age of the buyer b. Discuss the boxplot and the summary statistics calculated 4. The Applewood Auto Group's marketing department believes younger buyers purchase vehicles on which lower profits are earned and the older buyers purchase vehicles on which higher profits are earned. They would like to use this information as part of an upcoming advertising campaign to try to attract older buyers on which the profits tend to be higher. a. Develop a scatter diagram depicting the relationship between vehicle profits and age of the buyer b. Discuss the shape of the scatter diagram and its relevance to the data analysed. c. Use your statistical software to calculate the correlation coefficient and the coefficient of determination. d. Based on your analysis, should Applewood Auto Group go ahead with the advertising campaign as planned? Explain your results. Mean house price by region or country, 1986–2013