Mean, Median, Mode, and Standard Deviation Worksheet Review the following table showing a descriptive analysis of the Desirability Survey for Managers and Employees (from Slide 9 of the Professional Development Opportunities: Desirability Survey Analysis presentation): Standard Managers (21) 60 52 Based on the Professional Development Opportunities: Desirability Survey Analysis presentation showing the initial stages of a descriptive analysis of the Desirability Survey, complete the table below using complete sentences and according to the following guidelines: e Column 1 provides the populations for managers and employees. e In Column 2, write a 75- to 150-word response about the mean. What patterns does the calculation tell us about within the data? How useful is the calculation in describing the data? What additional questions does it make you ask about the data? Provide examples and rationale to support your response. In Column 3, write a 75- to 150-word response about the median. What patterns does the calculation tell us about within the data? How useful is the calculation in describing the data? What additional questions does it make you ask about the data? Provide examples and rationale to support your response. In Column 4, write a 75- to 150-word response about the mode. What patterns does the calculation tell us about within the data? How useful is the calculation in describing the data? What additional questions does it make you ask about the data? Provide examples and rationale to support your response. e In Column 5, write a 75- to 150-word response about the standard deviation. What patterns does the calculation tell us about within the data? How useful is the calculation in describing the data? What additional questions does it make you ask about the data? Provide examples and rationale to support your response. Standard Managers Professional Development Opportunities: Desirability Survey AnalysisData Sources Three data sources were considered for this presentation: 1. Employee survey to determine desirability of professional development 2. Cost of professional development per employee for various lengths 3. Employee survey to determine professional development delivery preference Data: Desirability Survey * Either ordinal data (item level) or interval data (total) * Survey deployed to 50 participants * Score determined by totaling 10 item scores on survey * For each item, participants could add between 1 and 7 points to their score total (ranging from Strongly Disagree to Strongly Agree) * Maximum score: 70; minimum score: 10 * Higher scores suggest professional development is more desired Data: Professional Development Cost * Ratio data * Costs collected from vendor for hourly rate per employee * Collected multiple rates for varying total hours of professional development Visual Representation: Desirability Survey HISTOGRAM: DESIRABILITY BOX & WHISKER: SCORES DESIRABILITY SCORES BY GROUP _ ' Employee Manager [12,23.6] (23.6,35.2] (35.2, 46.8] (46.8, 58.4] (58.4, 70] Visual Representation: Cost PROFESSIONAL DEVELOPMENT COST VS HOURS . Total Cost per Employee Hourly Cost per Employee $400.00 $350.00 $300.00 $250.00 $200.00 $150.00 $100.00 $50.00 $0.00 0 5 10 15 20 25 30 35 40 45Visual Representation: Delivery Preference DELIVERY MODE DELIVERY PREFERENCE Hybrid In Person Online Synchronous Asynchrounous 24% 36% 40% 10 20 6 DELIVERY METHOD Synchronous Asynchronous 8 6 32% HYBRID IN PERSON ONLINE 68%Desirability Statistical Analysis: Descriptive Population (N) Mean (95% Cl) m_ Standard Deviation Managers (21) 60.52 (4.23) 60 9.28 Employees (29) 52.79 (5.90) 57 68 15.52