AVG, occurence, vlook up, groups
2 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Image Analyst
2022-11-10
Try this:
data = readmatrix('Problem description.xlsx', 'Range', 'b3:c31')
averages = grpstats(data(:, 2), data(:, 1), "mean")
counts = histcounts(data(:, 1))
3 个评论
Image Analyst
2022-11-11
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)
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!