This question is closed. Reopen it to edit or answer.

How to duplicate "rmoutliers" function in EXCEL program ?

1 view (last 30 days)
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.

Answers (1)

Kavya Vuriti
Kavya Vuriti on 27 Nov 2019
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.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by