what is the average i have data like

1  1.2
1  1.3
1  1.5
3  1.4
3  1.6
3  1.8
3  1.9
4  1.2
4  1.7
4  0.9

and i want average like

1  1.333333333
3  1.675
4  1.266666667

[Alexandra Harkai]

Please explain more what exactly it is you want to compute. Help is more likely if you describe your problem clearly and show what you have tried so far.

[Jan]

@AKHILESH KUMAR: I've formatted the message for you. Please use the "{} Code" button to avoid the standard block format of text in this forum. Thanks.

[AKHILESH KUMAR]

Thank you; it works perfectly but i need explanation. if i have 3 or more column then.

Answer 1

[Mohammad Abouali]

% I assume you have your data in a row
x = [1  1.2 1  1.3 1  1.5 3  1.4 3  1.6 3  1.8 3  1.9 4  1.2 4  1.7 4  0.9];

% change it in two column sets of data as in your image:
x = reshape(x,2,[])';

% get average in each group
avg = grpstats(x(:,2),x(:,1),'mean');

% form the output matrix like in your figure:
results = [unique(x(:,1)), avg]

results =

                           1          1.33333333333333
                           3                     1.675
                           4          1.26666666666667