Unit Cost 1.99 19.99 Units 95 50 36 27 56 60 75 90 19.99 2.99 4.99 1,99 4,99 1.99 8.99 4.99 1.99 19.99 125,00 Order Oate Region Staff em 119 East Jones Pencil 112119 Central Binder 2019 Central Jardine Poncil 2/26/19 Central G Pen 3/15/19 West Sorvino Pencil 4/1/19 East Jones Binder 4/18/19 Central Andrews Pencil 5/5/19 Central Jardine Pencil 5/22/19 West Thompson Pencil 6/8/19 East Jones Binder 6/25/19 Central Morgan Pencil 7/12/19 East Howard Binder 7729/19 Eas! Part Binder 8/15/19 East Jones Pencil 9/1/19 Central Smith Desk 9/18/19 East Jones Pen Set 1005/19 Central Maran Binder 10/22/19 East Jones Pen 11/8/19 East Parent Pen 11/25/19 Central Kivell Pen Set 12/12/19 Central Smith Pencil 12/29/19 East Parent Pen Set 1/15/20 Central GO Binder 2/1/20 Central Smith Binder 218/20 East Jones Binder 3/7/20 West Sorvino Binder 3/24/20 Central Jardine Pen Set 4710/20 Central Andrews Pencil 4/27/20 East Howard 5/14/20 Central G Pencil 5/31/20 Central Binder 6/17/20 Central ove Desk 7/420 East Jones Pen Set 60 90 29 81 35 2 16 28 64 15 86 67 74 46 8.99 19.99 4.90 1.29 15,99 8.99 15.00 4.89 19.90 4,99 1.99 4.99 1.29 8.99 125.00 4 7 50 66 96 53 80 5 62 Pen 2 712120 Central Morgan Pen Set 8/7/20 Central Novell Pen Set 24/20 West Sorvino 9/10/20 Central G Pencil 9/27/20 West Sorvino Pon 10/14/20 West Thompson Binder 10/31/20 Central Andrews Pencil 11/17.00 Central Jardine Binder 1214720 Central Jardine Binder 1221/20 Central Andrews Binder 55 42 3 7 78 57 14 11 94 28 12.49 23,95 275.00 129 1.99 19.99 1.29 4.99 19.99 Sarah has instructed you to perform the following tasks: 1.1 Data capturing (4 points Capture data accurately on MS-Excel 1.2 Data analysis a) (18 points) Analyse which quarter had the highest expenditure on stationery. Add percentages for each expense em per quarter. Furthermore, determine the average quarterly stationery expense amount per quarter. b) (22 points) Show a yearly percentage frequency table with the following columns Staff Court Total expense M Percentage Unit Cost 1.99 19.99 Units 95 50 36 27 56 60 75 90 19.99 2.99 4.99 1,99 4,99 1.99 8.99 4.99 1.99 19.99 125,00 Order Oate Region Staff em 119 East Jones Pencil 112119 Central Binder 2019 Central Jardine Poncil 2/26/19 Central G Pen 3/15/19 West Sorvino Pencil 4/1/19 East Jones Binder 4/18/19 Central Andrews Pencil 5/5/19 Central Jardine Pencil 5/22/19 West Thompson Pencil 6/8/19 East Jones Binder 6/25/19 Central Morgan Pencil 7/12/19 East Howard Binder 7729/19 Eas! Part Binder 8/15/19 East Jones Pencil 9/1/19 Central Smith Desk 9/18/19 East Jones Pen Set 1005/19 Central Maran Binder 10/22/19 East Jones Pen 11/8/19 East Parent Pen 11/25/19 Central Kivell Pen Set 12/12/19 Central Smith Pencil 12/29/19 East Parent Pen Set 1/15/20 Central GO Binder 2/1/20 Central Smith Binder 218/20 East Jones Binder 3/7/20 West Sorvino Binder 3/24/20 Central Jardine Pen Set 4710/20 Central Andrews Pencil 4/27/20 East Howard 5/14/20 Central G Pencil 5/31/20 Central Binder 6/17/20 Central ove Desk 7/420 East Jones Pen Set 60 90 29 81 35 2 16 28 64 15 86 67 74 46 8.99 19.99 4.90 1.29 15,99 8.99 15.00 4.89 19.90 4,99 1.99 4.99 1.29 8.99 125.00 4 7 50 66 96 53 80 5 62 Pen 2 712120 Central Morgan Pen Set 8/7/20 Central Novell Pen Set 24/20 West Sorvino 9/10/20 Central G Pencil 9/27/20 West Sorvino Pon 10/14/20 West Thompson Binder 10/31/20 Central Andrews Pencil 11/17.00 Central Jardine Binder 1214720 Central Jardine Binder 1221/20 Central Andrews Binder 55 42 3 7 78 57 14 11 94 28 12.49 23,95 275.00 129 1.99 19.99 1.29 4.99 19.99 Sarah has instructed you to perform the following tasks: 1.1 Data capturing (4 points Capture data accurately on MS-Excel 1.2 Data analysis a) (18 points) Analyse which quarter had the highest expenditure on stationery. Add percentages for each expense em per quarter. Furthermore, determine the average quarterly stationery expense amount per quarter. b) (22 points) Show a yearly percentage frequency table with the following columns Staff Court Total expense M Percentage
