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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
