ask questions 1-9 and explain how to do it in excel the process

Week 3 - Excel Assignment - 9 Questions - 100 points Prompt: You own a pizza shop. As the owner, you notice the competitor is offering a new deal - buy 3 pizzas get | small free (regardless of the size of the first 3 pizzas). You decide to collect data on your customers for the next week 1o see how many pizzas they usually order to see if that deal is something you should implement. Below is your collected data. Use that data for the next questions to determine if you should also offer this deal, or if there could be a different deal that would be better to offer. Question 1 10 pts How many customers did you have during the week? Question 2 5 points 'What is a possible error you could have with this collected data? Answer: Question 3 10 points 'What is the average number of pizzas ordered per customer? Have the value show only 2 decimals, Answer: J Question 4 10 points What is the median number of pizzas ordered per customer? Answer: | Question 10 points How many pizzas are most frequently ordered by customers? | Answer: Question 6 e e 5 e Fill in the table below (USING FUNCTIONS OR FORMULAS) Note: F:'?":h\".:\"'\"t": always mean it's the best/easiest/simg 20 points wmlala|w]efw]a] Question 7 15 points Create a graph of the # of pizzas ordered and the # of customers who ordered. You ver graph you feel would represent this data best. are free to select w Question 8 Say this data is all you were presented with by your employee. Would you be able to make a decision on offering the same deal as vour competitor from this data? Explain. Question 9 Based on this information, would you, as the owner, offer the same deal as your competitor? Why or why not. Justify your answer by referencing your caleulations and information above