Question

Peter is a data analyst in a financial firm. He maintains a spreadsheet that contains all employee details. Peter wants to analyze the data of all employees that have experience of more than five years. Which technique can Peter use to perform this analysis?

Answer 1

Answer: filter the data of employees with more than five years of experience

Explanation:

The technique that Peter can use to perform this analysis is to filter the data of employees with more than five years of experience.

Filter in spreadsheets allows one to see the data that is required based on the input that was given. In this case, since Peter wants to analyze the data of all employees that have experience of more than five years, this can be filtered and the employees who have experience of more than 5 years will be shown.

The workers who have experience of less than five years will not b shown in this case.