How do I plot the average and standard deviation of a specific variable of a file within several excel files?

1 次查看（过去 30 天）

显示更早的评论

Jonathan Bijman 2019-5-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/464869-how-do-i-plot-the-average-and-standard-deviation-of-a-specific-variable-of-a-file-within-several-exc

评论： Walter Roberson 2019-6-1

Ejemplo de archivo.png

在 MATLAB Online 中打开

Dear Community

Please help me with guidance.

I have a folder with many excel files and I found a way to load all that files in Matlab and read them.

The point is that, besides to load all these files, now I have to get plots where it shows the average and standard deviation of these measurements.

Inside of each folder, there are 9 measurements, where appears Voc (short circuit voltage), Isc, Pmmp, etc.

The objective is to plot the average of the 9 measurements, with the bars of standard deviation (Only Voc, for instance, that would be on Y axis) along the time (Like day 1, day 2, day 3, etc. on the X axis)

The last thing I couldn´t to make it. Please anyone help me with that, it´s a little complicated.

I send the script that I've made, and a picture of the example of the file.

Thanks a lot!

Voc=Clean(:,5);
tiempo=[]
a=1
t=a+1
t=length(Voc)
for i=1:t
    tiempo=[a,t]
end

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Walter Roberson 2019-6-1

在 MATLAB Online 中打开

Clean = {};

and in the loop,

Clean{k} = num;

After the loop you can process the values read in as needed.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

请先登录，再回答此问题。

类别

MATLAB Graphics 2-D and 3-D Plots Line Plots

在 Help Center 和 File Exchange 中查找有关 Line Plots 的更多信息

产品

MATLAB

Community Treasure Hunt

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

Start Hunting!

Translated by