CREATE HISTOGRAMM WITH A SPECIFIC NUMBER OF CLUSTERS IN X AXIS

2 Ansichten (letzte 30 Tage)
Ivan Mich
Ivan Mich am 27 Okt. 2020
Kommentiert: Sindar am 28 Okt. 2020
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.

Antworten (1)

Sindar
Sindar am 27 Okt. 2020
x = randn(1000,1);
nbins = 5;
h = histogram(x,nbins)
  2 Kommentare
Ivan Mich
Ivan Mich am 28 Okt. 2020
Bearbeitet: Ivan Mich am 28 Okt. 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 am 28 Okt. 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)

Melden Sie sich an, um zu kommentieren.

Community Treasure Hunt

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

Start Hunting!

Translated by