Azzera filtri
Azzera filtri

Info

Questa domanda è chiusa. Riaprila per modificarla o per rispondere.

Reading in the values from excel

1 visualizzazione (ultimi 30 giorni)
soyfrijole
soyfrijole il 5 Dic 2017
Chiuso: MATLAB Answer Bot il 20 Ago 2021
I have made a program the reads in values from an excel table and in order to find the average of n number of values in a column. The problem that I am having is I only know how to find the average of all the values in a column, not just the first 10 values in the column. If someone could help I'd appreciate it.
if true
if y == 0.2
column = 3;
x = mean(data_in(:,3));
s = std(data_in(:,3));
end

Risposte (1)

KL
KL il 5 Dic 2017
replace
x = mean(data_in(:,3));
with
x = mean(data_in(1:10,3));
1:10 could be any number indices within its limits
  2 Commenti
soyfrijole
soyfrijole il 5 Dic 2017
Oh thank you. I was trying to do (n,3) and kept getting an error.
KL
KL il 6 Dic 2017
Modificato: KL il 6 Dic 2017
n should be a vector, like in my example,
n = 1:10
if they are not continuous then,
n = [1 3 8 9 15 ...]

Questa domanda è chiusa.

Community Treasure Hunt

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

Start Hunting!

Translated by