i want to create an excel sheet for A=14/(cos(b))^3,where b varies from 8 to 25(i.e 8,9 ....,25). How to write a programme ?

i want to create an excel sheet for A=14/(cos(b))^3,where b varies from 8 to 25(i.e 8,9 ....,25). How to write a programme ?

[Guillaume]

while it's not hard to do in matlab, it's trivial to do in excel. Since you want the result in excel, why don't you do it directly there?

[Rahil Sonkusare]

i am in learning phase trying to eplore my matlab knowledge , just out of curiosity i am asking question and will be glad to accept answer.

Answer 1

[taher azim]

this will be ur program

function surfer()
m=zeros(18,1)
for b=8:1:25
A=14/(cos(b))^3;
m((b-8)+1,1)=[a];
end
%create a blank excelsheet in ur matlab directory with a proper filename%
filename = 'filename.xlsx';
xlswrite(filename,m);
end

%to design ur output in excel refer to matlab help section and type xlswrite.%

Answer 2

[Guillaume]

Well, if you really want to do it in matlab, the efficient way of doing it is:

b = 8:25;
A = 14/cos(b).^3;
xlswrite('full path to your file.xlsx', [b; A]');  %tranposed b and A so they're written by column

Not using slow loops.