Overview:
I need a statistics expert that can conduct the analysis of data in a mysql database and produce reports on an ongoing basis.
Steps:
1) download the latest dataset from this page http://httparchive.org/downloads.php (use March 29 2011)
2) follow the instructions to extract the file and populate the database
3) run queries and produce reports in excel
This job will be ongoing however I would like to start with a small project with some clear reports to asses your skills and to find the right fit.
Please provide a quote on the work of getting the dataset, setting it up and produce the following reports:
– a histogram of first view document complete page load time
– a histogram of first view start render times
– what % of sites use CDNs for the root domain ie: www.amazon.com or any other domain that includes the root domain (ie: images.amazon.com or assets.amazon.com)
– correlation between the letter grades given for Keep-alive Enabled, Compress Text, Compress Images, Cache Static Content, Combine JS/CSS Files and Use of CDN to first view document complete page load time