I'm working in the environmental research. We are analysing time series of different stations. The dates of different parameters (ex. temperature, ozone) are collected continously every half hour.
Different analyses have to be done with this time series. Just in time I'have to calculate the average every half hour of a day (from 00:30 to 24:00) over a periode from for example the month october 2003.
How can I calculate this with Origin?
Thanks Hanspeter
Lieber Edgar
Ich bin im Umweltschutz tätig. Wir untersuchen dabei Zeitreihen verschiedener Stationen. Die Daten verschiedener Grössen (Bsp. Temperatur, Ozon) werden kontinuierlich jede halbe Stunde erhoben und abgelegt.
Verschiedene Auswertungen müssen aus den Zeitreihen gemacht werden. Insbesonders interessiert mich zur Zeit der mittlere Tagesgang (Mittelwert der Grössen um 0:30; 01:00 ... 24:00) beispielsweise eines Monates.
Frage wie kann ich diese Auswertung mit Origin realisieren?
this can easily be done in Origin and there are of course many possible ways, both, in LabTalk and in OriginC. I will give an example in LabTalk.
Let's assume your data is in the worksheet named timeseries and the resulting semi-hourly averages will be written into a worksheet named averages that is initially empty and contains a row named row1 for the averages of your row1 timeseries. The time-column in your timeseries worksheet must be set to time format.
lastrow = timeseries!wks.maxrows; //determines the number of datalines in your worksheet