MN4063QA – Understanding and Managing Data
Assessment Details
| Assessment Details | Information |
|---|---|
| Module Title | Understanding and Managing Data |
| Module Code | MN4063QA |
| Module Leader | XYZ PQR |
| Year/Semester/Intake | Yr1/Sem1/April 25-26 |
| Assessment Title | Coursework 1 |
| Assessment Type | Written report |
| Word Count | 1,500 words written report |
Instructions
Answer all questions in both sections and format the assessment as Section A and B, starting each section on a separate page.
Assessment Criteria
For all tasks, you are required to correctly calculate relevant statistics, analyse the data and provide/demonstrate:
- This assessment is individual work, not pair work and not group.
- You must upload one WORD document, do not upload an Excel file or PDF of an Excel file or PDF of a Word file.
- Clear interpretations of all statistical analysis (do not just state the values but comment on what the values imply without speculating, where required).
- Graphs and tables with informative titles, appropriate labelling and units stated.
- Accurate calculations where required (equations are stated in the context of the data).
- Comments written in the context of the meaning of the data or analysis.
- Appropriate use of Excel functions, as evidenced by the output.
- You are advised not to use Safari or Explorer to upload your work to WebLearn. These browsers have known compatibility issues with WebLearn / Turnitin. Use Chrome or Firefox instead.
Individual coursework marks can range from 0% to 100%.
Task 2: Grouped Descriptive Statistics [23 Marks]
DO NOT USE A CALCULATOR FOR THIS TASK. ONLY USE EXCEL FOR THIS TASK.
It was suggested to the retailer that the invoices transactions from their London Branch above could be grouped (see Tables below).
Required for Task 2 (Max 50 words)
2a.
Complete the table below to show the percentage frequencies, cumulative frequencies, and cumulative percentage frequencies columns.
Round all answers to the nearest whole number.
DO NOT paste a picture of table into your assessment WORD document.
[1+1+1 = 3 Marks]
| Price band (£): Lower- and Upper-class boundary | Number of Invoices (f) | Percentage Frequency | Cumulative Frequency | Percentage cumulative Frequency |
|---|---|---|---|---|
| 140 – 170 | 18 | |||
| 170 – 200 | 34 | |||
| 200 – 230 | 49 | |||
| 230 – 260 | 59 | |||
| 260 – 290 | 23 | |||
| 290 – 320 | 17 |
2b.
Use the information on table below to estimate the mean and the standard deviation.
Round all answers to the nearest whole number.
DO NOT paste a picture of table into your assessment WORD document.
[8+2+2+2 = 14 Marks]
| Price band (£): Lower- and Upper-class boundary | Number of Invoices (f) |
|---|---|
| 140 – 170 | 20 |
| 170 – 200 | 35 |
| 200 – 230 | 46 |
| 230 – 260 | 56 |
| 260 – 290 | 25 |
| 290 – 320 | 18 |
2c.
From the table above (2b), estimate (interpolate) the median expenditure of the consumers.
Round your answer to the nearest whole number.
Show all your working.
[4 Marks]
2d.
A similar survey is conducted on their retailer shop located in Manchester. The mean is estimated to be £180 with a standard deviation of £26.
Use two brief sentences to describe the main differences between Manchester compared to Birmingham, and London Branches, considering the means and the coefficient of variation.
Struggling to Match UK Assignment Marking Criteria?
Understanding the marking scheme is only the first step. Many UK students lose marks due to weak structure, poor analysis or incorrect referencing. Our experts help you align your work with real UK university expectations.
- UK university marking standards
- Ethical academic guidance and proofreading
- Sample question papers for practice
- Clear feedback before final submission