CREATE HISTOGRAMM WITH A SPECIFIC NUMBER OF CLUSTERS IN X AXIS

2 views (last 30 days)
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.

Answers (1)

Sindar
Sindar on 27 Oct 2020
x = randn(1000,1);
nbins = 5;
h = histogram(x,nbins)
  2 Comments
Ivan Mich
Ivan Mich on 28 Oct 2020
Edited: Ivan Mich on 28 Oct 2020
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
Sindar on 28 Oct 2020
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)

Sign in to comment.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!