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. On analysis of both coorelation and trend analysis
chart it is predicted that in upcoming years sales value will increase at rapid rate. Sales in second
charting reflecting total amount of sales for different years for varied nations in dollar amount.
Sales data is related to revenue that is generated betweeen 2012 to 2017. 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. Hence, if further this trend
1 | P a g e

remain continue in the market then number of competitors of the firm will reduced. This thing
will prove beneficial for the Donald to great extent. 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 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
Sales value of five years for Europe an countries
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. Here, series 1 to series 6 reflect time period
that is between 2012 to 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.
2 | P a g e