Irregular (long-)time series is to be interpolated as well mean value and standard deviation to be calculated. How?

Hi all,

I´ve imported data from a .mat file with dates (this format: '2010-02-25 14:49:00', comment:second values are 00 for all dates ) and values (format: 1.23) . Then I converted the date by using datenum() to a number and created a matrix F1 (85888 x 2 double), see below:

734194.617361111 | 0.61

734194.638194445 | 0.57

734194.659027778 | 0.68

. . . .

The Values are from feb 2010 until dec 2015....BUT on irregular time intervalls.

Now I want to

1. interpolate the values so that I have a value for every Minute.

2. cummulate all values to determine the mean values for one single year.

3. calculate the standard deviation over the whole year.

Please assist.

btw: I´m kind a newbee

Answer 1

[sam0037]

Hi Endric,

1. To interpolate the values for every minute you can use the INTERP1 function as explained here .
2. To calculate the mean values for one year use the MEAN function over the corresponding data. Click here to know more about the MEAN function.
3. Similarly use the STD function to compute the standard deviation as explained here .

Thanks, Shamim