AVG, occurence, vlook up, groups
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Marek Drliciak
el 10 de Nov. de 2022
Movida: Image Analyst
el 21 de Nov. de 2022
Hello,
I would like to ask for help in determining the average of values in specific groups of data in a database. I processed the issue in excel in the attachment. This is a preview.
Thank you
0 comentarios
Respuesta aceptada
Image Analyst
el 10 de Nov. de 2022
Try this:
data = readmatrix('Problem description.xlsx', 'Range', 'b3:c31')
averages = grpstats(data(:, 2), data(:, 1), "mean")
counts = histcounts(data(:, 1))
3 comentarios
Image Analyst
el 11 de Nov. de 2022
Then you need to identify each group in column 1 with a separate ID number which you can do with bwlabel in the Image Processing Toolbox.
data = readmatrix('Problem description.xlsx', 'Range', 'b3:c31')
% Identify separate groups:
[groupIDs, numGroups] = bwlabel(data(:, 1))
averages = grpstats(data(:, 2), groupIDs, "mean")
counts = histcounts(groupIDs)
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!