SG4011 Business Statistics and Data Analysis Assignment

Reference no: EM132519788 , Length: word count:1500

SG4011 Business Statistics and Data Analysis - University of East London

Assignment-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 European countries; the most recent data you can find is for 2018, and is as shown in Cars2.xls.

To prepare for a presentation to management about opportunities for sales in Turkey, 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 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 Turkey is as follows:

Income	Population	Population density	% urban
6.1	67	90	67

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 Turkey. The actual figures are 6.4 million and 96 per 1000 population. Explain why your predictions differ from these values.

Attachment:- Data Analysis and Forecasting.rar

Reference no: EM132519788

Questions Cloud

Think why interest rate cuts might not be effective : Central Banks have reduced interest rates. Evaluate if reducing interest rates will completely help economies avoid deep recession.

Discuss the requirements under aasb or ias : Discuss the requirements under AASB138 / IAS 38 Intangible Assets how Mag Ltd should account for the costs. Provide reasons

Explain the difference between implicit and explicit costs : Explain the difference between implicit and explicit costs. Give two examples of when an explicit cost is different from an implicit cost.

Why is encouraging or discouraging individuals : The discipline of economics is largely based on encouraging individuals to engage in certain activities and discouraging them from engaging in others

SG4011 Business Statistics and Data Analysis Assignment : SG4011 Business Statistics and Data Analysis Assignment Help and Solution, University of East London - Assessment Writing Service

What is the output of the leader : The inverse demand for a homogeneous-product Stackelberg duopoly is P = 40 - Q. The cost function for each firm is C(Q) = 4Q. What is the output of the leader?

What the abbreviation nsf is : The amount that an insurance company determines is the most that will be paid for a service is a called a(n)?The abbreviation NSF is

Policy modeling and policy analysis : We discussed many concepts to help with policy making such as Policy Modeling, Policy Analysis, Systems Modeling, Simulation Models,

Going out of business sale : After "45 Years at the Same Location!", Sam's Jewelry Store is holding a "Going Out of Business Sale," and Sam has announced that he intends to retire

User Account

All Pages