IniziaInizia gratis

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.

Questo esercizio fa parte del corso

Introduction to Power Query in Excel

Visualizza il corso

Esercizio pratico interattivo

Passa dalla teoria alla pratica con uno dei nostri esercizi interattivi

Inizia esercizio