You will be assessed on your knowledge of methods for identifying organizational development needs. You will be given (fictitious) data from an organizational survey. Your task is to analyze the data, identify problem areas for the startup, and suggest a possible intervention. Please arrange your report in the following way:
Part 1: Excel file
Provide the reformatted excel file. It should include all of the modifications and analyses you performed.
Part 2: Describe the workforce (100-200 words) #ODMethodology
Conduct descriptive statistics for the workforce. Identify the means and standard deviations for all of the key variables and explain any meaningful results.
Part 3: Identify relationships (100-200 words) #ODMethodology
Conduct correlations between work characteristics and outcome variables. Conduct at least 2 correlations and explain the results. Report the results in APA style.
Part 4: Compare groups (100-200 words) #ODMethodology
Provide t-tests between different demographics of employees on outcome variables. Conduct at least 2 t-tests and explain the results. Report the results in APA style.
Part 5: Intervention suggestion (300-400 words) #ODSolutions
Identify an issue raised by one of your analyses that the organization should try to change. Describe something you could do to support each phase of change (unfreezing, moving, and refreezing).
Demographics:
Age
Department
Gender
Work characteristics:
Work flexibility
Supervisor support
Autonomy
Incivility
Outcome variables:
Engagement
Fatigue
Job satisfaction
Performance
Learning Outcomes Added
LO4_ODSolutions: Design/Discover new solutions to organizational problems based on market needs.
LO6_ODMethodology: Choose Positive Organizational Development methodologies for strategic data collection and analysis.
i uploaded my excel file but I didn’t finish it, finish it for me please and use it to do the assignment