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,clearfilename = '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;enddisp (columnMeans)columnB = xlsread(filename,'B:B')columnA = xlsread(filename,'A:A')
Best Answer