I will send you excel sheets with results of particulars seasons and particular football leagues with all matches. Data include:
Date
Home Team
Away Team
Home goals at half time
Away goals at half time
Half time result (H/D/A)
Home goals at full time
Away goals at full time
Full time result (H/D/A)
Home odds
Draw odds
Away odds
Under 2.5 odds
Over 2.5 odds
I would need you to make excel functions to get the following information per line (match):
Match day no (e.g. 1,2,3 etc)
League position until the date of match (by calculating results of previous match days from same excel sheet)
Home goals scored until the date of the match (by calculating from previous match days) at half time & full time
Home goals conceded until the date of match (by calculating from previous match days) at half time & full time
Home goal difference at half time & full time
Away goals scored until the date of the match (by calculating from previous match days) at half time & full time
Away goals conceded until the date of match (by calculating from previous match days) at half time & full time
Away goal difference at half time & full time
Total goals scored until the date of the match (by calculating from previous match days) at half time & full time
Total goals conceded until the date of match (by calculating from previous match days) at half time & full time
Total goal difference at half time & full time
Who's the favourite (example H/D/A)
Who won (example fav/non-fav/draw) at half time & full time
Over/Under 2.5 goals at half time and full time
Some other related things to football betting
I would also need you to make summaries to know particular information (that I will tell you later upon selection of bidder).
After finishing, I would like to import all data in SPSS and find out of any relation, correlation, significance and dependence between variables to predict betting outcome in the long term in order to develop a long term betting strategy.
More details after the preferred bidder is selected. This is a very interesting job. The first part is very easy as you can create functions in the first line and copy and paste in all other lines. The SPSS configuration part is the most interesting part. I would need a backup copy of the project (excel & SPSS).
N.B. I will send you valuable data to work on and hence you cannot use it for any other use (apart from this project).
Hi, I am a freelance analyst and have extensive experience in data analysis using Excel and prediction statistics with SPSS.
Please see your PMB for further details.
€120 EUR in 5 days
4.2 (1 review)
2.4
2.4
17 freelancers are bidding on average €336 EUR for this job
Hi, I can do it. I'd done very similar project
http://www.freelancer.com/projects/1601654.html.
In this project I also calculate many ratings along with team points/position for season upto any selected match.
I can modify it to suit your need. Will send you the demo file tomorrow when I come back from my trip.
Looking forward to hearing you,
Cuong NH
Quick clarification:
You said after finishing "I would like to be able" do you mean that you want me to do that part or not. The Excel part is easy. So is the spss part but the price would have o vary accordingly!
Thanks!
Superb work to do man I would love to take this project. Do you also need help on statistics part. I know SAS and SPSS both. Can help you on probability theory too.
Hello!
I have 3+ years of working with Excel every day at my job. I have plenty of experience with this. And, besides, I love football! I find this project really interesting!
This is something that can be done easily. Do not waste your time we can start work immediately. I send you some documents for to be sure that I can provide you something more than your expectation. Please check my private message.