MEBIK Econometrics
Replenishment date:
13.11.2020
Sales:
less 10
Refunds:
0
Reviews:
0
Description
The student must complete one of the examples listed below:
Example 1. Construction of a spatial model of the relationship between the volume of sales of one of the company's products from several factor attributes. Let there be some data on the volume of sales of one of the company's products. Based on a meaningful analysis, a list of indicators that are supposed to be included in the model has been compiled, and a table of initial data has been compiled (Table 1.). The problem is solved using the methods of correlation and regression analysis.
1. It is necessary to compile a matrix of paired correlation coefficients and, on its basis, give recommendations on including certain factors in the model.
Decision. Pairwise correlation coefficients are calculated based on formulas (1) and (2):
(1).
Table 1.
Volume
implementation
Time
Advertising
Price
Price con-
kurenta
Index
consumer.
costs
у
х1
х2
х3
х4
х5
126
137
148
191
274
370
432
445
367
367
321
307
331
345
364
384
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
4
4,8
3,8
8,7
8,2
9,7
14,7
18,7
19,8
10,6
8,6
6,5
12,6
6,5
5,8
5,7
15,0
14,8
15,2
15,5
15,5
16,0
18,1
13,0
15,8
16,9
16,3
16,1
15,4
15,7
16,0
15,1
17,0
17,3
16,8
16,2
16,0
18,0
2,02
15,8
18,2
16,8
17,0
18,3
16,4
16,2
17,7
16,2
100,0
98,4
101,2
103,5
104,1
107,0
107,4
108,5
108,3
109,2
110,1
110,7
110,3
111,8
112,3
112,9
Example 1. Construction of a spatial model of the relationship between the volume of sales of one of the company's products from several factor attributes. Let there be some data on the volume of sales of one of the company's products. Based on a meaningful analysis, a list of indicators that are supposed to be included in the model has been compiled, and a table of initial data has been compiled (Table 1.). The problem is solved using the methods of correlation and regression analysis.
1. It is necessary to compile a matrix of paired correlation coefficients and, on its basis, give recommendations on including certain factors in the model.
Decision. Pairwise correlation coefficients are calculated based on formulas (1) and (2):
(1).
Table 1.
Volume
implementation
Time
Advertising
Price
Price con-
kurenta
Index
consumer.
costs
у
х1
х2
х3
х4
х5
126
137
148
191
274
370
432
445
367
367
321
307
331
345
364
384
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
4
4,8
3,8
8,7
8,2
9,7
14,7
18,7
19,8
10,6
8,6
6,5
12,6
6,5
5,8
5,7
15,0
14,8
15,2
15,5
15,5
16,0
18,1
13,0
15,8
16,9
16,3
16,1
15,4
15,7
16,0
15,1
17,0
17,3
16,8
16,2
16,0
18,0
2,02
15,8
18,2
16,8
17,0
18,3
16,4
16,2
17,7
16,2
100,0
98,4
101,2
103,5
104,1
107,0
107,4
108,5
108,3
109,2
110,1
110,7
110,3
111,8
112,3
112,9