How can I send the MATLAB data(using loop) to excel???

Hello. I have a touble.

I can send the MATLAB single data to excel. I studied it by this website.

But, if when the data value changes because of the loop statement,

and then how can I accumulate the all data??

For example,

for i = 1:9
    A1 = randi([1 30]);
    A2 = randi([1 30]);
    A3 = randi([1 30]);
    i = i+1
end

According the loop runs, the value of A1, A2, A3 change.

I want to get an excel file like figure below, because I want to conduct sensitivity analysis by using the accumulated data.

If another method to conduct sensitivity analysis by MATLAB,

please, give me some advices.

Answer 1

[Timo Dietz]

rndMatrix = zeros(9, 4);             % preallocation
for i = 1:9
    rndMatrix(i, 1) = i;             % i
    rndMatrix(i, 2) = randi([1 30]); % A1
    rndMatrix(i, 3) = randi([1 30]); % A2
    rndMatrix(i, 4) = randi([1 30]); % A3
end

Now, rndMAtrix contains all data.

[연승 김]

Wow. it works very well!!! Thank you!!