I have a daily time series in excel with 5 columns:
day, variable1, variable2, variable3
I simply want you to convert it to a monthly time series:
One, as the sum of the data in each month and another one as the average of the data in each month.
You have to do it in the next couple of minutes. Thanks.