Data Analysis and Forecasting

Background:

You are working in sales for AutoMobile Inc., a firm of car distributors, who are thinking of expanding into a new market. You have been asked to investigate the factors which determine vehicle ownership in various Asian countries; the most recent data you can find is for 2019, and is as shown in Cars3.xls.

To prepare for a presentation to management about opportunities for sales in Cyprus, carry out the following steps:

  1. Plot scatter graphs of vehicles per thousand population against income, population, population density and percentage of population in urban areas in the Excel file with which you believe there might be correlation. What do your results suggest? [20%]
  • For the variable which is more closely correlated to vehicles per thousand population, calculate the equation of the regression line, and interpret the results. [15%]
  • Plot scatter graphs of total vehicle ownership against income, population, population density per km^2 and population in urban areas. What do these graphs suggest? [20%]
  • For the variable which is more closely correlated to total vehicle ownership, calculate the equation of the regression line and interpret the results. [15%]
  • Which of the two regression equations do you think will be more useful to the company? [10%]
  • Data for Cyprus  is as follows:

Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount