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.
Diese Übung ist Teil des Kurses
Introduction to Power Query in Excel
Interaktive Übung
In dieser interaktiven Übung kannst du die Theorie in die Praxis umsetzen.
