Report on Statistics and Probability
13 Pages2477 Words108 Views
Added on 2020-06-04
Report on Statistics and Probability
Added on 2020-06-04
ShareRelated Documents
STATISTICS AND PROBABILITY
TABLE OF CONTENTSINTRODUCTION...........................................................................................................................1Background and context..................................................................................................................1Methodology....................................................................................................................................1TASK 1............................................................................................................................................2Sales and profit of data analysis of external customers...............................................................2.........................................................................................................................................................4TASK 2............................................................................................................................................5TASK 3............................................................................................................................................7(a)Proportion of products in January month and comparison to prediciton................................7(b)Proportion of products in December month and comparison to prediciton............................7© Change in mix overall between January and December..........................................................8(d) New market mix based on December data.............................................................................8CONCLUSION AND REOCMENDATION..................................................................................9Table 1Sales and profit of data of external customers.....................................................................2Table 21Sales and profit of data of internal customers...................................................................3Table 3Sales and profit of data for mobile......................................................................................3Table 4Average percentage portion of Espesso, Mocha and Sublime in sales value for Januarymonth...............................................................................................................................................7Table 5Average percentage portion of Espesso, Mocha and Sublime in sales value for Decembermonth...............................................................................................................................................7Table 6Prediction by using moving average...................................................................................8YFigure 2Profit figure........................................................................................................................4Figure 3Sales distribution of mobile, internal carts external customers..........................................4
INTRODUCTION Data analysis is the one of the important approach that helps firm in making businessdecisions. In data analysis there are number of tools and techniques that are used by the firms tomake business decisions. Coffee business is one of the common activity in most of Europeannations as most of people like to take coffee. In the current report detail analysis of coffee relateddata is done. In this regard, some of the statistical tools are applied on relevant facts and answersof questions are identified and report on same is prepared. In this way entire research work iscarried out.Background and contextCurrent data analysis is carried out on Sublime delight which is rapidly growing firm andknown for coffee rosting tasks. It is also coffee supplier and operating chain of outlets in itsbusiness (Galarraga and Markandya, 2011). Entreprenuer is importing coffee bins and kept themin different temperatures which make its business innovative in nature. Some of data wasgathered by its General manager in respect to the business and same is analyzed in current reportso that lots of hidden facts can be identified in respect to business. In this regard some ofimportant tests and other statistical approaches wll be used in research study.MethodologyGathered data is primary in nature which is collected from in house company records.Data is properly arranged so as to ensure better analysis of facts and development of insightsabout business. In this reagard some charting like histogram will be prepared and same will beused to analyze data (Alvesson and Sköldberg, 2017). Apart from this, as per requirementregresssion analysis or T test or any other alternative technique will be used in research study.Along with this, in respect to mix proportion also relevant technique will be used. Thus, it can besaid that according to requirement relevant tools and methods will be used for data analysis.BADIR methodology is given below.Buisness question: Business question are related to identifying sales distribution acrossoutlets and profit distribution across different chanels. Apart from this busienss questionis also related to identifying growth areas in business. Along with this, answer of questionwhether there is significent difference between outlets in respect to service quality andcoffee quality. | P a g e
Analysis plan: In order to answer these questions analysis plan is prepared and under thisdata will be processed and by doing so profit value will be computed for all channels ofdistribution. In this way, entire analysis will be done. Apart from this, T test will beapplied and significent difference will be identified in respect to multiple variables inrelevance to both outlets. In third section in order to do analysis simply percentage thatEspresso, Mocha and Sublime cover in entire sales will be determined. On this basis itwill be identified whether prediction actually happened some deviaton comes in results.Data collection: Data is gathered from company records which were earlier recorded bycompany general manager (BADIR framework get from data to decisions, 2017).Relevant data is taken in to consideration for analysis purpose.Derive insights: In this section obtained results will be interpreted and on that basisconclusion will be formed in the report.Recommendations: On basis of conclusion formed recommendation will be made inresearch report. TASK 1Sales and profit of data analysis of external customersTable Sales and profit of data of external customersExternal CustomersSalesunitsCost SalesProfit14701033020726.81039724991097520762.51978835461064322429.781178747571286429457.06165935425934118662.35932165291031822067.091174979481469735758.08210618454998619931.9946 | P a g e
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
N1504 – Research Enquiry for Managers, Case Studylg...
|9
|2474
|232
Research Enquiry for Managerslg...
|10
|2501
|265
Eclipse Vans Business Analysis Report 2017 and 2018lg...
|9
|1070
|477
Manage Knowledge and Information PDFlg...
|9
|1989
|156
Sublime Delight Company Case Analysislg...
|12
|2671
|36
Marketing Strategies of Costa Coffeelg...
|16
|3873
|409