calculate average column in multiple files

1 vue (au cours des 30 derniers jours)
viet le
viet le le 16 Jan 2019
Modifié(e) : viet le le 17 Jan 2019
I have 10 .xls files (name file1.xls, file2.xls...) in a folder, each has 10 columns (Ai, Bi, Ci,...). Now I want to create one .xls file that calculate average of column A, B, C... (A=A1+A2+...+A10/10); (B=B1+B2+...+B10)......
A1, A2, A3 ... A10 have various length as well as Bi, Ci, Di......
example (attached)

Réponse acceptée

madhan ravi
madhan ravi le 16 Jan 2019
  1 commentaire
viet le
viet le le 16 Jan 2019
Modifié(e) : viet le le 16 Jan 2019
thanks. but I was wondering how to import just one column

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Workspace Variables and MAT Files dans Help Center et File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by