hi, I want to split my data set into different series lets say its from 2.0 to 2.99 I want to make intervals like 2.00 - 2.199, 2.2-2299, 2.3-2.3999 and then would like to to count the number of values for each interval.

hi, I want to split my data set into different series lets say its from 2.0 to 2.99 I want to make intervals like 2.00 - 2.199, 2.2-2299, 2.3-2.3999 and then would like to to count the number of values for each interval.

Next would be to write a loop to measure the value Cumulative Total Above Lower value in Ranges

Please help

Answer 1

[Star Strider]

It is called a histogram count. There are several MATLAB functions that can do the counting with your data and your bin ranges as input. The histc function is closest to what you want to do.

I have no idea what you mean by ‘measure the value Cumulative Total Above Lower value in Ranges’, so please describe what you want to do in a bit more detail.

[amberly hadden]

Parameter        range          Frequency     Cumulative Total Above Lower value
2.745           2.1-2.199       (so number of data set above 2.1)
2.422           2.2-2.299
2.876           2.3-2.399
2.477           2.4-2.499
2.440     2.5-2.599
2.674    2.6-2.699
2.600    2.7-2.799
2.450     2.8-2.899
2.630   2.9-2.999
2.439  
2.432  
2.483

[amberly hadden]

Plese let me know if you cannot read data set I can attach a sample file

[Star Strider]

I still don’t understand. If you want the cumulative total above 2.745, you can do something like this:

Data = rand(1,50)*3;                        % Create test data
LowerValue = 2.745;                         % Define ‘Lower Value’
DataExtract = Data(Data > LowerValue);      % Find Data above ‘Lower Value’
SumAboveLowerValue = sum(DataExtract);      % Calculate the sum

[amberly hadden]

Attach is what I need to compile in a program.

[Star Strider]

Here you go:

Mw_Calculated = [2.745  2.422  2.876  2.477  2.440  2.674  2.600  2.450  2.630  2.439  2.432  2.483  2.652  2.255  2.448  2.441  2.447  2.537  2.440  2.671  2.502  2.421  2.438  2.582  2.943  2.387  2.221  2.243  2.214  2.187  2.242  2.426  2.385  2.260  2.647  2.595  2.219  2.471  2.495  2.256  2.133  2.225  2.215];
Mag_Range = [2.1 2.2 2.3 2.4 2.5 2.6 2.7 2.8 2.9 2.999];
Count_Per_M_Range = histc(Mw_Calculated, Mag_Range);
Cumulative_Total_Above_Lower_M_in_Range = cumsum(fliplr(Count_Per_M_Range));
CumulativeData = [Mag_Range'  Count_Per_M_Range'  fliplr(Cumulative_Total_Above_Lower_M_in_Range)'];
fprintf(1,'\n\tMag Range\tCount Per M Range\tCumulative Total Above Lower M in Range\n')
fprintf(1,'\t\t%.3f\t\t\t%2d\t\t\t\t\t%2d\n', CumulativeData')

produces:

  Mag Range  Count Per M Range  Cumulative Total Above Lower M in Range
  2.100       2      43
  2.200      10      41
  2.300       2      31
  2.400      16      29
  2.500       4      13
  2.600       6       9
  2.700       1       3
  2.800       1       2
  2.900       1       1
  2.999       0       0

[amberly hadden]

this is it .... Thanks a lote

[Star Strider]

My pleasure!

Answer 2

[Image Analyst]

Try this:

values = [...
2.745   
2.422  
2.876  
2.477   
2.440  
2.674
2.600 
2.450 
2.630 
2.439  
2.432  
2.483]
edges = 2 : 0.1 : 3
counts = histc(values, edges)
cdf = cumsum(counts)'
backwardsCDF = fliplr(cdf)