Dear Friends,
As an example, I have extracted timelines of 12 completed cases (New Delhi Visa Office) from the 2011 FSWP spreadsheet. Sorted by NOC. Can anyone deduce any information about the way CIC process applications. Do they process in batches as they receive / as per NOC / or by any other significant factors?
Can anyone apply appropriate statistical methods and analyze the data from the spreadsheet? If I do it, I am not sure if I end up correctly. Statistics is not my forte.
You can find the csv data of this excel sheet pasted below.
s15.postimg .org/w3h4w5ap7/Capture.jpg (Paste this address on your browser by removing the space before .org)
DAYS BETWEEN*,,,,,,
NOC,App Received & PER,PR & AOR,AOR & MR,MR & PPR,PPR & VISA,
631,94,25,77,0,34,
631,89,38,18,0,97,
1122,66,20,67,0,112,
1122,82,35,83,0,42,
1122,84,34,95,0,43,
1233,66,26,63,0,71,
2121,89,29,71,0,74,
3112,87,47,28,0,56,
3131,89,28,70,0,50,
3131,92,27,81,0,27,
3131,85,52,31,0,49,
3142,91,24,19,61,61,
,TOTAL NUMBER OF DAYS TOWARDS* ==>,,,,,
NOC,PER,AOR,MR,PPR,VISA,
631,94,119,196,196,230,
631,95,133,151,151,248,
1122,96,116,183,183,295,
1122,97,132,215,215,257,
1122,98,132,227,227,270,
1233,99,125,188,188,259,
2121,100,129,200,200,274,
3112,101,148,176,176,232,
3131,102,130,200,200,250,
3131,103,130,211,211,238,
3131,104,156,187,187,236,
3142,105,129,148,209,270,
,,,,,,
* Extract of 12 completed cases from FSWP 2011 spreadsheet - New Delhi Visa Office (NDVO),,,,,,