forecast.zip (7Kb)
"" . - (, ) . ? , , . , : "" , , , - . , : , , , .., : , .. , , . . , ( ) , , , -, () . , . , . , , , " ", , .
, , , , (). , - . () () .
I. ,
, "" . , . : :
;
, , , ( , );
( " " ), ( " " ).
|
|
, , , . (. 5.1) , F1, F2, F3.
5.1
(F1-F3), "" (Q)
Q | F1 | F2 | F3 | |
.97 | ||||
.97 | ||||
.97 | ||||
.97 | ||||
.97 | ||||
.97 | ||||
.97 | ||||
.97 | ||||
.97 |
"" , :
" "
;
;
;
;
;
" "
;
;
;
;
.
II. " "
: (" ") , "" . , , , , ( - F1-F3, . . 5.1).
. 5.1.
. 5.2 (Q) (F1, F2, F3). , , MS Excel, "CORREL". , " " F1 F3, F2 .
5.2
" "
CORR F1 | CORR F2 | CORR F3 | ||
0,462 | -0,057 | 0,458 | ||
Q | F1 | F2 | F3 | |
.97 | ||||
.97 | ||||
.97 | ||||
.97 | ||||
.97 | ||||
.97 | ||||
.97 | ||||
.97 | ||||
.97 |
III. " "
" " 1997 1997. , " " ( , . 5.3). , . , "FORECAST" MS Excel, . "FORECAST" . 5.3.
|
|
5.3
"FORECAST" MS Excel
F1 | ||
.97 | ||
.97 | ||
.97 | ||
.97 | ||
.97 | ||
.97 | ||
.97 | ||
.97 | ||
.97 | ||
.97 | =FORECAST(A11;B2:B10;A2:A10) |
. 5.4 " " " ".
5.4
" " ( F1, F2 )
F1 | F3 | |
.97 | ||
.97 | ||
.97 | ||
.97 | ||
.97 | ||
.97 | ||
.97 | ||
.97 | ||
.97 | ||
.97 | ||
.98 | ||
.98 | ||
.98 |
IV. " "
, , , " ". " ", ( ). . MS Excel . 5.5.
5.5
" " MS Excel
D | E | F | ||||
Q | F1 | Q1 TREND | F3 | Q3 TREND | ||
.97 | ||||||
: | : | : | : | |||
.97 | ||||||
.97 | =(D11+F11)/2 | =FORECAST(C11;B2:B10;C2:C10) | =FORECAST(E11;B2:B10;E2:E10) |
, " ". " " . . 5.6.
5.6
" "
Q | Q TREND | F1 | Q1 TREND | F3 | Q3 TREND | |
.97 | ||||||
: | : | : | : | |||
.97 | ||||||
.97 | 46,3 | 48,9 | 43,7 | |||
.98 | 44,9 | 47,7 | 42,1 | |||
.98 | 45,2 | 47,7 | 42,7 | |||
.98 | 55,0 | 69,8 | 40,2 |
V.
, , :
, ;
|
|
, ;
, (. . 5.6) .
, , . , (. . 5.6), 1997 , . , , .
( ), " ". " " (Q TREND) " " (Q1 TREND Q3 TREND). " " (var) MS Excel . 5.7.
5.7
" " (var) MS Excel
A | B | C | D | E | F | G | H | |
Q | Q TREND | F1 | Q1 TREND | F3 | Q3 TREND | var | ||
.97 | 46,3 | 48,9 | 43,7 | =((ABS(C2-E2)+ABS(C2-G2))/2)/C2 |
. 5.8 " " :
var =((ABS(QTREND - Q1TREND)+ABS(QTREND - Q3TREND))/2)/QTREND.
. 5.8. , " ": 6% 1997 27% 1997 .
5.8
Q TREND | F1 | Q1 TREND | F3 | Q3 TREND | var | |
.97 | 46,3 | 48,9 | 43,7 | 6% | ||
.98 | 44,9 | 47,7 | 42,1 | 6% | ||
.98 | 45,2 | 47,7 | 42,7 | 6% | ||
.98 | 69,8 | 40,2 | 27% |
" " ( ) . , 1997 :
Q= QTREND* var=46,3*0.94=43.5
.
" " . 5.9, : " " .
5.9
" "
0,46 | CORR F1 | 0,06 | CORR F2 | 0,46 | CORR F3 | ||||
Q | Q TREND | F1 | Q1 TREND | F2 | Q2 TREND | F3 | Q3 TREND | var | |
.97 | |||||||||
.97 | |||||||||
.97 | |||||||||
.97 | |||||||||
.97 | |||||||||
.97 | |||||||||
.97 | |||||||||
.97 | |||||||||
.97 | |||||||||
.97 | 46,3 | 48,9 | 43,7 | 6% | |||||
.98 | 44,9 | 47,7 | 42,1 | 6% | |||||
.98 | 45,2 | 47,7 | 42,2 | 6% | |||||
.98 | 69,8 | 40,2 | 27% |
|
|
1. .. / . .., .: , 1995.
2. Boyd, Harper W. (jr.), Westfall, Ralph. Marketing research: Text and cases. -3rd ed. -Homewood; Georgetown: Irwin, 1972. -XV, 813p.
3. Burke R. Virtual Shopping: Breakihrough in Marketing Research= //Harvard Business Review. -1996. -N2. -P. 120-131.
4. Coffre, Philippe Action et Gestion Commerciales: La nouvelle vente/En collaboration avec Michel Coffre. -[S. l. ]: Nathan, [1982]. -223p. - (Connaitre et Pratiquer la Gestion). -. ., . . -.: Methodes classiques et modernes de vente; Animation des ventes et motivations des vendeurs; Controle des ventes; Direction des ventes et marketing. -ISBN 2-09-192102-5.
5. Current Controversies in Marketing Research/Ed. by Leo Bogart. -Chicago: Markham, [1969]. -VII, 164 p.: ill., tab. - (Markham Ser. in Marketing).
6. Framework for the Combination of Forecasts. Benito E. Flores and Edna M. White, Journal of the Academy of Marketing Science, 16 (Fall 1988), pp. 95-103.
7. Green, Paul E. . Research for Marketing Decisions/Green, Paul E., Tull, Donald S., Albaum, Gerald. -Fifth Edition. -Englewood Cliffs: Prentice-Hall International, [1988]. -784p.: il. -. . . -ISBN 0-13-774217-7.
8. Joseph B. Kruskal, "Analisys of Factorial Experiments by Estimating Monotone Transformations of the Data", Journal of royal Statistical Society, Series B, March 1965.
9. Carroll Mohn & Thomas H. Land A Guide to Quality Marketing Research Proposals and Reports, Business 39, 1989.
10. .. . -: - , 1986.
11. . . : : . . -: - , 1992. -40.
12. . ., . . / . . . . -.: , 1991. -29.
13. . ., . . : . . -: - , 1996. -93
14. ., . // . -1996. -N3. -. 40-50.
15. ., . // . 1996. -N5. -. 42-50.
16. . // . -1996. -N6. -. 82-93.
17. . // . -1995. -N3. -. 31-42.
18. . // . -1996. -N2. -. 104-117.
19. . . - // . -1996. -N1. -. 51-53.
20. . . . -.: ,1994. -255.
21. . . , // .-1997. -N7. -. 47-50.
22. . // . -1997. -N1. -. 35-38.
23. . . . 2. .: , 1978.
24. . . // . -1993. -N1. -. 119-128.
25. .. / - -.: , 1974.
26. . . -: "" // . -1996. -N2. -. 18-20.
27. . // . 1996. -N5. -. 112-115.
28. : : . Kinnear, Thomas C., Taylor, James Ronald. Marketing research: An applied approach. -New York etc.: McGraw-Hill, [1979]. -656p.: tabl., diagr. - (McGrowHill ser. in marketing).
|
|
29. . . : . . -: - , 1996. -109.
30. . // . -1995. -N8 (). -. 18.
31. Tull, Donald S., Hawkins, Del I. Marketing research: Measurement and method: A text with cases. -2nd ed. -New York; London: Macmillan, [1980]. -XII, 796p.
32. . ? // . -1994. -N5. -. 119-135.