How to duplicate "rmoutliers" function in EXCEL program ?

Question

SEONG-BAE JO 2019-11-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/492319-how-to-duplicate-rmoutliers-function-in-excel-program

关闭： MATLAB Answer Bot 2021-8-20

outlier.xlsx

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

此问题已关闭。

Answer 1

Kavya Vuriti 2019-11-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/492319-how-to-duplicate-rmoutliers-function-in-excel-program#answer_403565

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.