From table 2 estimate the median expenditure of the consumers using the interpolation method. Show all your working using a calculator.

Task 2: Grouped Descriptive Statistics 22 marks

It was suggested to the retailer that the 200 transaction values could also be summarised in a grouped table (see Table 2 below). Table 2 have been made available in the Excel file named “MN4063QANOVS22CWK1 Data” under the worksheet named Task 2.

Required for Task 2 (50 words Max)

a. Using the two table templates provided in the Excel data file named “MN4063QANOVS22CWKIData” under the tab labelled Task 2: •

• Complete table 2a to show the percentage frequencies, cumulative frequencies and cumulative percentage frequencies columns. (1+1+1 = 3 marks). Round all answers to the nearest whole number
• Complete table 2b and use your results to estimate the mean and the standard deviation. (10 +2+2 = 4 marks.) Round all answers to the nearest whole number
• (Copy the Excel output (2 tables) and paste it into your Word document)

b. From table 2 estimate the median expenditure of the consumers using the interpolation method. Show all your working using a calculator. (2 + 3 = 5 marks) Round your answer to the nearest whole number