Descriptive Analytics I: 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. 

• Following is the order database of XYZ restaurant in Sydney between April and June 2020. 
• You can download the order Database from Week 3 page on Canvas. 

 

Order Date	Item	Region	Supplier	Unit Cost	Units
5/06/2012	Steel Fork	North	Peter	5.44	98
4/07/2012	Ceramic Plate	South	Kane	23.44	53
5/13/2012	Steel Fork	South	Jones	8.44	39
6/10/2012	Silver Spoon	South	Gerry	23.44	30
6/22/2012	Steel Fork	West	Sarah	6.44	59
5/17/2012	Ceramic Plate	North	Peter	8.44	63
4/25/2012	Steel Fork	South	Audrey	5.44	78
6/01/2012	Steel Fork	South	Jones	8.44	93
4/02/2012	Steel Fork	West	Thomas	5.44	35
5/27/2012	Ceramic Plate	North	Peter	12.44	63
6/13/2012	Steel Fork	South	Mary	8.44	93
4/30/2012	Ceramic Plate	North	Henry	5.44	32
5/11/2012	Ceramic Plate	North	Philip	23.44	84
6/18/2012	Steel Fork	North	Peter	8.44	38
5/09/2012	Glass Bottle	South	Simson	128.45	5
5/30/2012	Ceramic Bowl	North	Peter	19.44	19
6/06/2012	Ceramic Plate	South	Mary	12.44	31
4/03/2012	Silver Spoon	North	Peter	12.44	67
6/26/2012	Silver Spoon	North	Philip	23.44	18
4/23/2012	Ceramic Bowl	South	Kane	8.44	99
4/29/2012	Steel Fork	South	Simson	4.74	70
4/04/2012	Ceramic Bowl	North	Philip	19.44	77
6/15/2012	Ceramic Plate	South	Gerry	12.44	49
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	8.44	53
5/01/2012	Steel Fork	South	Audrey	5.44	69
4/12/2012	Silver Spoon	North	Henry	8.44	99
4/18/2012	Steel Fork	South	Gerry	4.74	56
6/30/2012	Ceramic Plate	South	Gerry	12.44	83
5/19/2012	Glass Bottle	South	Kane	128.45	8
4/16/2012	Ceramic Bowl	North	Peter	8.44	65
6/04/2012	Ceramic Bowl	South	Mary	15.94	58
5/02/2012	Ceramic Bowl	South	Kane	27.4	45
4/19/2012	Glass Bottle	West	Sarah	278.45	6
6/11/2012	Steel Fork	South	Gerry	4.74	10
5/31/2012	Silver Spoon	West	Sarah	5.44	79
6/02/2012	Ceramic Plate	West	Thomas	23.44	60
4/13/2012	Steel Fork	South	Audrey	4.74	17
5/03/2012	Ceramic Plate	South	Jones	8.44	14
6/03/2012	Ceramic Plate	South	Jones	23.44	97
4/17/2012	Ceramic Plate	South	Audrey	8.44	31

 

 

1. Generate descriptive statistics for Unit Cost. 
   1. On the Data tab, in the Analysis group, click Data Analysis 
   2. Select Descriptive Statistics and click OK. 
   3. Select the range of the cells as the Input Range. 
   4. Select the Output Range cell. 
   5. Make sure Summary statistics is checked. 
   6. Click OK. 

 

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

 

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