Data Analysis Assignment - (Solution)

13 Pages2623 Words402 Views

Added on 2020-10-05

Data Analysis Assignment - (Solution)

Added on 2020-10-05

BookmarkRelated Documents

Analysing data on a given business

TABLE OF CONTENTSINTRODUCTION...........................................................................................................................12.1 Overview of the wholesale stationers market in Germany....................................................12.2 Stating annual spending on writing and drawing materials per capita..................................22.3 Reflecting last three years sales of year 2015 to 2017...........................................................3Framing mixed pie chart..............................................................................................................4Extracting Correlation coefficient of total sales and year...........................................................4Extracting sales of 2018 and 2019...............................................................................................5a. Sales when x is 4 (2018)..........................................................................................................5b. Sales when x is 5 (2019)..........................................................................................................52.4 International standard to apply in Durque activities..............................................................5Scoring or pros and cons of business expansion in Germany and Belgium................................62.5 Calculating cost of new building...........................................................................................7Monthly cost with application of interest loan at each month.....................................................82.6 Finding mean value of order..................................................................................................82.7 Presenting consumer satisfaction with descriptive statistics and ways for improvingconsumer survey rate...................................................................................................................9CONCLUSION................................................................................................................................9REFERENCES..............................................................................................................................10APPENDIX....................................................................................................................................11

INTRODUCTIONWithin this particular discussion of report there will include small family stationerywhich is operating within the Northern France for last 15 years while the owner is not havingknowledge about data analysis and how it affects the business. So the report will includeoverview of whole stationer market of Germany with the trends in that area. The annual spendingon writing or drawing material per capital in 2015 EU countries will be calculated. With this alltype of international standards that is applied on activity of business will be carried out.2.1 Overview of the wholesale stationers market in GermanyThe wholesale market of stationers within Germany is very well positioned andestablished with having more than €14.8 billion turnover each year. as per the clear data of TradeAssociation for Office Supply and Writing Materials (HBS) it could include that based onindividual data about 182 is been spent by one person each year and into this €35.2 is that ofdrawing and writing materials only (Germany – A Potential Stationery Market, 2016). There isalways seem to be very positive attitude of companies who are supplying stationery material asthere was sale hike in year 2015 by 70%. Thus this comprise of 3.5% of increase of stationeryindustry in Germany within the period of 2014-2015, that of 2.5% is that of domestic sales and5% increase in international market. Figure 1: Annual spending for writing and drawing materials per capita[Source: Germany – A Potential Stationery Market, 2016]1

There are certain possible trends and potential within the stationery market of Germanyas it is very good reputation in around the world. With this good reputation the Germanstationery brand they are having significant market share as compared to other private brands.There are many types of products and its associated challenges which are linked to it like that ofpaper and its related products. These will include like that of document folder whose demand isdecreasing as it will be expecting to have product category. As there is increase in digitalisationwhich is taking place of paper and document folder in office and personal work as well. Otherthan the paper and its related document there are positive increase in growth of office suppliersand writing instruments for growth till 5% 2015.While in the related development it is also included that people are showing up theircreativity which is the main reason behind increase in demand for these kinds of products likedrawing and painting materials. All the sale of these type of product are having average rate ofsale with the increasing use of digital products by customers all around the world.2.2 Stating annual spending on writing and drawing materials per capitaEuropean CountriesYearly spendingSwitzerland35.5Italy18.6Germany35.2Slovenia20.4France28.3Austria35Hungary9.62

End of preview

Want to access all the pages? Upload your documents or become a member.

Analysing Information and Data for Problem Solving

|14

|2704

|398

Duque PEPETIER Case Study TABLE OF CONTENTS INTRODUCTION

|14

|2835

|454

(solved) Analysing Information and Data for Problem Solving

|15

|2358

|318

Report for Duque Papetiers Gros 2017

|16

|2382

|45

Wholesale Stationery Market in Germany

|13

|2656

|242

Analysis : Duque consecutive sales data

|15

|2641

|97

Data Analysis Assignment - (Solution)