Answered step by step
Verified Expert Solution
Question
1 Approved Answer
123 12 Site Atlanta 3 Atlanta 4 Atlanta 5 Atlanta 6 Atlanta 7 Atlanta 8 Birmingham 9 Birmingham 10 Birmingham 11 Birmingham 12 Birmingham 13
123 12 Site Atlanta 3 Atlanta 4 Atlanta 5 Atlanta 6 Atlanta 7 Atlanta 8 Birmingham 9 Birmingham 10 Birmingham 11 Birmingham 12 Birmingham 13 Birmingham 14 Fayetteville 15 Fayetteville 16 Fayetteville 17 Fayetteville 18 Fayetteville Tier Menu Item 1 Chicken 1 Sandwich 1 Salad 1 Steak 1 Burrito 1 Vegan Customer Rating Excellent Average Below Average Excellent Above Average Below Average 1 Chicken Above Average 1 Sandwich Above Average Below Average 1 Salad 1 Steak 1 Burrito 1 Vegan 3 Chicken Average Excellent Unacceptable Above Average 3 Sandwich Above Average 3 Salad Above Average Excellent 3 Burrito 3 Steak Numeric Rating + 23 Jackson 24 Jackson 25 Jackson 26 Montgomery 27 Montgomery 28 Montgomery 19 Fayetteville 20 Jackson 21 Jackson 22 Jackson 3 Vegan 3 Chicken 3 Sandwich 3 Salad 3 Burrito 3 Vegan 2 Chicken Average Average Above Average Excellent Average Above Average Below Average Average Excellent Above Average 3 Steak 2 Sandwich 2 Salad Excellent 29 Montgomery 2 Steak Excellent 30 Montgomery 2 Burrito Average 31 Montgomery 32 Nashville 33 Nashville 34 Nashville 35 Nashville 36 Nashville 37 Nashville 38 Opelika 39 Opelika 40 Opelika 41 Opelika 2 Steak Above Average 2 Vegan 1 Chicken 1 Sandwich 1 Salad 1 Steak 1 Burrito 1 Vegan 2 Chicken 2 Sandwich 2 Salad Excellent Excellent Below Average Above Average Excellent Average Below Average Average Above Average Average 21. In the Numeric Rating column, use a function to change the customer ratings into numeric ratings. Rating should be as follows: Excellent = 5, Above Average = 4, Average = 3, Below Average = 2, Unacceptable = 1
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started