Задание для самостоятельной работы
Требуется: построить три диаграммы продаж, расположив их на отдельных листах. Самостоятельно придумать название фирмы и трех филиалов. Исходные данные за год, в соответствии со своим вариантом, берутся из табл. 2.
Таблица 2 Исходные данные
№ |
Объем продаж фирмы по трем филиалам, тыс. $ |
|||||||||||
1 |
2 |
|||||||||||
1 |
45.12 |
23.23 |
56.25 |
78.24 |
12.50 |
78.12 |
52.26 |
45.40 |
75.41 |
85.45 |
12.56 |
56.12 |
32.12 |
62.54 |
53.22 |
43.25 |
51.23 |
45.63 |
45.23 |
65.25 |
45.12 |
39.12 |
54.89 |
44.37 |
|
23.12 |
26.35 |
35.89 |
34.52 |
23.33 |
56.69 |
54.35 |
56.88 |
54.12 |
30.22 |
23.56 |
56.36 |
|
2 |
12.36 |
25.70 |
35.84 |
52.47 |
12.36 |
78.94 |
15.52 |
36.92 |
25.80 |
75.69 |
85.42 |
63.55 |
22.63 |
53.78 |
53.88 |
23.78 |
25.63 |
87.45 |
52.26 |
63.26 |
58.87 |
56.98 |
53.37 |
39.56 |
|
63.21 |
70.59 |
48.59 |
29.74 |
63.28 |
46.89 |
27.53 |
22.66 |
59.23 |
98.56 |
28.59 |
58.63 |
|
3 |
65.98 |
63.20 |
20.30 |
80.55 |
97.54 |
65.47 |
85.20 |
65.80 |
74.10 |
85.20 |
96.30 |
98.74 |
89.55 |
21.36 |
30.28 |
57.82 |
55.83 |
41.77 |
76.58 |
21.82 |
89.66 |
19.42 |
28.53 |
39.62 |
|
33.53 |
64.50 |
38.62 |
41.28 |
99.89 |
24.87 |
71.81 |
42.53 |
61.59 |
68.82 |
83.57 |
53.29 |
|
4 |
75.35 |
15.96 |
46.30 |
24.40 |
85.89 |
88.52 |
98.70 |
65.40 |
45.60 |
59.00 |
65.80 |
74.20 |
32.12 |
62.54 |
53.22 |
43.25 |
51.23 |
45.63 |
45.23 |
65.25 |
45.12 |
39.12 |
54.89 |
44.37 |
|
33.53 |
64.50 |
38.62 |
41.28 |
99.89 |
24.87 |
71.81 |
42.53 |
61.59 |
68.82 |
83.57 |
53.29 |
|
5 |
35.50 |
69.51 |
30.64 |
40.20 |
98.85 |
25.88 |
70.89 |
40.56 |
60.54 |
60.50 |
80.56 |
50.24 |
78.33 |
18.98 |
41.35 |
22.45 |
86.84 |
83.51 |
93.75 |
62.48 |
42.61 |
53.15 |
64.87 |
76.23 |
|
32.12 |
62.54 |
53.22 |
43.25 |
51.23 |
45.63 |
45.23 |
65.25 |
45.12 |
39.12 |
54.89 |
44.37 |
|
6 |
86.56 |
20.36 |
30.20 |
55.80 |
54.80 |
45.79 |
74.56 |
25.80 |
82.60 |
10.47 |
20.58 |
30.69 |
78.33 |
18.98 |
41.35 |
22.45 |
86.84 |
83.51 |
93.75 |
62.48 |
42.61 |
53.15 |
64.87 |
76.23 |
|
21.00 |
52.85 |
54.95 |
60.50 |
20.40 |
80.21 |
30.60 |
40.56 |
35.89 |
65.79 |
95.52 |
73.66 |
|
7 |
60.32 |
70.52 |
40.85 |
74.25 |
56.32 |
46.87 |
49.87 |
25.51 |
29.63 |
50.82 |
96.57 |
55.36 |
89.55 |
21.36 |
30.28 |
57.82 |
55.83 |
41.77 |
76.58 |
21.82 |
89.66 |
19.42 |
28.53 |
39.62 |
|
32.12 |
62.54 |
53.22 |
43.25 |
51.23 |
45.63 |
45.23 |
65.25 |
45.12 |
39.12 |
54.89 |
44.37 |
|
8 |
21.54 |
32.32 |
52.65 |
42.87 |
50.21 |
21.87 |
62.25 |
40.54 |
41.57 |
54.58 |
65.21 |
21.65 |
55.10 |
53.36 |
25.30 |
95.45 |
87.45 |
70.50 |
84.30 |
56.23 |
84.10 |
80.26 |
69.85 |
80.70 |
|
86.56 |
20.36 |
30.20 |
55.80 |
54.80 |
45.79 |
74.56 |
25.80 |
82.60 |
10.47 |
20.58 |
30.69 |
|
9 |
21.23 |
54.26 |
22.35 |
25.34 |
32.50 |
36.40 |
32.54 |
52.56 |
21.54 |
21.93 |
85.49 |
37.44 |
55.10 |
53.36 |
25.30 |
95.45 |
87.45 |
70.50 |
84.30 |
56.23 |
84.10 |
80.26 |
69.85 |
80.70 |
|
78.33 |
18.98 |
41.35 |
22.45 |
86.84 |
83.51 |
93.75 |
62.48 |
42.61 |
53.15 |
64.87 |
76.23 |
|
10 |
21.00 |
52.85 |
54.95 |
60.50 |
20.40 |
80.21 |
30.60 |
40.56 |
35.89 |
65.79 |
95.52 |
73.66 |
89.55 |
21.36 |
30.28 |
57.82 |
55.83 |
41.77 |
76.58 |
21.82 |
89.66 |
19.42 |
28.53 |
39.62 |
|
35.50 |
69.51 |
30.64 |
40.20 |
98.85 |
25.88 |
70.89 |
40.56 |
60.54 |
60.50 |
80.56 |
50.24 |
|
11 |
55.10 |
53.36 |
25.30 |
95.45 |
87.45 |
70.50 |
84.30 |
56.23 |
84.10 |
80.26 |
69.85 |
80.70 |
23.12 |
26.35 |
35.89 |
34.52 |
23.33 |
56.69 |
54.35 |
56.88 |
54.12 |
30.22 |
23.56 |
56.36 |
|
12.36 |
25.70 |
35.84 |
52.47 |
12.36 |
78.94 |
15.52 |
36.92 |
25.80 |
75.69 |
85.42 |
63.55 |
|
12 |
55.10 |
53.36 |
25.30 |
95.45 |
87.45 |
70.50 |
84.30 |
56.23 |
84.10 |
80.26 |
69.85 |
80.70 |
65.98 |
63.20 |
20.30 |
80.55 |
97.54 |
65.47 |
85.20 |
65.80 |
74.10 |
85.20 |
96.30 |
98.74 |
|
89.55 |
21.36 |
30.28 |
57.82 |
55.83 |
41.77 |
76.58 |
21.82 |
89.66 |
19.42 |
28.53 |
39.62 |
|
13 |
78.33 |
18.98 |
41.35 |
22.45 |
86.84 |
83.51 |
93.75 |
62.48 |
42.61 |
53.15 |
64.87 |
76.23 |
75.35 |
15.96 |
46.30 |
24.40 |
85.89 |
88.52 |
98.70 |
65.40 |
45.60 |
59.00 |
65.80 |
74.20 |
|
32.12 |
62.54 |
53.22 |
43.25 |
51.23 |
45.63 |
45.23 |
65.25 |
45.12 |
39.12 |
54.89 |
44.37 |
|
14 |
33.53 |
64.50 |
38.62 |
41.28 |
99.89 |
24.87 |
71.81 |
42.53 |
61.59 |
68.82 |
83.57 |
53.29 |
78.33 |
18.98 |
41.35 |
22.45 |
86.84 |
83.51 |
93.75 |
62.48 |
42.61 |
53.15 |
64.87 |
76.23 |
|
32.12 |
62.54 |
53.22 |
43.25 |
51.23 |
45.63 |
45.23 |
65.25 |
45.12 |
39.12 |
54.89 |
44.37 |
|
15 |
89.55 |
21.36 |
30.28 |
57.82 |
55.83 |
41.77 |
76.58 |
21.82 |
89.66 |
19.42 |
28.53 |
39.62 |
45.12 |
23.23 |
56.25 |
78.24 |
12.50 |
78.12 |
52.26 |
45.40 |
75.41 |
85.45 |
12.56 |
56.12 |
|
21.00 |
52.85 |
54.95 |
60.50 |
20.40 |
80.21 |
30.60 |
40.56 |
35.89 |
65.79 |
95.52 |
73.66 |