Mean automation from excel data
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Yogesh T L
am 8 Apr. 2016
Kommentiert: Yogesh T L
am 8 Apr. 2016
Hi, Let's say we have the following data, and I would like to obtain the mean of pressure for speed 20 only. Then I am also interested to obtain mean for speeds 40 only, 60 only... I am using excel for this but matlab would be a better option for automation from my opinion as the data is huge.Thank you.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/160500/image.png)
2 Kommentare
Muhammad Usman Saleem
am 8 Apr. 2016
can you add your sample excel file please? I want to check repeatition
Akzeptierte Antwort
Andrei Bobrov
am 8 Apr. 2016
ps = xlsread('yourdata.xlsx');
[speed,~,c] = unique(ps(:,2));
pressure_mean = accumarray(c,ps(:,1),[],@mean);
out = [pressure_mean, speed];
0 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!