How to detect and remove outliers in excel data using matlab
11 views (last 30 days)
Show older comments
Hi
I am working on validation of direct normal irradiance (DNI) data. i have ground data for 2 years and I want to detect and remove outliers from the data (values beyond three standard deviations around the mean). data is in excel and is at ten minutes interval. Moreover, data in excel has various columns and I am only concerned with time column and DNI (4 column in screenshot). I need to know how can i do this using matlab. Any help will be highly appreciated. screenshot of data in excel is attached.
0 Comments
Answers (1)
Davide Masiello
on 3 Mar 2022
I'd try something like this
clear, clc
T = readtable('excelfilename.xlsx');
time = T.time(T.dni > mean(T.dni)-3*std(T.dni) & T.dni < mean(T.dni)+3*std(T.dni));
DNI = T.dni(T.dni > mean(T.dni)-3*std(T.dni) & T.dni < mean(T.dni)+3*std(T.dni));
0 Comments
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!