MATLAB: How to form a matrix as our requirements?????

matrix arraymatrix manipulation

Hello

I wanna create a matrix as size is 50rows 6 columns.The sum of each row is 100. the value limits is 0 to 100 its may be float value .For example of one row is

[20 40 10 5 5 20]

Best Answer

x = rand(50, 6);
x = x./sum(x,2)*100;

Result

>> sum(x,2)
ans =
  100.0000
  100.0000
  100.0000
  ..
  ..
  ..
  100.0000
  100.0000

Related Solutions

MATLAB: Combination of rows of two different matrices

Feels non-ideal. Any better solution?

>> C=A(:,1)+B(:,1)';
D=A(:,2)+B(:,2)';
reshape([C(:),D(:)],[],2)
ans =
   -1.0000   -1.0000
  -60.4000    1.2000
    5.6000  -20.8000
  -40.6000    7.8000
 -100.0000   10.0000
  -34.0000  -12.0000
    3.4000  -80.2000
  -56.0000  -78.0000
   10.0000 -100.0000

better one

>> m=size(A,1);
ind1=repmat(1:m,1,m);
ind2=repelem(1:m,m);
A(ind1,:)+B(ind2,:)
ans =
   -1.0000   -1.0000
  -60.4000    1.2000
    5.6000  -20.8000
  -40.6000    7.8000
 -100.0000   10.0000
  -34.0000  -12.0000
    3.4000  -80.2000
  -56.0000  -78.0000
   10.0000 -100.0000

MATLAB: How to display averages in new array

OK, I changed it from a cell array to a double array like you wanted:

B=[100.0000  100.0000  100.0000  100.0000  100.0000  100.0000  100.0000  100.0000  100.0000  100.0000  100.0000  100.0000  100.0000  100.0000  100.0000  100.000;
  90.0000   90.0000   90.0000   90.0000  110.0000   90.0000   90.0000   90.0000  110.0000  110.0000  110.0000  110.0000  110.0000  110.0000  110.0000  110.000;
  81.0000   81.0000   81.0000   99.0000   99.0000   81.0000   99.0000   99.0000   99.0000   99.0000  121.0000  121.0000  121.0000  121.0000  121.0000  121.000;
  72.9000   72.9000   89.1000   89.1000   89.1000   89.1000   89.1000  108.9000   89.1000  108.9000  108.9000  108.9000  133.1000  133.1000  108.9000  133.100;
  65.6100   80.1900   80.1900   80.1900   80.1900   98.0100   98.0100   98.0100   98.0100   98.0100   98.0100  119.7900  119.7900  119.7900  119.7900  146.410]
% Extract the last row.
lastRow = B(end, :)
[rows, columns] = size(B)
% Get unique prices in the last row, for example [65.61, 80.19, 98.01]
pricesToSearchFor = unique(lastRow)
for k = 1 : length(pricesToSearchFor)
  thisPrice = pricesToSearchFor(k);
  fprintf('Searching all columns for price $%.2f.\n', thisPrice);
  % Search every column for this unique price.
  columnCounter = 1;
  for column = 1 : columns
    thisColumn = B(:, column);
    % Find out if this price occurs EXACTLY in the column
    lastIndexInColumn = find(thisColumn == thisPrice, 1, 'last');
    if ~isempty(lastIndexInColumn)
      fprintf('Found %.2f at row %d of column %d of B.\n', ...
        thisPrice, lastIndexInColumn, column);
      % If we found the price in this column, add it to a new column of A
      A(k, columnCounter) = mean(thisColumn(1:lastIndexInColumn));
      % Increment the column in A
      columnCounter = columnCounter + 1;
    end
  end
end
A

What it shows is:

A =
       81.902            0            0            0            0            0
       84.818       88.058       91.658       95.658            0            0
       91.622       95.222       99.182       99.222       103.18       107.58
       111.94       116.78       116.78       111.94            0            0
        122.1            0            0            0            0            0

Is this what you want?

Best Answer

Related Solutions

MATLAB: Combination of rows of two different matrices

MATLAB: How to display averages in new array

Related Question