Data Analytics Homework 4

Data Analytics Homework 4

Before diving into this assignment, I very strongly advise which you watch the films on Panopto.
The workbook related to this homework carries 2 worksheets:
• An Answers sheet that you may fill in with the solutions and reasons for the problems
under on this document.
• A Q1 2018 Order Details sheet that carries the entire info of all pizza orders made at
Pops Pizza for the duration of Quarter 1 of 2018. This sheet carries one row in step with line–object at the orders
receipt, so there can be more than one rows related to an order. It has the comply with following
columns:
o The date an order turned into located
o The Order ID
o The storefront area the order turned into located at (Scranton or Wilkes–Barre)
o The Pizza # that the precise file belongs to. EX: Order ID 2018–00002–T has an X–
Large Pizza with Onions, Pineapple, and Extra Cheese, which may be understood by
searching on the four traces related to Order ID 2018–00002–T. All four of those statistics are
a part of Pizza #1 for that order. If the patron had ordered a 2nd pizza, then the
statistics related to that pizza might have Pizza# 2. A proper instance of that is order
2018–00004–T, which has four pizzas, handiest certainly considered one among which has a topping.
o The Product name
o The Product category
o The Products sale price o What kind of order this turned into (dine–in, take–out, or on-line) o The fee approach for the order (cash, credit score, paypal, or on-line credit score) o Any bargain that turned into carried out to the order (none, military, senior, or student) Your project is to use what youve found out to date from Part 2 of this lab in Excel to authoritatively solution
the questions under. You can be loose to put out your ensuing paintings/spreadsheets in any way you see
match as long as they surely solution the questions.
Please note: I can be grading your cappotential to now no longer handiest convincingly solution the questions I ask, however also
your cappotential to bring and display your paintings in a clean, smooth to recognize way. If you offer me
solutions for a trouble however dont have a worksheet wherein I can move and locate the paintings you used to get your solutions, you may get hold of no credit score for that trouble. Part of studying the way to use Excel is studying to make fashionable spreadsheets. I need you to position idea into the arrival of your paintings, knowing that you may frequently want to proportion your Excel workbooks with others. Each query can be graded as follows: • 50% – Does your written explanation / justification for the solution correctly describe the solution in a manner a layperson can recognize? • 50% – Is there paintings achieved in Excel which could justify your written solution? Work is taken into consideration to be the formulas/capabilities/worksheets used to reply the trouble. Do any worksheets or capabilities made to reply the trouble include the vital Excel paintings had to solution the query posed withinside the trouble, specified in a way thats clean to recognize?

Reminder: If you offer a written solution to a trouble however do now no longer have backing Excel paintings, you may
get hold of no credit score for the trouble.
Im satisfied to present partial credit score. If youve come to the incorrect solution however have paintings that indicates me how
you purchased to that solution, you may get hold of partial credit score for the trouble.

SOLUTION ANSWER

