• +1-617-874-1011 (US)
  • +44-117-230-1145 (UK)
Live Chat
Follow Us:

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

  1. 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

difference exists between male and female in their area of employment

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.

  1. 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)

relationship between the area of employment and job satisfaction

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.

3.

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

relationship between gender and area of employment

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.

  1. 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

relationship between gender and job satisfaction

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.

Resources

  • 24 x 7 Availability.
  • Trained and Certified Experts.
  • Deadline Guaranteed.
  • Plagiarism Free.
  • Privacy Guaranteed.
  • Free download.
  • Online help for all project.
  • Homework Help Services

Testimonials

Urgenthomework helped me with finance homework problems and taught math portion of my course as well. Initially, I used a tutor that taught me math course I felt that as if I was not getting the help I needed. With the help of Urgenthomework, I got precisely where I was weak: Sheryl. Read More