timeseries

I have a time series data regarding power consumed at a phone charging station with columns named: date, user id, and power consumed. I am trying to perform a statistical analysis to figure out the following: 1. how many people used the station? I have done this one by counting the number of...

VBA plot a Scatter graph data - X and Y axis data taken from sheet row by row The data is time series data thus each row of X and Y data must be plotted from the respective worksheet row (20 columns of data) This needs to be automated via VBA to accept the data row by row - wish to expand...

Hello all, I’m a new noob to the forum, would appreciate if anybody could provide some help. I have 5 sets of columns, each includes a Time column and a Price column. However, the 5 individual Time columns of the 5 sets don’t match, i.e, the dates are not continuous (there are...

Hi there, I have a number of timeseries (stock prices closing prices) which have different date ranges due to the fact that exchanges are on holidays at different times. I need to figure out a way to quickly "match" these timeseries so that the dates and line up with each other. I would...