# Integration of time series data

Helo- I have columns of time history data as shown below. How do I do integration of these data and write in a separate column, i. e., in"Integrated values" column? Do I have to use trapizoidal rule, or simpson rule? Any example of MATLAB command or code will help. Thanks.

time Value   Integrated values
0        0.1
0.1     2
0.2     3
0.4     1
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
What method to use for integration is up to you. Trapezoidal integration is build into Matlab. If you imported time as x and Value as y, you can do integration as z=trapz(x,y);
If you also need help to import/output data, please tell more details on your original data format and what you want as output. How large is the dataset? You can also attach an example here.
0
Author Commented:
Thank you. Could you also send me how to import and output data in MATLAB. The database is like I have sent you, but it has 500 rows. I want to plot the time vs. z=trapz(x,y) values. Matlab commands for plotting and import/output data will help the most. Thanks again, - okd
0
Commented:
Here is the code. It read the data from tab-delimited file tsdata.txt and returns 2-column matrix data. To make it clear I put time into time vector and value into value vector (rows 2 and 3). TRAPZ function will return only one value - the total area under the curve for the whole vector. To get integrated value for every time point you can use CUMTRAPZ.
``````% data import
% let's split variables for clarity
time=data(:,1);
value=data(:,2);
% calculating integrated values
intvalue=cumtrapz(time,value);
% plotting
plot(time,intvalue)
``````
0

Experts Exchange Solution brought to you by