Tip #142 - Remove Outlier Values

Remove Outlier Values

Outliers in your data can skew your data analysis and lead to errors in your final analysis. In Dundas BI, there is a quick and simple way to remove outliers so you can focus on the correct data. To remove outliers from your data, use the following formula: OUTIQ.

This function will automatically calculate outliers in a set of inputs using interquartile range computations to eliminate outliers in your charts.

logo

1 Like

Someone - i’m not sure who - also made a great video on the topic if you’re interested in seeing this a different way.

https://www.dundas.com/resources/off-the-charts-tips-from-an-expert/leverage-outlier-analysis-dundas-bi-increase-data-accuracy

1 Like