How to integrate for a data set ?

Question

Manish Kumar 2019-3-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/448822-how-to-integrate-for-a-data-set

评论： A K M Kamrul Hasan 2020-8-29

solar_spectrum.xlsx

Dear All,

I want to integrate the following equation

I have the data set of P(hw) and hw. I want to input the value E_g. Data set is given in the excel sheet

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Star Strider 2019-3-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/448822-how-to-integrate-for-a-data-set#answer_364299

在 MATLAB Online 中打开

I have no idea what you are doing.

Try this:

filename = 'solar_spectrum.xlsx';
[D,S,R] = xlsread(filename);
Phw = D(:,1);
hw = D(:,2);
E_g = hw >= 0.5;                                             % Logical Index — Choose ‘E_g’ (Here: 0.5)
S = trapz(hw(E_g), Phw(E_g))
figure
plot(hw, Phw)
hold on
patch([hw(E_g) fliplr(hw(E_g))], [Phw(E_g) fliplr(Phw(E_g))], 'y')
hold off
grid