ASSIGNMENT

You are a manager in a large information systems consulting company, managing $10$ employees in Reno, who each worked $50$ weeks, $40$ hours per week, $($or a total of $2000$ hours$)$ in $2023.$ You want to better understand how your employees spent their time in the calendar year $1/1/23-12/31/23.$ Specifically, you want to be able to calculate the following:

how many hours each employee spent on a series of $3$ special projects during $2023.$

what percentage of hours worked on special projects vs total hours worked in $2023$ for each employee

how many years they have worked for the company

You request a report from the Project Management Office, which keeps track of employee information and hour worked. You immediately receive back the following spreadsheet:

Your job is to review the report and determine how good the data is$.$

Please do the following for this assignment:

Identify ALL potentially questionable data in the table, and indicate exactly what it is about the piece of data that is questionable $.$ Be as SPECIFIC as possible. Here is an example:

Instead of saying "some data seems wrong", you might say "the value $"941310"$ is listed as a zip code, but zip codes consist of $5$ digits, whereas this value has $6$ digits.

For each data integrity characteristics $($accuracy$,$ timeliness, relevance, sufficient, worth it$)$ describe whether the data in the table satisfies that data integrity characteristic. In your assessment of the characteristics, indicate if there are any desired calculations that you will not be able to perform because of the state of the data, and explain why.