STAT 220 Business Statistics

Using Excel pivot we got the following output

Column Labels
1	2	Total Count of ID number	Total Sum of Satisfaction
Row Labels	Count of ID number	Sum of Satisfaction	Count of ID number	Sum of Satisfaction
1	40	82	33	66	73	148
2	21	39	31	50	52	89
3	18	34	18	32	36	66
4	39	81	25	58	64	139
5	13	29	15	34	28	63
Grand Total	131	265	122	240	253	505

Modification of the data is tabulated as follows

Category	Male	Female
Accounting	33	40
Finance	31	21
General Management	18	18
Marketing/Sales	25	39
Other	15	13

Use Excel to draw cluster bar graph of reasons of unemployment male and female

Step 1 : Select the column of category, male and female

Step 2: Select Column > 2D-Column

Excel output

Figure (1) shows that there is a difference exists between male and female in their area of employment. The bar in Figure (1) shows that the female are more likely to select accounting/marketing while male are more likely to select finance.

Modification of the data is tabulated as follows:

Category	Very satisfied	Quite satisfied	Little satisfied	None
Accounting	1	18	136	18
Finance	0	9	19	24
General management	1	8	11	16
Marketing/Sales	6	18	21	19
Other	2	7	15	4

Table (2)

Use EXCEL to draw cluster bar graph of area of employment and job satisfaction.

EXCEL procedure:

Step1: Select the column of Category, Very satisfied, Quite satisfied, Little satisfied and

None.

Step2: Select Column > 20-Column.

Excel Output

Figure (2)

Figure (2) shows that there exists a relationship between the area of employment and job satisfaction. It is clear that graduates those who are working in marketing/sales are very satisfied when compared to the others.

Modification of the data is tabulated as follows for gender wise

Modification of the data is tabulated as follows

Category	Male	Female
Accounting	33	40
Finance	31	21
General Management	18	18
Marketing/Sales	25	39
Other	15	13

From Excel

Figure 3

Figure (3) shows that there exists a relationship between gender and area of employment. It is clear that graduates those who are working in Accounting, Finance and marketing/sales got higher jobs compared to the others.

Table for gender and Job satisfaction

Category	Male	Female	Accounting	66	82
Finance	50	39
General Management	32	34
Marketing/Sales	58	81
Other	34	29

Figure 4

Figure (4) shows that there exists a relationship between gender and job satisfaction. It is clear that graduates genders those who are working in Accounting and marketing/sales got higher jobs compared to the others.