Addressing outliers in the data

Now that you know how to identify outliers with a dataset, there are times when you would like to address them. This could be for visualization purposes or for helping further analysis (i.e. correlation with other variables). In any case, it's always best practice to log what modifications are performed.

In this exercise, you'll use a nested IF() statement to modified the updated_price variable to address outliers <0.5% or >0.95%.

If you have lost any progress, close any open reports and load 2_3_address_outliers.pbix from the Workbooks folder on the Desktop.