MATLAB Answers

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

4 views (last 30 days)
Endric Schenk
Endric Schenk on 11 Feb 2016
Answered: sam0037 on 15 Feb 2016
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

  0 Comments

Sign in to comment.

Answers (1)

sam0037
sam0037 on 15 Feb 2016
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

  0 Comments

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!