Questions
1. Calculate the total Monthly Salary for all employees.
2. Calculate the average Annual Salary for all employees.
3. Calculate the total number of employees in each Department.
4. Calculate the total Monthly Salary for employees in the Sales Department.
5. Calculate the total Annual Salary for employees in the Sales Department.
6. Calculate the total number of Male and Female employees.
7. Calculate the total Monthly Salary for Male employees.
8. Calculate the total Annual Salary for Female employees.
9. Calculate the total number of employees in each Country.
10. Calculate the total Monthly Salary for employees in the United Arab Emirates.
11. Calculate the total Annual Salary for employees in Egypt.
12. Remove leading and trailing spaces from the First Name and Last Name columns.
13. Standardize the text case for the Department column (e.g., convert to title case).
14. Replace any missing values or placeholders in the data with appropriate values.
15. How many employees have more than 5 years of experience?
16. Calculate the total overtime hours worked by employees in the Quality Control department.
17. Find the employee with the highest annual salary.
18. Clean the text data in the Gender column to ensure consistency (e.g., convert "Male" and "M" to
"Male," and "Female" and "F" to "Female").
19. Find the top 5% of employees with the highest monthly salary.
20. Calculate the correlation between the number of years of experience and the annual salary for
all employees.(search for it!).