How to make a scatter table programmatically?

There's no x value smaller than 0.5 in your inputs so it's unclear why you have a 10 in your first row of your table. I'm going to assume that your table is incorrect. There are more inconsistencies.

Your bin edges are also badly defined. What happens if x is 0.55, it's outside any of your bins. Same for y = 10.5. Normally you would define the end of bin 1 as x<0.5 and the start of bin2 as x>=0.5 (or x<=0.5 and x>0.5).

So, ignoring all these inconsistencies, use histcouns2 to compute the histogram:

xy = xlsread('Scatter table.xlsx', '3:4');
histcounts2(x(1, :), y(2, :), [0 0.5 1.0 1.5 Inf], [0 5 10 15 Inf], 'Normalization', 'probability') * 100

4 个评论
显示 2更早的评论隐藏 2更早的评论

Guillaume 2018-12-20

在 MATLAB Online 中打开

Here is a cheap replacement of histcounts2 with the 'probability' normalisation:

xy = xlsread('Scatter table.xlsx', '3:4');  %or however you want to import the data
xbin = discretize(xy(1, :), [0, 0.5, 1, 1.5, Inf]);  %or whichever bins you want for x
ybin = discretize(xy(2, :), [0, 5, 10, 15, Inf]);  %or whichever bins you want for y
accumarray([xbin(:), ybin(:)], 1) / numel(xbin) * 100