Plot the data using charts or graphs to visually inspect the data distribution. If you divide your data into quarters, each of those sets is called a quartile. Web use excel's descriptive statistics tools to analyze the distribution of the data. Web find outliers by sorting the data. Make sure the outlier is not the result of a data entry error. In the editing group, click on the sort & filter icon. Calculate lower bound by multiplying iqr. Web how to handle outliers. Look for data points that deviate significantly from the. The lowest 25% of numbers in the.
Web how to find outliers in your data. Select the column header of the column you want to sort (cell b1 in this example) click the home tab. If you divide your data into quarters, each of those sets is called a quartile. Web how to find outliers in your data. Web find outliers by sorting the data. Plot the data using charts or graphs to visually inspect the data distribution. Calculate q1 and q3 using the quartile function for your data. In the editing group, click on the sort & filter icon. Calculate lower bound by multiplying iqr. Calculate iqr by subtracting q1 from q3. Look for data points that deviate significantly from the.
