Analyzing Information & Data for Problem Solving

ANALYSING INFORMATION & 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.......................................................3
(c) Coorelation cofficient.............................................................................................................4
(d) Making prediction on basis of trend line...............................................................................4
TASK 4............................................................................................................................................5
(a)Completion of table.................................................................................................................5
(b)International standard applied to the firm business................................................................6
TASK 5............................................................................................................................................6
(a)Monthly cost by considering year...........................................................................................6
(b)Monthly cost by considering month........................................................................................7
TASK 6............................................................................................................................................7
Confidence interval......................................................................................................................7
TASK 7............................................................................................................................................8
(a)Recommendation to improve situation...................................................................................8
(b)Descriptive statistics...............................................................................................................8
CONCLUSION................................................................................................................................8
REFERENCE..................................................................................................................................9

Figure 1Wholesale stationary business in Germany........................................................................1
Figure 2Product wise sales value.....................................................................................................3
Figure 3Scatter diagram and coorelation cofficient.........................................................................4
Figure 4Calculation of monthly cost...............................................................................................6
Figure 5Calculation of monthly cost by using 12 months time period............................................7
Figure 6Calculation of confidence interval.....................................................................................7

INTRODUCTION
Stationary business is the one of the growing business in Germany. Number of business
firms in stationary busines are growing at rapid rate which are producing scales, pencil,
sharpners and many other stationary items. In the current report stationary business is analyzed
across varied EU nations. Coorelation and trend line like techniques are applied on dataset and
meaningful interpretations are made. Correlation results reflect that with increase in year in
positive manner sales value of stationary also increase at rapid rate. Trend analysis results reflect
that in upcoming time period sales value will increase at rapid pace Means that in futuren time
period sales of stationary products will increase at rapid pace as same thing is reflected by both
coorelation and trend analysis. At end of the report, descriptive statistics are applied and
comparison between variables are made. By forming conclusion research work is completed in
the report.
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
Number of firms
Figure 1Wholesale stationary business in Germany
Interpretation
The above chart is demonstrating that there were large number of firms that were
operating in the stationary business in Germany. 1,2, 3 are reflecting years in the above given
chart. Earlier this number was 7973 which comes down to 5300 and on this basis it can be
deduced that now less number of firms are operating in stationary business (International
1 | P a g e