CQ WW Data Analysis

From Stan EI6DX ; 

Just for a bit of fun, I have put aggregated CQWW log data into an Excel file and pointed pivot tables to it.

Below are some graphs and insights into CQWW QSO rates from 2007 to 2014 by area, bands and modes.

Total QSOs (CW and SSB): http://www.ei6dx.com/wordpress/galleries/report/2014/01.png

Note: Some DX zones have been omitted. It was done intentionally so as to not to skew area figures by including once-off DX-peditions.

Total QSOs (breakdown by mode): http://www.ei6dx.com/wordpress/galleries/report/2014/02.png
Total QSOs (breakdown by band): http://www.ei6dx.com/wordpress/galleries/report/2014/04.png
Total QSOs compared to 2007: http://www.ei6dx.com/wordpress/galleries/report/2014/05.png
Total QSOs compared to 2007 (breakdown by mode): http://www.ei6dx.com/wordpress/galleries/report/2014/06.png
Total QSOs compared to 2007 (breakdown by band): http://www.ei6dx.com/wordpress/galleries/report/2014/07.png
Total QSOs compared to previous year: http://www.ei6dx.com/wordpress/galleries/report/2014/08.png
Total QSOs compared to previous year (breakdown by band): http://www.ei6dx.com/wordpress/galleries/report/2014/09.png
Total QSOs compared to previous year (breakdown by mode): http://www.ei6dx.com/wordpress/galleries/report/2014/10.png

Breakdowns by area (USA, EU, JA, SA, VK, Balkans, RU).
Total QSOs compared to previous year (breakdown by area): http://www.ei6dx.com/wordpress/galleries/report/2014/11.png
Total QSOs compared to 2007 (breakdown by area): http://www.ei6dx.com/wordpress/galleries/report/2014/12.png
Total QSOs compared to 2007 by area - 160 only: http://www.ei6dx.com/wordpress/galleries/report/2014/13.png
Total QSOs compared to 2007 by area - 80 only: http://www.ei6dx.com/wordpress/galleries/report/2014/14.png
Total QSOs compared to 2007 by area - 40 only: http://www.ei6dx.com/wordpress/galleries/report/2014/15.png
Total QSOs compared to 2007 by area - 20 only: http://www.ei6dx.com/wordpress/galleries/report/2014/16.png
Total QSOs compared to 2007 by area - 15 only: http://www.ei6dx.com/wordpress/galleries/report/2014/17.png
Total QSOs compared to 2007 by area - 10 only: http://www.ei6dx.com/wordpress/galleries/report/2014/18.png
Total QSOs compared to previous year by area : http://www.ei6dx.com/wordpress/galleries/report/2014/19.png
Total QSOs compared to previous year by area by mode : http://www.ei6dx.com/wordpress/galleries/report/2014/20.png
Total QSOs compared to previous year (2011 onwards) by area by mode : http://www.ei6dx.com/wordpress/galleries/report/2014/21.png

You can get these reports yourself by using the attached Excel file and get an idea how your area/continent has done over the years. Have fun!

http://www.ei6dx.com/wordpress/galleries/report/2014/ei6dx_com_cqww_analysis_2007_2014.xlsx

GL and see you in test!

Stan
EI6DX