1. 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:

• Sort the data by variable "MarketSize".
• In the Results (Output) worksheet, in cell A1 type the heading Small market size sales; in cell C1, Medium market size sales and in cell E1, 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.
• 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.
• Show percentages correct to 2 decimal places.
• Use the Tabular Format report layout and label your tables accurately and informatively.