How to duplicate "rmoutliers" function in EXCEL program ?

I want to duplicate "rmoutliers" function in EXCEL program and I do it according to my understanding.

But, the result is different between MATLAB and EXCEL.

Do you fix the procedure or my understanding from attached excel file ?

Thank you.

Answer 1

[Kavya Vuriti]

Hi,

From the excel sheet attached, outliers in the data are 39.29 and 36.00. I think this is correct way to find outliers. The ‘rmoutliers’ function detects and removes outliers from data. The output of this function is the data with outliers removed. From the code provided in excel sheet, B must contain all elements of A excluding 39.29 and 36.00.