Question

Company	Segment	2012 U.S. Average Sales per Store ($1,000s)
Arby's	Sandwich	993
Baskin-Robbins	Snacks	207
Bojangles'	Chicken	1,718
Boston Market	Chicken	1,184
Burger King	Burger	1,195
Carl's Jr.	Burger	1,470
Checkers/Rally's	Burger	903
Chick-fil-A	Chicken	3,158
Chipotle Mexican Grill	Mexican	2,113
Church's Chicken	Chicken	707
CiCi's Pizza	Pizza/Pasta	915
Culver's	Burger	1,838
Dairy Queen	Burger	545
Del Taco	Mexican	1,100
Domino's Pizza	Pizza/Pasta	710
Dunkin' Donuts	Snacks	857
El Pollo Loco	Chicken	1,475
Five Guys Burgers & Fries	Burger	1,049
Hardee's	Burger	1,145
In-N-Out Burger	Burger	1,935
Jack in the Box	Burger	1,379
Jamba Juice	Snacks	715
Jason's Deli	Sandwich	2,556
Jimmy John's	Sandwich	879

Company	Segment	2012 U.S. Average Sales per Store ($1,000s)
KFC	Chicken	957
Krispy Kreme	Snacks	2,428
Little Caesars	Pizza/Pasta	465
McDonald's	Burger	2,600
Moe's Southwest Grill	Mexican	1,103
Panera Bread	Sandwich	2,427
Papa John's	Pizza/Pasta	829
Papa Murphy's	Pizza/Pasta	575
Pizza Hut	Pizza/Pasta	883
Popeyes Louisiana Kitchen	Chicken	1,242
Qdoba Mexican Grill	Mexican	966
Quiznos	Sandwich	345
Sonic Drive-In	Burger	1,074
Starbucks	Snacks	1,223
Steak 'n Shake	Burger	1,700
Subway	Sandwich	481
Taco Bell	Mexican	1,363
Tim Hortons	Snacks	1,095
Wendy's	Burger	1,484
Whataburger	Burger	1,996
White Castle	Burger	1,284
Wingstop	Chicken	902
Zaxby's	Chicken	1,766

What was the mean U.S. sales (in thousand dollars) per store for the 47 restaurant chains? (Round your answer to one decimal place.)

$   thousand

(b)

What are the first and third quartiles (in thousand dollars)?

first quartile $   thousand

third quartile $   thousand

What is your interpretation of the quartiles?

Twenty-five Seventy-five One hundred  percent of the restaurants have an average sales per unit less than or equal to the first quartile and ______ percent of the restaurants have an average sales per unit greater than or equal to the third quartile.

(c) Show a boxplot for the level of sales.

Are there are any outliers in terms of sales that would skew the results? Yes/No   

(d) Develop a frequency distribution showing the average sales (in thousand dollars) per store for each segment. (Round your answers to the nearest thousand dollars.)

Segment	Average Sales per unit ($1,000s)
Burger	$   thousand
Chicken	$   thousand
Mexican	$   thousand
Pizza/Pasta	$   thousand
Sandwich	$   thousand
Snacks	$   thousand

Comment on the results obtained: The segment with lowest average sales per unit is _____

Answer 1

Solution: I have used excel to solve this problem.

Let us arrange the given data in ascending order to make our calculation easier. The arranged dataset is as follows.

Company	Segment	2012 U.S.(Average sales per store)($1,000s)
Baskin-Robbins	Snacks	207
Quiznos	Sandwich	345
Little Caesars	Pizza/Pasta	465
Subway	Sandwich	481
Dairy Queen	Burger	545
Papa Murphy's	Pizza/Pasta	575
Church's Chicken	Chicken	707
Domino's Pizza	Pizza/Pasta	710
Jamba Juice	Snacks	715
Papa John's	Pizza/Pasta	829
Dunkin' Donuts	Snacks	857
Jimmy John's	Sandwich	879
Pizza Hut	Pizza/Pasta	883
Wingstop	Chicken	902
Checkers/Rally's	Burger	903
CiCi's Pizza	Pizza/Pasta	915
KFC	Chicken	957
Qdoba Mexican	Mexican	966
Arby's	Sandwich	993
Five Guys	Burger	1049
Sonic Drive-In	Burger	1074
Tim Hortons	Snacks	1095
Del Taco	Mexican	1100
Moe's Southwest	Mexican	1103
Hardee's	Burger	1145
Boston Market	Chicken	1184
Burger King	Burger	1195
Starbucks	Snacks	1223
Popeyes Louisiana	Chicken	1242
White Castle	Burger	1284
Taco Bell	Mexican	1363
Jack in the Box	Burger	1379
Carl's Jr.	Burger	1470
El Pollo Loco	Chicken	1475
Wendy's	Burger	1484
Steak 'n Shake	Burger	1700
Bojangles'	Chicken	1718
Zaxby's	Chicken	1766
Culver's	Burger	1838
In-N-Out Burger	Burger	1935
Whataburger	Burger	1996
Chipotle Mexican	Mexican	2113
Panera Bread	Sandwich	2427
Krispy Kreme	Snacks	2428
Jason's Deli	Sandwich	2556
McDonald's	Burger	2600
Chick-fil-A	Chicken	3158

Sum

59934

a) The mean U.S. sales (in thousand dollars) per store for the 47 restaurant chains is 1275.2 $ thousand.

	Formulas
Mean	Sum of all values/Number of observation=59934/47	1275.2

b)First and Third quartiles (in thousand dollars)

First quartile is the median of the lower half of the data set.

Third quartile is the median of the upper half of the data set.

	Formulas
First quartile	QUARTILE(C2:C48,1)	881 $ thousands
Third quartile	QUARTILE(C2:C48,3)	1709 $ thousands

Twenty-five percent of the restaurants have an average sales per unit less than or equal to the first quartile and Seventy-five percent of the restaurants have an average sales per unit greater than or equal to the third quartile.

c) To draw the Boxplot we need to calculate the following.

	Formulas
Minimium		207
First quartile	QUARTILE(C2:C48,1)	881
Median	MEDIAN(C2:C48)	1103
Third quartile	QUARTILE(C2:C48,3)	1646
Maximum		3158

Median=(n+1)/2=(47+1)/2=48/2=24th value in the data set is the median. In the first table above , i have marked median in red colour.

From the above graph, we can see there are no outliers.

d)Let us find the average sales segment wise and its screenshot is as follows.

Segment	Average Sales per unit($1,000s)
Burger	1450.77
Chicken	1456.56
Mexican	1329.00
Pizza/Pasta	729.50
Sandwich	1280.17
Snacks	1087.50

The segment with lowest average sales per unit is Pizza/Pasta.