CREATE HISTOGRAMM WITH A SPECIFIC NUMBER OF CLUSTERS IN X AXIS

1 次查看（过去 30 天）
Ivan Mich
Ivan Mich 2020-10-27
评论： Sindar 2020-10-28
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.

请先登录，再回答此问题。

回答（1 个）

Sindar
Sindar 2020-10-27
histogram:
x = randn(1000,1);
nbins = 5;
h = histogram(x,nbins)
  2 个评论
Ivan Mich
Ivan Mich 2020-10-28
编辑：Ivan Mich 2020-10-28
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 2020-10-28
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)

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Histograms 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by