LoslegenKostenlos loslegen

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

Kurs anzeigen

Interaktive Übung

In dieser interaktiven Übung kannst du die Theorie in die Praxis umsetzen.

Übung starten