Problem with loop to construct graph

Currently I am working on constructing a bar graph for my data (file as attached). But I encountered some problem while trying to rearrange the the data into specific categories. I would like to plot one figure for each position, which means
for Figure 1 ( x position), there will be 3 categories a) x <0.3 cm b) 0.3 cm<x<0.5 cm c) x >0.5 cm
and classify all the data in the column max-x (excel file as attached, sheet name : Book1) into these 3 categories. I already tried using hist and binranges command but it does not work.

2 件のコメント

Mostafa
Mostafa 2016 年 10 月 26 日
編集済み: Mostafa 2016 年 10 月 26 日
Can you please clarify what you want to do exactly? Do you want to draw a bar chart for the number of points according to the given criteria? For example something like this:
|
|
| |
  | |
  x<0.3   0.3<x<0.5   x>0.5
Or what exactly?
Nada Zamri
Nada Zamri 2016 年 10 月 26 日
yes exactly like that.

サインインしてコメントする。

 採用された回答

Mostafa
Mostafa 2016 年 10 月 27 日
編集済み: Mostafa 2016 年 10 月 27 日

0 投票

%Reading the data from sheet 1, cells B2 to D8
dataMat = xlsread('Book1.xlsx', 1, 'B2:D8', 'basic');
%Get sum of numbers that satisfy the conditions for x-column
x1 = sum(dataMat(:, 1) < 0.3);
x2 = sum((dataMat(:, 1) > 0.3) & (dataMat(:, 1) < 0.5));
x3 = sum(dataMat(:, 1) > 0.5);
%Draw, bar width = 0.5 for readability
bar([x1 x2 x3], 0.5);
%Rename x-axis to be more meaningful
set(gca,'XTickLabel',{'x < 0.3', '0.3 < x < 0.5', 'x > 0.5'});

その他の回答 (0 件)

カテゴリ

ヘルプ センター および File ExchangeApp Building についてさらに検索

質問済み:

2016 年 10 月 26 日

編集済み:

2016 年 10 月 27 日

Community Treasure Hunt

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

Start Hunting!

Translated by