Create matrix and write to excel

Hi everybody! I have the following problem: I nwant to create a matrix that shows the distance between each of these places. The matrix should then be written into a excel document. Somebody who can help me with the code?

Answer 1

[Stalin Samuel]

clear all lt=[57:10:97] lg=[10:10:50] d=zeros(5,5) for i= 1:5 for j=1:5 dlat=lt(j)-lt(i) dlong=lg(j)-lg(i) a = (sin(dlat/2))^2 + cos(lt(i))*cos(lt(j))*(sin(dlong/2))^2; c = 2*atan2(sqrt(a), sqrt(1-a)); R = 6370;

d(i,j) =round( R*c) end end filename = 'test.xlsx'; xlswrite(filename,d)