• Explain how quartiles, percentiles and correlation coefficient can be used to aid decision making in the package tour market. [P2.4]

• To achieve M2, you will need to demonstrate that a range of methods and techniques have been used in analysing the relevant data to support effective decision making in business context. [related to Task 2B]

• To achieve D1, you will need to demonstrate the results in Task 2B have been validated using defined criteria such as the dispersion measures (standard deviation orcorrelation).

Task 3:

• Produce graphs and charts (pie, bar, line, ogive, histogram) using a spreadsheet to draw valid conclusions based on the information regarding the proposed project. [P3.1]
• Create a trend line on an XY- plot using a spreadsheet and use it to forecast future events within the chosen business context.[P3.2, M3]
• Prepare a business presentation based on your analysis and findings using appropriate software tools. [P3.3]
• Produce a formal business report for the proposed new product development initiative at the chosen organisation. [P3.4]

• To achieve M3, you will have used a range of methods, including appropriate technical language in creating the trend line to assist in forecasting information for decision making in yourorganisation.

Task 4:

• Using appropriate information processing tools, prepare a project plan and determine the critical path for the launch of a new tour product. [P4.1 and P4.2, D2]
• Use financial tools such as the feasibility analysis to assess viability of the project. [P4.3, D3]

• To achieve D2, you will need to demonstrate that substantial activities have been planned, organised and managed in the preparation of the projectplan.
• To achieve D3, you will need to demonstrate that innovation and creative thought have been applied in analysing the financial viability of the proposedproduct

LO1. Be able to use a variety of sources for the collection of data, both primary and secondary

• create a plan for the collection of primary and secondary data for a givenbusiness problem
• present the survey methodology and sampling frame used
• design a questionnaire for a given business problem

LO2. Understand a range of techniques to analyse data effectively for business purposes

• create information for decision making by summarising data usingrepresentative values
• analyse the results to draw valid conclusions in a business context
• analyse data using measures of dispersion to inform a given businessscenario
• explain how quartiles, percentiles, and the correlation coefficient are used to draw useful conclusions in a business context

LO3. Be able to produce information in appropriate formats for decision making in an organisational context

• produce graphs using spreadsheets and draw valid conclusions based on the information derived
• create trend lines in spreadsheet graphs to assist in forecastingfor specified business information
• prepare a business presentation using suitable software and techniques to disseminate information effectively
• produce a formal business report

LO4: Be able to use software- generated information to make decisions in an organisation

• use appropriate information processing tools
• prepare a project plan for an activity and determine the critical path
• use financial tools for decision making