Analysing Data.

Analysing Data
Table of Contents

INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
An Overview of wholesale stationery Market in Germany........................................................1
TASK 2............................................................................................................................................2
Analysing annual per capital spending on the writing and drawing material:............................2
TASK 3............................................................................................................................................3
a). Assessment of total sales:......................................................................................................3
b). Mixed pie chart:.....................................................................................................................4
C). Correlation co-efficient via scatter plot:...............................................................................4
d). Estimating sales trend for the period of 2018 and 2019:.......................................................5
TASK 4............................................................................................................................................5
a). Pros and Cons assessment:.....................................................................................................5
b). Defining international standards with which Donald Duque needs to comply:....................6
TASK 5............................................................................................................................................7
a). Computing a monthly cost of 30-year repayment mortgage..................................................7
b). Re-calculating monthly cost assuming that the interest is applied to the loan every month. 7
TASK 6............................................................................................................................................8
TASK 7............................................................................................................................................8
a). Stating ways that can be used for enhancing customer responsive rate:................................8
b). Evaluating data set collected from a survey..........................................................................9
TASK 8..........................................................................................................................................10
Recommendation.......................................................................................................................10
CONCLUSION..............................................................................................................................10
REFERENCES..............................................................................................................................11
APPENDIX....................................................................................................................................12

INTRODUCTION
Donald Duque is a small sized family stationery business company which have their
business Germany is the development country which have strong economy situated in Northern
France. Although, he does not require to assess the significance and practical criticality of the
organisation data analysis in order to form a most effective decision (Stewart, 2016). This is
rightly said that Donald Duque is engaged in wholesale trading and form a strong customer base
in the past fifty years. Companies have diverse products which have cartridges of printers, office
furniture’s, low price printers, shredders, diverse kind of furniture, low price, paper based
suppliers and drawing related material. The current research which totally focus at assessing its
sales for last 3 year years to form strong decisions. In addition to this, future business about its
expansion would be assessed which would be assessed via “pros and cons” tools and survey
emerged that which be assessed via basic statistical methods for purpose in an efficient decision.
TASK 1
An Overview of wholesale stationery Market in Germany
Stationery market in Germany is at the peak from various centuries and various things are
really operated in an effective manner (Uemura, O. and et.al., 2016). It is highly as of new items
emerged to customised customer habits, desires and choices along with emerged vitality and
superior issues which has elevated in this industry. Association for Office Supply &Writing
Material stated that industry had exceeded its annual revenue over 14.8 Billion by enhancing
individual spending above €182 per year. Out of these, €35.2 expenses on writing & drawing
material, as an outcome, various European market achieved on 2nd position after the Switzerland.
Germany Stationery Brands Association reported that emergence domestic demand by the
residents and demand from abroad during the growth rate at 2.5% and 5% demonstrating sound
growth of 3.5% during 2014-2015 (MGCC Perspective - German Chamber of Commerce and
Industry, 2016). 2200 wholesale organisations are existing working in the German Stationery
market which offers office supplies, paper, writing tools, with high of them which have a net
income below €500,000. B2B intermediaries which serves commercial consumers directly.
M&A strategies of the organisation is the perfect tool which can be used by the specialist
retailers who offer labelled and standardized quality products. Immense growth which formed a
strong brand image with have crucial market share. Although, during the same time, this is
1

struggling along with diverse challenges such like paper & its regards to product sales which is
forecasted to regular its existing path of lowering sales revenue. This is occurred due to the
digitalization of work, due to which, office supplies and writing instrument experienced at a
growth rate @ 5% per annum. HBS forecasted the trend to be constantly in future.
TASK 2
Analysing annual per capital spending on the writing and drawing material:
Country
Per capita
(€)
Switzerland 35.5
Germany 35.2
Austria 35
France 28.3
Italy 18.6
Spain 8.9
Poland 8.5
By assessing the graph, it is visualizing that Germany have the second largest market fr
the stationery after Switzerland with per capita spending of €35.2 on writing and drawing
material. In addition to this, various supermarkets which are located throughout the Europe have
a diverse stationery items (Shevlyakov and Smirnov, 2016). They are required to target highly
2