Get startedGet started for free

Outlier detection

It's come to your attention that some of the survey responses in question_1 to question_10 were entered incorrectly. The survey question response options range from 1 to 10, so any value outside of that must be addressed before proceeding to the analysis.

In this exercise, it will be up to you to identify the data entry typos and true outliers (where survey respondents wrote their own value outside the expected range). You will be given instructions on how to handle each.

If you lost any progress, load the 2_4_outlier_detection.xlsx workbook from the Exercises folder and open the Power Query editor.

This exercise is part of the course

Introduction to Power Query in Excel

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise