Loop over a list of variables indexed by numbers

Suppose I have a table

              Day1Vistors Day1Sales Day2Visitors Day2Sales
NY            10 100  15  45
SF            5   20  10  50

Then I want to calculate Day1SalesPerVisitor, Day2SalesPerVisitor

I would lke to write a loop over variable names like

for i=1:2
    DayiSalesPerVisitor=DayiSales./DayiVisitor;
end

How can one operationalize it?

Answer 1

[Matt J]

Where your table is T,

for i=1:2
   DaySalesPerVisitor{i}=T{:,2*i}./T{:,2*i-1};
end

Alternatively,

A=table2array(T);
DaySalesPerVisitor=A(:,2:2:end)./A(:,1:2:end);

[alpedhuez]

Wanted more general method to run loop over variable names but this would surely work.