Data analysis and forecasting

Assignment Help Other Subject

Reference no: EM132935846 , Length: word count:2000

SG4011 Business Statistic and Data Analysis, University of East London

Assignment-Data Analysis and Forecasting

Details of the task

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:

a.) 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?

b.) For the variable which is more closely correlated to vehicles per thousand population, calculate the equation of the regression line, and interpret the results.

c.) 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?

d.) For the variable which is more closely correlated to total vehicle ownership, calculate the equation of the regression line and interpret the results.

e.) Which of the two regression equations do you think will be more useful to the company?

f.) Data for Cyprus is as follows:

Income	Population	Population density	% urban
6.71	73.7	99	73.3

Use this data and the regression equations calculated in b.) and d.) above to predict the total number of vehicles and number of vehicles per 1000 population for Cyprus . The actual figures are 7.04 million and 105.6 per 1000 population. Explain why your predictions differ from these values.

Attachment:- Data Analysis and Forecasting.rar

Reference no: EM132935846

Questions Cloud

Describe egyptian last judgement : Describe Egyptian's Last Judgement?

Medecine walk by richard wagamese : Prove that the novel contains each of the four types of conflict. Locate and copy out three quotations for each type of conflict that in your opinion as a sensi

Compute the net present value using a discount rate : Compute the net present value using a discount rate of 15% Should the proposal be accepted using this discount rate

Where did gladwell complete his college internship : 1. We've had an opportunity to meet some extraordinary individuals in this book. Looking back, which chapter and which individuals--the violinists, The Beatles,

Data analysis and forecasting : Data Analysis and Forecasting - calculate the equation of the regression line and interpret the results

How much cash dividends would ordinary shares received : If preference share is non-cumulative, how much cash dividends would ordinary shares received in 2014

What amount of dividend revenue should IT Corp report : IT Corp. owns 5% interest in Chili Company. What amount of dividend revenue should IT Corp. report in its 2020 income statement

Describe legal framework for collective bargaining for cupe : Describe the legal framework for collective bargaining for CUPE (Canadian union OF Public Employees)

How much is the impairment loss : Reduction of principal to P4,000,000. Reduction of interest to 10% payable annually beginning December 31, 2021. How much is the impairment loss

User Account

All Pages