Task2:Grouped DescriptiveStatistics[20marks]

Itwassuggestedtotheretailer thatthe130transactionvalues couldalsobesummarisedinagrouped table (see Table 2 below). Two table templates based on Table 2

Table 1
Expenditure ()	Frequency	Frequency(%)	Cumulative Frequency	Cumulative Frequency (%)
0 < 100	14
100 < 200	35
200 < 300	65
300 < 400	16
Total:
Table 2
Expenditure ()	Frequency (f)	midpoint (x)	fx	(x-mean)	(x-mean)2	f(x-mean)2
0 < 100	14
100 < 200	35
200 < 300	65
300 < 400	16
Total:
Mean
Variance
Standard Deviation

RequiredforTask2

1. Using the two tabletemplates providedintheExceldatafile named "MN4063QA APR22 CWK 1 Data" under the tab labelled Task 2:

• Complete table 1 to show the percentage frequencies, cumulative frequencies and cumulative percentagefrequencies. [3marks]
• Completetable 2toestimatethemeanandstandarddeviation. [9marks]

1. Using table 1 estimate the median expenditure of the consumers by interpolation method [5marks]
2. Interpret the median expenditure value of the consumers [3marks]