Page 1 of 8MN4063 Understanding and Managing Data | Assessment Comp001 | Autumn 2020/21 | R van Wijnen MN4063 (Autumn) – Coursework One Worth 100% of the module mark Deadline: Friday, 22 January 2021, before 3 p.m. GMTNB: Coursework 1 consists of 2 parts. All tasks in both parts need to be attempted. PART 1 Task 1: Ungrouped Descriptive Statistics [10 marks]To gain some insights into the typical price consumers are willing to pay for a stand mixer, a retailer of kitchen appliances randomly selected 130 relevant invoices for transactions completed in October2020. Descriptive statistics, computed to summarise the data, are presented in Table 1 below. NB: Some values are missing. This table has been made available in the Excel file named “MN4063 Autumn CWK 1 Data” under the tab labelled Task 1. Table 1 – Ungrouped Descriptive Statistics Required for Task 1 (Comments for task 1 should not exceed 50 words in total.) 1.With reference to Table 1 above and using a calculator, find the mean and standard deviation. Insert your values on the table and copy into your Word document. 2.Interpret the mean and standard deviation in the context of the scenario provided. NB: You should not describe calculation methods.
Page 2 of 8MN4063 Understanding and Managing Data | Assessment Comp001 | Autumn 2020/21 | R van Wijnen Task 2: Grouped Descriptive Statistics [14 marks]It was suggested to the retailer that the 130 transaction values could also be summarised in a grouped table (see Table 2 below). Three table templates based on Table 2 have been made available in the Excel file named “MN4063 Autumn CWK 1 Data” under the tab labelled Task 2. Table 2 – Grouped Descriptive Statistics Required for Task 2(Comments for task 2 should not exceed 50 words in total.)
1.Using the three table templates provided in the Excel data file as a starting point, construct three tables in Excel. The first table should show the frequencies and percentage frequencies. The second table should show the ‘less than’ cumulative frequencies and cumulative percentage frequencies. Complete the third table to estimate the mean and standard deviation. You need to copy the Excel output (3 tables) into your Word document.
2.Compare the grouped data mean and standard deviation values to the ungrouped data mean and standard deviation calculated under task 1. Why are the values different and which findings are more accurate; the ungrouped or grouped statistics? Justify your answer.3.With reference to fig. 1 below (ogive), comment on the estimated minimum amount a consumer needs to spend on a stand mixer to belong to the top 25% in terms of expenditure.Fig. 1 – Ogive Showing Cumulative Percentage Frequencies
