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
|