Remove cells in table if a specific value is an outlier

1 view (last 30 days)
AU
AU on 31 May 2019
Edited: AU on 31 May 2019
I want to remove the complete rows of a table if the outlier in the second column which is named 'Close' is an Outlier. I used the following code but no outliers have been removed from the table.
MovingAverage = movmean(NoMV.Close,30)
threshold = 3 * std(MovingAverage);
lowerC = NoMV.Close - threshold;
upperC = NoMV.Close + threshold;
NoMV(NoMV.Close(:)<lowerC, :)=[]
NoMV(NoMV.Close(:)>upperC,:)=[]

Sign in to answer this question.

Answers (0)

Categories

Find more on Statistics and Machine Learning Toolbox in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!