Description
Tasks need to be clearly labelled in your submission. Each task should start on a fresh page. Tables and
graphs must be numbered and titled. Calculation methods should not be described: comment on the
meaning or significance of the calculated values only.
2. For part 1, task 1, you need to calculate the 2 missing values (Sum and Variance) using a calculator. The
values must be inserted into the table found under the tab labelled Task 1. The completed table must be
copied into the Word document. Short comments need to be providedon the findings.
For part 1, task 2, you need to complete three tables in Excel. The first should show the frequencies and percentage frequencies. The second should show the ‘max in class’, cumulative frequencies and percentage cumulative frequencies. The third should be prepared to find the mean and standard deviation. Short comments need to be provided under points 2 and 3.
For part 1, task 3, you need to discuss the various concepts, provide examples and justify your recommendation. One reference needs to be provided for task 3.
The source needs to be cited in the text and listed in a bibliography. The Harvard referencing style must be used.
Part 1, task 4 requires the construction of a network diagram to reveal the project’s critical path and duration. The difference between critical and non-critical activities should be discussed.
For part 1, task 5, you need to use an appropriate Excel function to create a correlation matrix toshow the
relationship coefficients between all relevant variables. The best predictor of the quarterly Sales Revenue
(£’000) is identified and the reason for its selection is justified. A titled, well-labelled scatter graph, with
the trend, regression equation and coefficient of determination, is presented.
The regression equation is stated in context (i.e. using variable names rather than x and y). The relationship and the various coefficients are explained in context.
Part 1, Task 6 requiresthe evaluation of expected returns and relative risk. The least risky projectshould be
identified.
Part 1, Task 7 requires a short, reflective commentary, written in a first-person narrative.
Part 2 requires the preparation of a 400-word report to advise management on procedure, costs, breakeven and target quantities and safety margins
Required Excel output, i.e. tables and graphs, needs to be copied into your Word document and presented alongside the comments and / or report.
3. Comment on the facts only: avoid speculations and generalisations. Comments must be supported by the
evidence and show units of measurement, where appropriate.
Page 8 of 8
MN4063QA MN4063QA Understanding and Managing Data July21 Intake
Understanding and Managing Data | Assessment Comp001 | Autumn 2020/21 | R van Wijnen
4. Adopt a formal, professional language (third person, impersonal) for part 1, tasks 1 through 6 and for the
report of part 2. This means you should avoid the use of ‘I’, ‘you’, ‘we’, ‘my’, etc. The personal reflection
(part 1, task 7) should be written in first person perspective.
5. The word limit for this coursework is 1000 words in total: 600 words for part 1 and 400 words for part 2.
4 HARVARD STYLE REFERECES REQUIRED
