By Wednesday, July 31, 2013, post your assignment to the M1: Assignment 3 Dropbox.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 DataQuestion 1 2 3 4 5 6 7 8 9Male 4 4.6 3.2 3.9 4.2 3.7 4.1 4.5 3.5Female 4.2 4.1 4.2 4.6 3.9 4.1 4.7 4.1 4.2Raw Numeric Questionnaire DataQuestion 10 11 12 13 14 15 16 17 18Male 4 3.9 4 3 4.5 4.9 3 3.3 3Female 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:Calculate the mean, median, mode, variance, and standard deviation for the numeric data.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.Construct a histogram for median score values for male managers and female managers with respect to management style.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.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 style.