EARLS KITCHEN & BAR IS A SLEEK, UPSCALE CHAIN SERVING GOURMET BURGERS,

GLOBAL COMFORT FOOD, COCKTAILS, WINES & BEERS. FOUNDED IN $1982$ BY

FATHER$-$SON DUO BUS AND STAN FULLER, EARLS HAS BEEN BUILT ON THE

FOUNDATION OF FAMILY SINCE DAY ONE.

THE COMPANY IS INTERESTED TO LEARN ABOUT THEIR CUSTOMERS

CHARECTERISTICS AND SPENDING PATTERNS. THEY HAVE DECIDED TO COLLECT ALL

THE DATA DURING A SPECIFIC DAY DURING DINNER TIME FROM ONLY FIVE

DIFFERENT LOCATIONS OUT OF ALL THEIR $20$ ONTARIO LOCATIONS AND WILL NEED

YOUR HELP ANALYZING THE DATA.

OPEN THE FILE RE$1-$DATA.XLS AND YOU$$LL FIND THE DATA AS IT WAS GIVEN BY THE

INFORMATION TECHNOLOGY DEPATMENT TO THE ANALYTICS DEPARTMENT.

THE FILE CONTAINS THE FOLLOWING DATA $($IN COLUMNS $$ IN SEQUENCE, LEFT TO

RIGHT$)$:

$1.$ AGE OF THE PAYING CUSTOMER

$2.$ NUMBER OF PEOPLE WHO DINED WITH THE CUSTOMER $($NOT INCLUDING THE

CUSTOMER$)$

$3.$ CUSTOMER GENDER $(1=$FEMALE, $2=$MALE, $3=$OTHER$)$

$4.$ LOCATION

$5.$ AMOUNT SPENT ON MEAL ON THAT DAY

REQUIRED:

$1.$ CATEGORIZE EACH DATA SET BY TYPE.

$2.$ WHAT TYPE OF SAMPLING METHOD DID THE COMPANY USE?

$3.$ CONSTRUCT A FREQUENCY DISTRIBUTION TABLE TO REPRESENT THE NUMBER

OF TRANSACTIONS PER LOCATION. $*$YOU WILL BE REQUIRED TO ANSWER

QUESTIONS BASED ON YOUR FINDINGS.

$4.$ CONSTRUCT THE APPROPRIATE CHART TO DESCRIBE THE AMOUNT

CUSTOMERS SPENT ON THEIR MEAL.

a$.$ USE THE HISTOGRAM TOOL IN THE EXCEL DATA ANALYSIS TOOLPAK TO

AUTOMATICALLY GENERATE THE HISTOGRAM WITH THE GIVEN DATA.

KEEP THE BIN RANGE BLANK.

b$.$ COMPUTE THE REQUIRED NUMBER OF BINS, SET YOUR OWN BIN

RANGES AND CREATE YOUR OWN HISTOGRAM. ROUND THE BIN

RANGE VALUES TO $1$ DECIMAL PLACE.

$*$YOU WILL BE REQUIRED TO ANSWER QUESTIONS BASED ON YOUR

FINDINGS