Analyze the correlation matrix

Assignment Help Applied Statistics

Reference no: EM131964422

Topic - Business Forecasting

Question: Use word and any formulas put in excel.

A retailer of motorcycle accessories wants to develop a model to make sales forecasts based on the dataset in the table below. The first column is sales for each geographic region. Units are millions of euros. We have data for 11 regions; there are more regions for which we have no data. The second column is number of retail outlets in each region. The third column is the number of motorcycles registered in each region. Units are millions of motorcycles.

a. First, please analyze the correlation matrix.

b. Can you develop an effective predictive equation from the results of multiple regression on these data?

c. In region 12 the number of outlets is 2,500 and the number of motorcycles is 20.2 million. Can sales be forecast for region 12?

d. Discuss the accuracy of the forecast for region 12 (item c above).

e. How can this regression equation be improved?

Sales	Outlets	Motorcycles
52.3	2011	24.6
26	2850	22.1
20.2	650	7.9
16	480	12.5
30	1694	9
46.2	2302	11.5
35	2214	20.5
3.5	125	4.1
33.1	1840	8.9
25.2	1233	6.1
38.2	1699	9.5

Reference no: EM131964422

Questions Cloud

Advantages and disadvantages to the transportation industry : What are the advantages and disadvantages to the Transportation industry of using Traffic Network Analysis Technology?

What is wacc of cto transport : CTO Transport has an aftertax cost of debt of 6.8 percent, a cost of equity of 14.2 percent and a cost of preferred stock of 8.5 percent.

Company pays from the sale of the equipment : The tax rate is 35%. What is the tax that the company pays from the sale of the equipment?"

Can you think of a single instance in which the marketing : Can you think of a single instance in which the marketing mix (4 Ps) has not been adapted in some way for a universal need product that is sold in at least two

Analyze the correlation matrix : Topic - Business Forecasting. First, please analyze the correlation matrix. Discuss the accuracy of the forecast for region 12 (item c above)

Can be eliminated through diversification : A systemic risk is one that Can be eliminated through diversification, Can be the cause of the collapse of an entire system.

What is the appropriate classification of this lease : Ownership of the machine returns to Justins after the 15-year lease expires. The machine is expected to have an economic life of 17 years.

Develop a ppt discussing predictive maintenance principles : Research and develop a ppt discussing predictive maintenance principles. How aviation maintenance managers use predictive maintenance within their organization.

What is the governing law here : There is a term in the contract stated that should the dispute arise will be heard in the Arbitation Centre in Hong Kong. What is the governing law here?

User Account

All Pages