Analysing Information and Data for Problem Solving

ANALYSING INFORMATION AND DATA
FOR PROBLEM SOLVING

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
Trends in Germany stationary market.........................................................................................1
TASK 2............................................................................................................................................2
TASK 3............................................................................................................................................3
(a)Total sales value of products from 2015 to 2017....................................................................3
(b) Pie chart for sales amid of 2016 and 2017 productwise.......................................................4
© Coorelation cofficient..............................................................................................................5
(d) Prediction on sales trend........................................................................................................5
TASK 4............................................................................................................................................6
(a)Completion of table.................................................................................................................6
(b)International standard applied to the firm business................................................................6
TASK 5............................................................................................................................................7
(a)Monthly cost by considering year...........................................................................................7
(b)Monthly cost by considering month........................................................................................7
TASK 6............................................................................................................................................7
Confidence interval......................................................................................................................7
TASK 7............................................................................................................................................8
(a)Advise in respect to improving situation.................................................................................8
(b) Descriptive statistics..............................................................................................................8
TASK 8 CONCLUSION.................................................................................................................8
APPENDIX....................................................................................................................................11

INTRODUCTION
Data analysis is the one of the important approach that is used to make decisions. In the
current report varied facts are analyzed in proper manner. On basis of analysis of facts it is
identified whether firm must open its business in Germany. Scatter diagram is prepared and by
using same coorelation cofficient is identified. At end of the report, dscriptive statisics is applied
on dataset. In this way, entire research work is carried out.
TASK 1
Trends in Germany stationary market
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
0
1000
2000
3000
4000
5000
6000
7000
8000
9000 7973 7791 7736 7620 7429 7242 6965 6941 6632 6335 6047 5710 5440 5200 5300
Sale
Sale
Figure 1Wholesale stationary business in Germany
On basis of chart given above it can be observed that number of observations in terms of number
of business firms in wholesale stationary business get declined in past couple of years. However,
still there are large number of companies in the Germany that are operating a wholsesale
stationary business. It can be observed that number of business firms in stationary were 7973 in
year 2002 which declined to 6965 in year 2008 (International suppliers, 2017). Further, decline
comes in the sales value to 5300. It can be said that consistently decline coems in the number of
firms that are operating in the stationary business in the Germany. There is need to take steps to
improve numbers in the wholesale statioanry business in Germany. However, still number of
firms operating in this segment is high which reflect there there is great demand of stationary
items in Germany and exports are also high in other European countries. Thus, it can be said that
1 | P a g e

still stationary business is operating at wide level in the Germany and it is possible that in
upcoming time period it grow at rapid pace.
TASK 2
France
Germany
Italy
Romania
UK
Poland
Switzerland
0 5000 10000 15000 20000 25000 30000
15475
24984
16000
17000
14000
19000
20500
14887
24559
14000
17600
16900
19900
21000
14746
24900
14500
18300
17300
20000
21500
14697
25483
15000
18000
17900
23000
22500
15432
26757
15750
18900
18795
24150
23625
Chart Title
Series6 Series5 Series4 Series3 Series2 Series1
On basis of fact it can be observed that sales value in case of France was 15475 in year 2012 and
it increased to 15432 in year 2017. Thus, it can be said that increase is observed in sales value in
respect to France. In case of Germany sales value was 24984 and it increased to 26757 which
reflect that moderate plunge comes in sales value in Germany. It can also be observed that sales
is increasing at higher rate in case of Germany then France. Apart from this, in case of Italy sales
value was 16000 which declined to 15750 which reflect that in mentioned nation decline comes
in sales value. On other hand, in case of Romania it can be observed that 17000 was sales value
in year 2012 which increased to 18900 in year 2017 which reflect that mentioned nation also
sales value get increased. In case of UK also sales increased but at high growth rate as its value
was 14000 in year 2012 and increased to 18795. Similalry, in case of Poland sales value was
2 | P a g e