Mean automation from excel data

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.

[Muhammad Usman Saleem]

can you add your sample excel file please? I want to check repeatition

[Yogesh T L]

I am not able to understand what you mean by repetition because it varies each time I conduct the experiment. It's a big spreadsheet in excel and I am not willing to share the entire experimental data. Please don't hesitate to request for further details.

Answer 1

[Andrei Bobrov]

ps = xlsread('yourdata.xlsx');
[speed,~,c] = unique(ps(:,2));
pressure_mean = accumarray(c,ps(:,1),[],@mean);
out = [pressure_mean, speed];