The Excel data file named FoodIndustry.xlsx show the company/chain name, the average sales per store ($1000s), and the food segment industry for 47 restaurant chains. Arby's Sandwich 993Baskin-Robbins Snacks 207Bojangles' Chicken 1718Boston Market Chicken 1184Burger King Burger 1195Carl's Jr. Burger 1470Checkers/Rally's Burger 903Chick-fil-A Chicken 3158Chipotle Mexican Grill Mexican 2113Church's Chicken Chicken 707CiCi's Pizza Pizza/Pasta 915Culver's Burger 1838Dairy Queen Burger 545Del Taco Mexican 1100Domino's Pizza Pizza/Pasta 710Dunkin' Donuts Snacks 857El Pollo Loco Chicken 1475Five Guys Burgers & Fries Burger 1049Hardee's Burger 1145In-N-Out Burger Burger 1935Jack in the Box Burger 1379Jamba Juice Snacks 715Jason's Deli Sandwich 2556Jimmy John's Sandwich 879KFC Chicken 957Krispy Kreme Snacks 2428Little Caesars Pizza/Pasta 465McDonald's Burger 2600Moe's Southwest Grill Mexican 1103Panera Bread Sandwich 2427Papa John's Pizza/Pasta 829Papa Murphy's Pizza/Pasta 575Pizza Hut Pizza/Pasta 883Popeyes Louisiana Kitchen Chicken 1242Qdoba Mexican Grill Mexican 966Quiznos Sandwich 345Sonic Drive-In Burger 1074Starbucks Snacks 1223Steak 'n Shake Burger 1700Subway Sandwich 481Taco Bell Mexican 1363Tim Hortons Snacks 1095Wendy's Burger 1484Whataburger Burger 1996White Castle Burger 1284Wingstop Chicken 902Zaxby's Chicken 1766 (1) What was the mean U.S. sales per store for the 47 restaurant chains? (2) What are the first and third quartiles? What is your interpretation of the quartiles? (3) Show a box plot for the level of sales and discuss if there are any outliers in terms of sales that would skew the results. (4) Develop a frequency distribution showing the average sales per store for each segment. Comment on the results obtained.
The Excel data file named FoodIndustry.xlsx show the company/chain name, the average sales per store ($1000s), and the food segment industry for 47 restaurant chains.
Arby's Sandwich 993
Baskin-Robbins Snacks 207
Bojangles' Chicken 1718
Boston Market Chicken 1184
Burger King Burger 1195
Carl's Jr. Burger 1470
Checkers/Rally's Burger 903
Chick-fil-A Chicken 3158
Chipotle Mexican Grill Mexican 2113
Church's Chicken Chicken 707
CiCi's Pizza Pizza/Pasta 915
Culver's Burger 1838
Dairy Queen Burger 545
Del Taco Mexican 1100
Domino's Pizza Pizza/Pasta 710
Dunkin' Donuts Snacks 857
El Pollo Loco Chicken 1475
Five Guys Burgers & Fries Burger 1049
Hardee's Burger 1145
In-N-Out Burger Burger 1935
Jack in the Box Burger 1379
Jamba Juice Snacks 715
Jason's Deli Sandwich 2556
Jimmy John's Sandwich 879
KFC Chicken 957
Krispy Kreme Snacks 2428
Little Caesars Pizza/Pasta 465
McDonald's Burger 2600
Moe's Southwest Grill Mexican 1103
Panera Bread Sandwich 2427
Papa John's Pizza/Pasta 829
Papa Murphy's Pizza/Pasta 575
Pizza Hut Pizza/Pasta 883
Popeyes Louisiana Kitchen Chicken 1242
Qdoba Mexican Grill Mexican 966
Quiznos Sandwich 345
Sonic Drive-In Burger 1074
Starbucks Snacks 1223
Steak 'n Shake Burger 1700
Subway Sandwich 481
Taco Bell Mexican 1363
Tim Hortons Snacks 1095
Wendy's Burger 1484
Whataburger Burger 1996
White Castle Burger 1284
Wingstop Chicken 902
Zaxby's Chicken 1766
(1) What was the mean U.S. sales per store for the 47 restaurant chains? (2) What are the first and third quartiles? What is your interpretation of the quartiles? (3) Show a box plot for the level of sales and discuss if there are any outliers in terms of sales that would skew the results. (4) Develop a frequency distribution showing the average sales per store for each segment. Comment on the results obtained.
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 4 images