2018-00026-T Wilkes-Barre 4 Medium Pizza 9.5 Take-Out Cash Senior 2018-00026-T Wilkes-Barre 4 Bacon Topping 0.75 Take-Out Cash Senior 2018-00026-T Wilkes-Barre 5 Large Pizza 10.5 Take-Out Cash Senior Discount 2018-00026-T Wilkes-Barre 5 Mushroom Topping 0.75 Take-Out Cash Senior 2018-00026-T Wilkes-Barre 5 Sausage Topping 0.75 Take-Out Cash Senior 2018-00026-T Wilkes-Barre 6 X-Large Pizza 11.5 Take-Out Cash Senior Discount 2018-00026-T Wilkes-Barre 7 Large Pizza 10.5 Take-Out Cash Senior Discount 2018-00027-T Wilkes-Barre 1 Medium Pizza 9.5 Take-Out Cash Senior 2018-00027-T Wilkes-Barre 1 Mushroom Topping 0.75 Take-Out Cash Senior 2018-00027-T Wilkes-Barre 2 Large Pizza 10.5 Take-Out Cash Senior Discount 2018-00027-T Wilkes-Barre 3 Medium Pizza 9.5 Take-Out Cash Senior 2018-00027-T Wilkes-Barre 4 Medium Pizza 9.5 Take-Out Cash Senior 2018-00027-T Wilkes-Barre 4 Olives Topping 0.75 Take-Out Cash Senior 2018-00027-T Wilkes-Barre 4 Bacon Topping 0.75 Take-Out Cash Senior 2018-00027-T Wilkes-Barre 5 Large Pizza 10.5 Take-Out Cash Senior Discount 2018-00027-T Wilkes-Barre 5 Olives Topping 0.75 Take-Out Cash Senior 2018-00027-T Wilkes-Barre 5 Pepperoni Topping 0.75 Take-Out Cash Senior 2018-00028-O Scranton 1 Medium Pizza 9.5 Online Paypal Military 2018-00028-O Scranton 1 Sausage Topping 0.75 Online Paypal Military 2018-00028-O Scranton 2 Large Pizza 10.5 Online Paypal Military Discount 2018-00028-O Scranton 2 Peppers Topping 0.75 Online Paypal Military 2018-00028-O Scranton 2 Extra Cheese Topping 0.75 Online Paypal Military 2018-00029-D Scranton 1 X-Large Pizza 11.5 Dine-In Cash Senior Discount 2018-00029-D Scranton 1 Peppers Topping 0.75 Dine-In Cash Senior 2018-00029-D Scranton 2 Large Pizza 10.5 Dine-In Cash Senior Discount 2018-00029-D Scranton 2 Peppers Topping 0.75 Dine-In Cash Senior 2018-00029-D Scranton 2 Olives Topping 0.75 Dine-In Cash Senior 2018-00029-D Scranton 3 X-Large Pizza 11.5 Dine-In Cash Senior Discount 2018-00029-D Scranton 4 Large Pizza 10.5 Dine-In Cash Senior Discount 2018-00030-O Wilkes-Barre 1 Medium Pizza 9.5 Online Online Credit Senior 2018-00030-O Wilkes-Barre 1 Pepperoni Topping 0.75 Online Online Credit Senior 2018-00030-O Wilkes-Barre 1 Olives Topping 0.75 Online Online Credit Senior 2018-00030-O Wilkes-Barre 2 X-Large Pizza 11.5 Online Online Credit Senior Discount 2018-00031-D Wilkes-Barre 1 Large Pizza 10.5 Dine-In Cash None Discount 2018-00031-D Wilkes-Barre 1 Pepperoni Topping 0.75 Dine-In Cash None 2018-00032-T Wilkes-Barre 1 X-Large Pizza 11.5 Take-Out Cash None Discount 2018-00032-T Wilkes-Barre 2 Large Pizza 10.5 Take-Out Cash None Discount 2018-00033-O Scranton 1 Medium Pizza 9.5 Online Online Credit None 2018-00033-O Scranton 1 Sausage Topping 0.75 Online Online Credit None 2018-00034-T Wilkes-Barre 1 Large Pizza 10.5 Take-Out Cash None Discount 2018-00034-T Wilkes-Barre 2 X-Large Pizza 11.5 Take-Out Cash None Discount 2018-00034-T Wilkes-Barre 3 Large Pizza 10.5 Take-Out Cash None Discount 2018-00034-T Wilkes-Barre 3 Mushroom Topping 0.75 Take-Out Cash None 2018-00034-T Wilkes-Barre 3 Pepperoni Topping 0.75 Take-Out Cash None 2018-00034-T Wilkes-Barre 3 Bacon Topping 0.75 Take-Out Cash None 2018-00035-T Wilkes-Barre 1 Medium Pizza 9.5 Take-Out Credit Military 2018-00035-T Wilkes-Barre 2 Large Pizza 10.5 Take-Out Credit Military Discount 2018-00035-T Wilkes-Barre 2 Pepperoni Topping 0.75 Take-Out Credit Military 2018-00036-D Scranton 1 Large Pizza 10.5 Dine-In Credit None Discount 2018-00036-D Scranton 1 Olives Topping 0.75 Dine-In Credit None 2018-00036-D Scranton 2 Small Pizza 8.5 Dine-In Credit None 2018-00037-D Wilkes-Barre 1 Large Pizza 10.5 Dine-In Credit Military Discount 2018-00037-D Wilkes-Barre 1 Mushroom Topping 0.75 Dine-In Credit Military 2018-00037-D Wilkes-Barre 1 Bacon Topping 0.75 Dine-In Credit Military 2018-00037-D Wilkes-Barre 2 Medium Pizza 9.5 Dine-In Credit Military 2018-00037-D Wilkes-Barre 3 Medium Pizza 9.5 Dine-In Credit Military 2018-00038-O Scranton 1 X-Large Pizza 11.5 Online Paypal None Discount