This essay focuses on the appropriate values for each quality rating. the reading assignment and lectures, program the geren cells in the table below to display the appropriate
Based on the restaurant data set (replicated below for your convenience), use Excel’s sort (Data Tab > Sort & Filter Block on ribbon > Sort Icon) to sort the data by quality rating as a first criteria and then by ascending wait times as a secondary criteria. Using the Excel functions covered in the reading assignment and lectures, program the geren cells in the table below to display the appropriate values for each quality rating. Answer the questions in the validation link (Part 2) based on your results.
restaurant data analytics is the process of analyzing every data point related to your business and converting them into meaningful insights, which can help improve everything from menus and staff straining to restaurant policies and marketing campaigns.
Unlike restaurant reporting, which involves looking at a compiled list of core metrics to compare sales and profits between specific periods, restaurant analytics allows you to do a deep dive into the numbers to better understand why your business is performing in a certain way.
So, if you want to know why a certain member of the staff is performing. It is better than others, or why you get more orders for seafood entrees on Tuesdays, let your restaurant analytics take the lead.
Firstly, Wait Times
secondly, Quality Rating
thirdly, Arithmetic Mean
Meal Price ($)
Wait Time (min)