The Stalk Market, an independent grocery chain, has been serving and supporting local communities for over 90 years. Its stores offer friendly service and a wide assortment of natural and organic foods. The company is committed to high employee satisfaction and great customer service. In an effort to better understand the characteristics of their workforce, the management has randomly selected 180 employees, who were then classified according to their job category and gender. The resulting data are summarized in the contingency table below:

 (a)  Use Excel to obtain a 100% stacked column chart for the data from the table. What does your chart suggest is the relationship between the type of job and gender?

EXCEL Instructions:

Refer to Topic 6 in the Excel Booklet for instructions on how to obtain 100% stacked column chart. Please make sure that the title of your chart ends with your network ID (e.g. The Stalk Market Employees bloggsj001).

(b) Use the contingency table to calculate the following probabilities; include an appropriate probability statement for each case:

(i). The probability that an employee is female.

(ii). The probability that an employee is male and a checkout operator.

(iii). The probability that an employee is female or a supervisor (or both).

(iv). Given that an employee is male, the probability that he is a shelf stacker.

(v). Given that an employee is a supervisor, the probability that they are female.

(c) Are 'job category' and 'gender' independent or dependent? How do you know?

Show all calculations that support your answer.