Statistical Tools Report - Morrison
24 Pages4790 Words51 Views
Added on 2020-01-21
Statistical Tools Report - Morrison
Added on 2020-01-21
ShareRelated Documents
BUSINESS DECISION MAKING
TABLE OF CONTENTSINTRODUCTION...........................................................................................................................41.1 Collection of primary and secondary data........................................................................41.2 Survey methodology and sampling frame for the research .............................................41.3 Designing questionnaire for survey .................................................................................5TASK 2............................................................................................................................................72.1 Statistical tools for the decision making...........................................................................72.2 Analysis of results............................................................................................................82.3 Analysis of data using measure of dispersion..................................................................92.4 Quartile, percentile and correlation coefficient uses in data analysis...........................10TASK 3..........................................................................................................................................113.1 Graphs on information derived from business scenario ................................................113.2 Trend lines......................................................................................................................153.3 Covered in PPT...............................................................................................................183.4 Formal business report...................................................................................................18TASK 4..........................................................................................................................................184.1 Information processing tools..........................................................................................184.2 Network diagram............................................................................................................194.3 Project evaluation techniques.........................................................................................20CONCLUSION ............................................................................................................................22REFERENCES..............................................................................................................................24INDEX OF TABLESTable 1: Calculation of mean, median and mode for Morrison and its competitors.......................8Table 2: Percentage change in sales.................................................................................................9Table 3: Calculation of standard deviation......................................................................................9Table 4: Calculation of quartile and percentile..............................................................................10Table 5: Calculation of correlation................................................................................................10Table 6: Percentage change in JS Sainsbury's sales revenue for FY 2009-13...............................13Table 7: Percentage change in Lidl sales revenue.........................................................................14Table 8: Sales revenue of Aldi.......................................................................................................15Table 9: ARR of projects...............................................................................................................22
Table 10: NPV of Project A&B.....................................................................................................23Table 11: IRR of projects...............................................................................................................24ILLUSTRATION INDEXIllustration 1: Wm Morrison's sales revenue.................................................................................11Illustration 2: Sales revenue of JS Sainsbury's..............................................................................13Illustration 3: Sales revenue of Lidl from FY 2009- 2013.............................................................14Illustration 4: Sales revenue of Aldi..............................................................................................15Illustration 5: Trend line on Wm Morrison....................................................................................16Illustration 6: Trend line of JS Sainsbury's....................................................................................18Illustration 7: Lidl trend line..........................................................................................................19Illustration 8: Trend line of Aldi....................................................................................................19Illustration 9: Gantt chart...............................................................................................................21Illustration 10: Network diagram...................................................................................................22
INTRODUCTIONMorrison is one of the largest supermarket chains in the UK. This report is prepared onthe statistical tools. In today era, all decisions are taken on the basis of collected data. Due to thisreason it is necessary to have deep knowledge of the collected data. In this regard, in the report,statistical tools like mean, median and mode etc are applied on the company data. Apart fromthis trend analysis is also done and charts are interpreted in the report. Along with this, in thereport, network diagram is prepared and its results are interpreted in proper manner. At the endof the report, project evaluation techniques are also applied on the given cash flows and bestproject is selected for the firm.1.1 Collection of primary and secondary dataPrimary data refers to the data that is collected for the first time by the researcher.Primary data can be collected by distributing questionnaire, schedules etc. Apart from this, datacan also be collected through telephone calls if respondent are rich people and it is not possibleto approach them. On other hand, secondary data refers to the data that is already collected bysomeone. Secondary data can be collected from the books, journals and magazines etc.Collection of both data is necessary for the research (Krikidis, Devroye and Thompson, 2010).This is because by conducting secondary research a researcher comes to know about the pastscenario. On the basis of knowledge of past scenario and current business conditions researcheris in position to draft questionnaire in proper manner. Hence, here secondary research helpresearcher in conducting a research (Edge and Compton, 2010). In order to conduct a researchsample of 50 people is taken that resides in to different borough of London. These people belongto different income level and their social status is also different. Hence, good quality of data willbe collected from the respondents.1.2 Survey methodology and sampling frame for the researchThere are many sampling techniques and some of them are as follows. Simple random sampling- It is a sampling technique in which all sample units are takenrandomly from the population. Means that on the basis of specific criteria sampling unitsare not taken for the research (Piwowarski, Krajewski and Lelito, 2010). This samplingtechnique is used in the research when specific category of respondents is not required forresearch.
Stratified random sampling- This is different type of sampling and under this entirepopulation is divided in to several parts and from these parts sample units are taken forthe research. The main benefit of this sampling technique is that in this method data fromspecific type of people can be taken by the researcher. Due to this specific feature thissampling frame is very popular among the researchers.Cluster sampling- In this sampling technique population of the geographic area isdivided in to several parts and from same sampling units is taken by the researcher(Basak, 2012). Data from specific type of people can be collected in the specificgeographic area by making use of this sampling method. Hence, it is third samplingtechnique that is famous among the researchers. 1.3 Designing questionnaire for survey Demographic Details Name: Age: Gender: Occupation: Marital status Do you frequently make purchase of food products from WM Morrison?Yes( )No( )What are the factors to which you give priority before making purchase from Morrison? Attractive discounts( )Better quality ( )Near to your place( )Value for money( )How frequent you visit the retail store of Morrison for the purchase?Daily( )Weekly( )Monthly( )According to requirements( )
At the time of offers( )From the below given options, in which category services at WM Morrison fall?Poor ( )Bad ( )Average ( )Good ( )Excellent ( )Are you satisfied with the goods and services of the company?Strongly satisfiedSatisfiedNeutralDissatisfiedStrongly dissatisfiedHow much money you spend at WM Morrison in a single purchase?<£200£200-400£400-600> £600In terms of service, which retail supermarket you mostly prefer?WM Morrison ( )JS Sainsbury's( )LIDL Ltd( )ALDI ( )Do you wish to give any suggestion for the improvements in the products and services of WMMorrison?TASK 22.1 Statistical tools for the decision makingStatistical tools that are used for decision making are as follows:
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Business Decision Making - Sample Assignmentlg...
|45
|8376
|161
Analysis of Sales Revenue and Trend Lines of Wm Morrison, JS Sainsbury, Lidl and Aldilg...
|22
|1086
|84
Business Decision Making in Kfc Assignmentlg...
|20
|4807
|2939
Business Decision Making - Tescolg...
|28
|5940
|232
BUSINESS DECISION MAKING TABLE OF CONTENTS INTROUCTION 3 TASK 13lg...
|21
|4914
|433
Business Decision Making Assignment - Restaurant Chainlg...
|23
|4751
|147