Task 2: Grouped Descriptive Statistics 122marlisi 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. 11+1+1 = 3marksl. Round all answers to the nearest whole number
• Complete table 2b and use your results to estimate the mean and the standard deviation. 110 +2+2 = l4marks1. 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. 12 + 3 = Smarks1 Round your answer to the nearest whole number
