Reference no: EM13942074

Task 1:

Report on Data Collection and Analysis, In this report;

- Create a plan for primary and secondary data collection with presenting the survey methodology & sampling frame used
- Design a questionnaire to collect data and provide a justification for its design
- Collect data and summarise the collected data using representative values
- Analyse the collected data using measures of dispersion. You must be able to use the analysis to inform and support decision making.
- Carry out suitable calculations to draw useful and realistic conclusions and provide valid recommendations your calculations must include quartile, percentiles and the correlation coefficient. Explain how these calculations helped you to draw useful conclusions.

To achieve M1, have effective judgements and approach in using variety of sources for the collection of data and range of techniques to analyse data effectively

To achieve D1, justify conclusions through synthesis of ideas and propose realistic improvements for the collection of data and range of techniques to analyse data effectively

To achieve D2, properly manage activities in using variety of sources for the collection of data and range of techniques to analyse data effectively

Task 2:

Prepare a Business Presentation and a formal Business Report to disseminate information effectively which include

- the findings which should be used to draw valid conclusions (You must use spreadsheet software for all calculations and incorporate graphs and charts to clearly effectively present the findings)

- trend lines in graphs to assist in forecasting for specified business information. For example, this may include people's eating behaviours overtime and preferences against seasonal changes.

- a plan for the project identifying the Critical Success Factors and the Critical path to implement a business process and the recommendations you are suggesting from your findings. For example, a business process to serve customers

- different financial tools such as discounted cash flow and IRR functions to evaluate the financial viability if the proposed recommendations

To achieve M2, apply and justify learning methods/techniques, synthesise and process complex information to produce information in appropriate formats in decision making and in using software-generated information

To achieve M3, you need to use range of methods of presentation, have accurate technical language and appropriate communication to produce information in appropriate formats in decision making and in using software-generated information.

To achieve D3, incorporate your previous knowledge to produce information in appropriate formats in decision making and in using software-generated information.

Create a plan for the collection of primary and secondary data for a given business problem

Present the survey methodology and sampling frame used

Design a questionnaire for a given business problem

Create information for decision making by summarising data using representative values

Analyse the results to draw valid conclusions in a business context

Analyse data using measures of dispersion to inform a given business scenario

Explain how quartiles, percentiles and the correlation coefficient are used to draw useful conclusions in a business context

Produce graphs using spreadsheets and draw valid conclusions based on the information derived

Create trend lines in spreadsheet graphs to assist in forecasting for specified business information

Prepare a business presentation using suitable software and techniques to disseminate information effectively