Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

APPENDIX 1 - DATA DICTIONARY Variable ID Description Staff Identifier Staff Birth Year Gender Marital Citizenship Minority JoinDate LeftDate Unit Salary PerformanceScore Survey Satisfaction

image text in transcribedimage text in transcribedimage text in transcribed

APPENDIX 1 - DATA DICTIONARY Variable ID Description Staff Identifier Staff Birth Year Gender Marital Citizenship Minority JoinDate LeftDate Unit Salary PerformanceScore Survey Satisfaction Absence Name of Staff Year of Birth Gender (F:Female, M:Male) Marital status Citizenship status Racial/Ethnic Minority Staff's organization join date Staff's organization left date Business Unit Salary Performance Score (PIP: Performance Improvement Plan) Engagement survey results (Scale of 1 to 5) Satisfaction Score (Scale of 1 to 5) Number of days of absence in the previous year Question 1 The given dataset comprises 250 staff information records in an organization. The data dictionary of this dataset is depicted in Appendix 1. Part (a) is to be answered using MS Excel. Use Python and any related libraries for answering Parts (b) to (d). The Python codes are to be expressed in text format and must be included, with the correct indentation(s), in the answers of Parts (b) to (d), in the report. Screenshots of the codes are not permitted and will not be marked.. The corresponding Jupyter notebook must also be submitted. (a) (b) (c) Analyse the given data, and provide two (2) charts and corresponding summarised tables, using MS Excel. Describe the insights obtained from this analysis. (30 marks) Read the data and create the same two (2) charts and their corresponding summarised tables produced in Part (a), using Python. (40 marks) Find the length of service of all the staff, using Python. For staff who has not left the organization, use 1st May 2022 as the LeftDate. State the minimum, maximum and average length of service, expressing in years, rounded to 1 decimal place. (1 year is taken as 365 days.) (15 marks) ANL252 Tutor-Marked Assignment (d) Develop an interactive user input which allows the user to query if a particular person was/is a staff of the organization. One can assume the full name is entered by the user. The output should print the answer to the user's question if that person can be found in the organization's records. The interactive user input should also allow the user to continue to make another query, till the user chooses otherwise. (15 marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction to Wireless and Mobile Systems

Authors: Dharma P. Agrawal, Qing An Zeng

4th edition

1305087135, 978-1305087132, 9781305259621, 1305259629, 9781305537910 , 978-130508713

More Books

Students also viewed these Programming questions

Question

Analyze the conic. 25x 2 + 9y 2 250x + 400 = 0

Answered: 1 week ago