Need help in average velocity (Si-Sf)/(Ti-Tf) code. without using in built functions
古いコメントを表示
I need help in this problem. This is the first time using A programming software and its a challenge. given a set of data on excel in two columns, time and distance, they are not sorted and have 4000 rows. The program needs to just calculate the average velocity (Si-Sf/Ti-Tf) from the excel columns and give one final answer and display it. Thank You in advance.
Here is a what i did, although it's not correct and i don't know how to proceed.
clc,clear
filename = 'LoopingData.xlsx';
[rows, columns] = size(filename);
for col = 1 : columns
theSum = 0;
for row = 1 : rows
theSum = theSum + filename(row, col);
end
% Now get the mean over all values in this column.
columnMeans(col) = theSum / rows;
end
disp (columnMeans)
columnB = xlsread(filename,'B:B')
columnA = xlsread(filename,'A:A')
採用された回答
その他の回答 (1 件)
カテゴリ
ヘルプ センター および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!