Data Analysis

I'm looking for someone to write a report that involves internal data analysis (excel statistics)/market analysis/summary/graphs/charts on internal metrics of a program (data provided in a dropbox) and research on some of the external metrics (Department of Labor) for the occupational outlook (Human Resources).

The final report should be approximately 1500 words with relevant graphs/charts/tables. It should be in business writing (APA style) formatting for a professional report with sources cited. This gig involves: market analysis, data summary, professional business writing, basic statistical analysis, data analysis and reporting, and research.

For this Program Review Document- please see the last FULL Program Review document and model accordingly for formatting. (https://www.dropbox.com/s/aoo2qskorb113wp/Academic_Program_FinalHRM_Last%20Program%20Review.docx?dl=0).

The purpose of this report is explained in PHASE 1 of- https://www.dropbox.com/s/a2hraovhxocj2ai/Academic%20Program%20Review%20Process%20Policy%20Document.docx?dl=0

Where appropriate, please compare and contrast the data to the last program review data. (https://www.dropbox.com/s/aoo2qskorb113wp/Academic_Program_FinalHRM_Last%20Program%20Review.docx?dl=0).

Statistical Analysis should include appropriate charts, graphs, and tables, along with an explanation of the pertinent findings.

The document should consist of 1500 words that explains the information. Please provide analysis for the following areas

A) Demand Summary

a. Demand Summary

· Summary of the competitive landscape (https://www.dropbox.com/s/u3j74hsi5tgt77j/Academic%20Program%20Environmental%20Scan%20Overview.pdf?dl=0)

· pertinent market and competition data (Use information for US Bureau Labor and Statistics. Regional Competitors: University of Delaware, Goldey-Beacom, Rowan University)- Please research and document for Bachelors of Human Resources programs.

· changes to admissions/advisement process (https://www.dropbox.com/sh/66l6s4s1xou3qxl/AAAD1X6Tqymbl4ISTdsSQRYDa?dl=0)

B) Program and University Graduation Competencies (show in table format if possible)- Please separate out: Bachelors in Science in Human Resources, ICER in Training and Development, and ICER in Human Resources

a. Seat Count Data (https://www.dropbox.com/s/75963rdyyyq5sjl/Seats%20by%20Major%2C%20Term%2C%20and%20Block.xlsx?dl=0)

b. Data relating to enrollment (https://www.dropbox.com/s/x9wzyghj6lp8g8j/10yr%20Enrollment%20Report%20by%20Program.xlsx?dl=0)

c. Data relating to retention (https://www.dropbox.com/s/p3hoga7im6hishx/10yr%20Retention%20Graduation%20Rates%20Report%20by%20Program.xlsx?dl=0)

d. Data relation to graduation rates (https://www.dropbox.com/s/p3hoga7im6hishx/10yr%20Retention%20Graduation%20Rates%20Report%20by%20Program.xlsx?dl=0)

e. Average GPA (Only use course information for HRM course ID) (https://www.dropbox.com/sh/adpmfz7hyoni6ix/AACdG4Ng7oVl4jyqWkYZfKfva?dl=0)

f. Academic Program Planning Internal and External Data by Program Report (https://www.dropbox.com/s/se7oj0k89viupob/Academic%20Program%20Planning%20Internal%20and%20External%20Data%20by%20Program.docx?dl=0)

C) Student reports

a. Summary of Alumni Surveys: “Annual Alumni Survey” (https://www.dropbox.com/s/mj6hjrrwl66rbd5/COB%20-%20FA18_Alumni_Survey.pdf?dl=0)

b. Summary of Student demographics- Please separate out: Bachelors in Science in Human Resources, ICER in Training and Development, and ICER in Human Resources (https://www.dropbox.com/sh/ac4ctwvfq441h2b/AACINDjU8ZiHInNMiFg2G5Iua?dl=0)

i. Demographics by site

ii. Demographics by state of residency

iii. Demographics by gender

iv. Demographics by Ethnicity

v. Demographics by Age

c. Summary of Retention rates (Percentage of Stop-Out)

d. Summary of Graduation rates (Percentage of Graduation Status v. Outcome)

D) Analysis of Key Findings from A, B, C,

E) Summary/Conclusion

F) Appendices