Descriptive Analytics I: Nature of Data and Statistical Modeling Apply and test your knowledge of the current
Question:
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 |
- 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.
- Construct a PivotChart to visualize the purchase order total units for steel forks and ceramic bowls within each region.
- Click any single cell inside the data set.
- Excel automatically selects the data for you. The default location for a new pivot table is New Worksheet.
- Click OK.
- 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. "
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill