Excel data structuring + analysis of big data
I am looking for an experienced excel guy. Working with statistics programs could also be an advantage (SAS, SPSS etc)
I have around 30 excel sheet each with 34 columns, and rows varying from 10.000 to 250.000. The data shows race results from marathons. There will be many different tasks to do - here are some examples:
1) Given parameter x,y,z calculate t
2) Work with different cell formats (general, number, tt:mm:ss).
3) Based on my hypothesis, see if data validates my hypotheses. An example could be: I have a hypothesis that men finish marathons faster than women. Then you will be an average of the mens and womens finish times across all 30 sheets and compare them. Another hypothesis could be that younger men starts out faster than elder men (stupid young people) and they burn out after second half. A third hypothesis could be that participants from foreign countries (participants who travel for their races), will finish faster etc etc etc.
4) Makings graphs based on inputs (loads of descriptive statistics)
There are plenty of tasks to do, those were a few examples.
You can see the current structure of the data here: http://screencast.com/t/amJOWtcGKG. The data is more or less identical for all 30 sheets, but not all have all information about each parameter.
I am looking for a stable modest guy/team, who can support me and clean the numbers + test my hypothesises. You are relatively experienced within excel and has a computer that can handle loads of data (there are many rows!!)
Delivery: I am not in a hurry, and it will be a proces, starting out with small very specific tasks.
Let me know your experience and why we should work together.