2. The company uses this data set to find any patterns of sales based on the promotion type and the market sizes. To do that, firstly, it is required to separate the Sales ($'000) by the market size. To achieve this: 0 Sort the data by variable "MarketSize". o In the Results (Output) worksheet, in cell Al type the heading Small market size sales; in cell C1, Medium market size sales and in cell El, Large market size sales. Copy/paste the relevant data in columns A, C and E under these headings respectively. Then, use Excel's Pivot Table function to create the percentage frequency distribution tables. o To do that, the class intervals (groups) should start at $35 for Small market size sales with a class width of $5; start at $15 for Medium market size sales with a class width of $6 and lastly, start at $38 for Large market size sales with a class width of $6. O Show percentages correct to 2 decimal places. O Use the Tabular Format report layout and label your tables accurately and informatively. Label them Table 2(a), Table 2(b) and Table 2(c) for the Small, Medium and Large sales respectively. [9 marks] 3. Use the tables from question 2 to construct percentage frequency histograms and label them Graph 3 (a), Graph 3 (b) and Graph 3 (c)) for the Small, Medium and Large Sales respectively. Make sure you Hide/remove all field buttons from the graphs and ensure that the histograms are appropriately labelled. (Marks will be deducted for poor presentation of your tables or/and graphs) [15 marks]