Welcome to EssayHotline!

We take care of your tight deadline essay for you! Place your order today and enjoy convenience.

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

ASSIGNMENT

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

© 2024 EssayHotline.com. All Rights Reserved. | Disclaimer: for assistance purposes only. These custom papers should be used with proper reference.