A data analyst is performing data cleaning on an Excel spreadsheet that contains collected data. Which Excel function would the analyst use to find integer data that is larger than expected?
- MIN
- MAX
- Trim
- Sort
Answers Explanation & Hints:
The Excel function that could be used to find integer data that is larger than expected is MAX. The MAX function returns the highest value in a range of cells or an array, and can be used to identify outliers or unexpected values in a data set. In this case, the data analyst would use the MAX function to identify the largest integer value in the column of data and compare it to the expected range of values. If the largest value is larger than expected, it may indicate an error or outlier that needs to be investigated further. |