Question: please answer this question CHAPTER 7 You manage a restaurant that serves a variety of 5 different main dishes, from various national cuisines. In order

please answer this question

please answer this question CHAPTER 7 You manage a restaurant that serves

CHAPTER 7 You manage a restaurant that serves a variety of 5 different main dishes, from various national cuisines. In order to have enough inventory on hand, you have decided to create an inventory system. The first part of that will be statistical calculations about how many servings of each main dish are sold, each day of the week. Data are as follows (for the most recent two weeks): Day Roast Beef Chili Lasagna Bun Cha Escargots Mon 1 23 14 32 28 10 Tues 1 20 18 29 35 8 Wed 1 18 12 25 27 14 Thurs 1 25 15 30 22 18 Fri 1 34 25 33 30 15 Sat 1 42 33 40 37 20 Sun 1 34 30 35 32 17 Mon 2 25 17 26 27 Tues 2 21 20 30 25 12 Wed 2 16 14 26 19 15 Thurs 2 23 21 36 28 13 Fri 2 33 29 42 31 15 Sat 2 36 33 39 30 19 Sun 2 29 24 31 22 13 Enter these data into an Excel spreadsheet, with the same rows and columns as presented above. Provide a column for the total of each row, and a row for the total of each column, and a total of totals in the far right corner. Also provide a row of average amount sold for each main dish. Properly program Excel to calculate these row and column totals, as well as the row of averages. Then, answer the following questions: a. Which dish was the most popular one served, during these two weeks? b. Which dish was the least popular one served, during these two weeks? c. On which day of the week was the restaurant most busy, during the two-week period? (Assume each customer has ordered a main dish.) Is the answer the same for both weeks? 159 d. On which day of the week was the restaurant least busy over the two-week period? (Assume each customer has ordered a main dish.) Is the answer the same for both weeks? e. If you calculate the average number of each dish sold within each week separately, are these averages similar to each other per dish, or do they vary widely? Deliverable: One worksheet, and the answers to the five questions above, supported by your numeric data. For any averages you calculate, be sure to use the special Excel AVG function...... do not create the formulas yourself

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!