My Greetings ....
My new request is;
To calculate the moving correlation between the data in column B which is symboled by S-DJFM and the data in column C which is symboled by N-DJFM with a 11-year window and it should be shown together with the 95% significance level, this procedure it should be applied on each Excel file whereas the total no, of file is 73 Excel files.
Note; the column A just the year or span for the data please don't involved in the calculations
Clarification; The moving correlation technique identified as follow;-
Example; if the total data for each column is 1000 numbers and for a 11-years window .Using moving correlation technique for each 11 numbers .The computer would compute a correlation between column B and column C for numbers 1-11 ,then for numbers 2-12,then for 3-13,then 4-14 ....... etc ,through 990-1000 .Theresult would be a continuous values of correlation coefficients.
Please, find attached the Zip.file of the total files -73 ,check these files and replied to me the cheep cost and the exact time for receiving the result
Thank you very much for you