"Raw Data Representation and Interpretation Solution"…Complete Answer! Thanks

Raw Data Representation and Interpretation

Problem Situation: The CEO of your company has asked you, the human resource manager, to conduct a study to determine whether or not male managers and female managers perceive leadership styles differently and, if differences are found, to develop a training program that will benefit gender differences in leadership. To this end you selected, randomly, 10 male managers and 10 female managers to participate in your study. To each manager a leadership style survey questionnaire was administered. The questionnaire chosen was the Blake & Mouton Managerial Grid as it assesses leadership behavior. The numeric raw data results of the 18 question study are as follows:

Raw Numeric Questionnaire Data

Question

1

2

3

4

5

6

7

8

9

Male

4

4.6

3.2

3.9

4.2

3.7

4.1

4.5

3.5

Female

4.2

4.1

4.2

4.6

3.9

4.1

4.7

4.1

4.2

Raw Numeric Questionnaire Data

Question

10

11

12

13

14

15

16

17

18

Male

4

3.9

4

3

4.5

4.9

3

3.3

3

Female

4

4.2

4.1

4

4.5

4.3

3.9

4

3.7

Complete the following in a single MS Word or Excel document:

1. Calculate the mean, median, mode, variance, and standard deviation for the numeric data.
2. Construct a histogram, pie, or Stem-Leaf Display chart encompassing the mean leadership scores for both male and female managers. Use an online interactive program to formulate your histogram, pie charts, or Stem-Leaf Display.
3. Construct a histogram for median score values for male managers and female managers with respect to management style.
4. Analyze the data and present preliminary conclusions based on answers to questions #2 and #3 with respect to the leadership style differences between male and female managers.
5. Offer a brief 5-point summary of the training program you might use to strengthen the leadership deficiencies found in either or both the male and female manager leadership styl