How can I load lots of files with a for loop and then multiply them by a vector

Hello all,

I've got three .mat files each with size 100x1

variable1_data.mat

variable2_data.mat

variable3_data.mat

I also have those files in an xlsx format

(variable1_data.xlsx, variable2_data.xlsx, variable3_dta.xlsx)

********************************

I want

1. to load them simultaneously with a for loop into my code and

2. to multiply them with a known vector called fr

***********************************

My code until now is:

N=3

for i=1:N

fr = fraction(:,1)/sum(fractions(:,1:N),2) % where fractions is a 100x 3 matrix

for j=1:100

??????? unknown part

end

end

***********************************

At the end I'd like to have a matrix called variable with size 100x1

Any ideas on that?

Many thanks!

Answer 1

[Dasharath Gulvady]

Assuming that all the MAT files have same data(let's say "mydata"):

N=3
for i=1:N
   toLoad = sprintf('variable%d_data.mat',i);
   load(toLoad);
   fr*mydata
end

If this does not answer your question, explain what exactly you are looking for

[Christina]

Thank you for your response.

Actually, this not not exactly what I'm looking for, because my fr changes as well within the for loop, but it's close to what I was looking for.