I want to create a 7-day rolling mean for a daily physical training load over a year calculated for each athlete in a training group. The data set is called 'daily.load'. The vectors are: 'Date', 'Name', 'Total.Load' The ideal end result would be a rolling 7-day mean for 'Total.Load' as...

I have a query that does a basic moving average using the FOLLOWING / PRECEDING syntax of PostgreSQL 9.0. To my horror I discovered our pg server runs on 8.4 and there is no scope to get an upgrade in the near future. I am therefore looking for the simplest...

I have a time series of regular 15 minute data intervals and I want to take a rolling average of the data for every 2 hours, hence the width of the rollmean interval would be 8. The only issue is that the length of the original time series that I...

I have an Array of X Integer values in VHDL declared as a variable inside a process. I would like to calculate the average of all Values in a for loop. If I write it out for 3 Values manually everything works fine (tested on hardware): entity MyEntity is Port(...

I come up with this n=1; curAvg = 0; loop{ curAvg = curAvg + (newNum - curAvg)/n; n++; } I think highlights of this way are: - It avoids big numbers (and possible overflow if you would sum and then divide) - you save one register (not need to store...

zoo::rollmean is a helpful function that returns the rolling mean of a time series; for vector x of length n and window size k it returns the vector c(mean(x[1:k]), mean(x[2:(k+1)]), ..., mean(x[(n-k+1):n])). I noticed that it seemed to be running slowly for some code I was developing, so I wrote...

I want a function that works. I believe my logic is correct, thus my (vector out of range error) must be coming from the lack of familiarity and using the code correctly. I do know that there is long code out there for this fairly simple algorithm. Please help...

fname = file.choose() two = read.csv(fname.header=T) rec = two$Receipt del = two$Delivery date = two$Date net = rec-del yrec = matrix(rec,nrow=365,ncol=4,byrow=F) ydel = matrix(del,nrow=365,ncol=4,byrow=F) ynet = matrix(net,nrow=365,ncol=4,byrow=F) yrecsum = 0 yrecavg = 0 for(i in 1:4) { for(j in 1:365) { yrecsum[i] = yrecsum[i]+yrec[j,i] } yrecavg[i] = yrecsum[i]/365 } So...

I have an array of daily closing prices for a stock (historical data) formatted as such: var close = [39, 40.133, 38.23, .... , 45.38] these are in order chronologically by date. I am trying to make an array of EMA (exponential moving average) values of the closing price to...