Info
Diese Frage ist geschlossen. Öffnen Sie sie erneut, um sie zu bearbeiten oder zu beantworten.
Average from a excel sheet and store it to a different excel sheet.
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
I have a matrix file which consists of 2560 rows and 39 columns. In that file A3 and B3 consist of X and Y coordinate. C3 is time. Now i need to do average from D3 to G32 (it's like a 30X4 matrix). Now save the average value in a different excel sheet in this fashion like, in the new excel sheet A3 and B3 consist of that previous X and Y coordinate and C3 consist of the average value. Then i have to do average from H3:K32 and then save it under the same coordinate and beside the previous value, that means in D3.
Can anyone tell me how to do that?
0 Kommentare
Antworten (1)
Abdolkarim Mohammadi
am 9 Aug. 2020
You should first read the data from the excel file using readmatrix, then do any calculations like mean, and finally write to the excel file using writematrix. For example:
MatrixInMatlab = readmatrix ('data.xlsx', 'Sheet','MySheet1', 'DataRange','A1:B10');
MeanInMatlab = mean (MatrixInMatlab, 2);
writematrix (MeanInMatlab, 'Sheet','MySheet2', 'DataRange','C1');
0 Kommentare
Diese Frage ist geschlossen.
Siehe auch
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!