CREATE HISTOGRAMM WITH A SPECIFIC NUMBER OF CLUSTERS IN X AXIS

Hello,

I have a question about a code. I would like to create a histogramm with a specific number of clusters. For example I would like to create 5 clusters and based on this to create a histogramm with my data. I am uploading an .xlsx file. In first column (x axis data) I have dates and in second column I have results/numbers (y axis data). I would like from the data in first column to grouped in 5 clusters and finally to create a Histogramm.

Could you help me?

Thank you in advance.

Answer 1

[Sindar]

histogram:

x = randn(1000,1);
nbins = 5;
h = histogram(x,nbins)

[Ivan Mich]

ok, but the main problem is that I want specific values to be expressed via the histogram. I want a code:

1) Group my data in 1st column (5 clusters)

2) sum up for all the years my data in 2st column

3) make a histogram , ix axis my grouped data in first column, and in y axis the number of the sum of each group data (frequency I mean).

Could you help me ?

Thank you in advance

[Sindar]

sounds like groupsummary is what you want. There's an example at that link for specifying grouping bins. It's easiest if your data is in a table (so, readtable from the xlsx file)