Topic 3: Descriptive Analytics 1: Nature of Data and Statistical Modeling Apply and test your knowledge of the current and previous topics by attempting the questions below. Completing these questions will help you to succeed in your subject. For this workshop, you are required to use MS Excel. Workshop Questions 1) Use the data given below to answer the following question using Microsoft Excel. I Following is the order database of XYZ restaurant in Sydney between April and June 2020. 0 You can download the order Database from Week 3 page on Canvas. Order Date Unit Cost 5/06/2012 Steel Fork 4/07/2012 Ceramic Plate 5/13/2012 Steel Fork 6/10/2012 Silver Spoon 6/22/2012 Steel Fork 5/ 1 7/2012 Ceramic Plate 4/25/2012 Steel Fork 4/02/2012 Steel Fork 5 .44 5/27/2012 Ceramic Plate 12.44 6/13/2012 Steel Fork 8.44 4/30/2012 Ceramic Plate 5 44 5/11/2012 Ceramic Plate Philip 23.44 6/18/2012 Steel Fork North Peter 8.44 5/09/2012 Glass Bottle South Simson 123 .45 5/30/2012 Ceramic Bowl North Peter 19.44 4/03/2012 Silver Spoon 6/26/2012 Silver Spoon 4/23/2012 Ceramic Bowl 4/29/2012 Steel Fork 4/04/2012 Ceramic Bowl Philip 6/15/2012 Ceramic Plate Gerry 6/25/2012 Ceramic Plate South Simson 18 .45 90 5/23/2012 Ceramic Plate North Peter 8.44 7 6/28/2012 Ceramic Plate West Sarah 23 .44 10 5/25/2012 Ceramic Bowl South Jones 5/01/2012 Steel Fork Audrey 4/12/2012 Silver Spoon 4/18/2012 Steel Fork 6/30/20 12 Ceramic Plate 5/19/2012 Glass Bottle 4/ 16/2012 Ceramic Bowl 6/04/2012 Ceramic Bowl 5/02/2012 Ceramic Bowl 4/19/2012 Glass Bottle Gerry 5/31/2012 Silver Spoon 6/ 02/20 12 Ceramic Plate 4/13/2012 Steel Fork 5/ 03/20 12 Ceramic Plate 6/03/2012 Ceramic Plate South Jones 23: .44 4/17/2012 Ceramic Plate South Audrey 31 a Generate descriptive statistics for Unit Cost. On the Data tab, in the Analysis group, click Data Analysis Select Descriptive Statistics and click OK. Select the range of the cells as the Input Range. Select the Output Range cell. Make sure Summary statistics is checked. Click OK. GNLALLQMIl b Construct a PivotChart to visualize the purchase order total units for steel forks and ceramic bowls within each region. 1. Click any single cell inside the data set. 2. Excel automatically selects the data for you. The default location for a new pivot table is New Worksheet. 3. Click UK. c- Using Microsoft Excel construct a relative frequency distribution for items in the purchase order database and show the proportions of the frequencies visually using a pie chart. 2) Use the table below to answer the following questions using Microsoft Excel. Below is a table showing the costs per order of items bought by a computer hardware store. Supplier Item Description Cost per Order A Technologies Monitors $250 A Technologies Hard Disks $220 A Technologies Power Supply 588 A Technologies Graphics Card $300 A Technologies Processor $325 A Technologies Speakers 588 M Hardware Flashdrive 59 M Hardware Graphics Card 5299 M Hardware CD-ROM 588 M Hardware Bluetooth Device 580 a- Calculate the mean cost per order. b- Calculate the mode for the cost per order data. 0- Calculate the median for the cost per order data