Short Answer Question - refer to data in Excel file

A soda shop manager sells 5 different types of soft drinks. He is working on training his

employees concerning suggestively selling soft drinks and food. However, he wants to

determine what customers are most likely to want before making suggestions. To do this

concerning soft drinks, he has surveyed via a probability sample his clients with the

following two questions:

Q1: Gender: (1) male (2) female

Q2: Preferred Soft Drink: (1) Coca-Cola (2) Diet Coke (3) Dr. Pepper (4) Mountain

Dew (5) Sierra Mist

Show your findings using cross tabulation. Use graphs (e.g. pie, bar, etc.) to

explain your findings. Label as required.

idsurvey loi Q2 1 1 1 NP N 2 1 2 3 1 3 3 3 4 3 N 5 1 3 2 6 2 7 2 3 3 8 N 2 9 1 3 mm 10 2 3 11 2 2 N 12 1 3 13 1 1 1 14 2 N N 15 mm 3 3 16 1 17 2 4 1 1 4 4 4 18 19 4 2 4 20 2 3