Find Jobs
Hire Freelancers

Creating a Monte Carlo simulation in excel

£20-250 GBP

Completed
Posted almost 9 years ago

£20-250 GBP

Paid on delivery
I require a Monte Carlo simulation in excel that will take a whole season of 380 Premier League football fixtures and create 10,000 simulations which show how the final end of season league table might look. BASIS OF SIMULATION I have an excel sheet which contains the probabilities (my estimates) for the win-lose-draw percentages for each of the 380 games. The goal is to run 10,000 random simulations for each match USING THE PROBABILITIES I have entered in each cell. So if I have a match where a team is 67% to win, on balance I would expect the simulation to give approximately 6700 results in favour of that team. For each match we award 3 points to the winning team, 1 point for a draw and 0 points for a loss. Then we aggregate these results from all 380 games into a final table. The output will be 10,000 such league tables and I would like to run further analyses of these tables. For instance - in how many of the 10,000 simulations did Man Utd win the league? In how many simyulations did Southampton qualify for the champions League? In how many simulations did Aston Villa get relegated? etc etc. I have attached the excel sheet we need to work with. There are further details in the attched Word Document. PLEASE READ THE FINAL PARAGRAPH "MODIFYING THE SIMULATOR" IN THE WORD DOCUMENT BEFORE QUOTING A PRICE . Freelancers need to be proficient in Excel and possibly Visual Basic (although whichever coding you use is OK by me). They should also have some knowledge of statistics. Although not essential to this project, a casual interest in football would be beneficial. An interest in betting on football would be highly desirable for future projects.
Project ID: 7799958

About the project

14 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I am very good in Excel, betting and simulations. I will use Python to run the simulations and promises a good and clean job. I have made similar simulation on Roulette and Black Jack before. I will do this for cheap since I am new here and need the review. Thank you
£55 GBP in 3 days
5.0 (9 reviews)
4.9
4.9
14 freelancers are bidding on average £178 GBP for this job
User Avatar
Hi: I have few queries that I would like you to address: (1) I understand that you will run 10,000 simulations for the whole season. Please confirm. (2) How do you want me to handle the draw probabilities for each team? (3) You want to extend the simulator to 1,000,000 events, but I believe that Excel cannot handle this much data. However, this simulation is possible if we do not record the data for all 1M events. Please note that I have 100% completion rate and 5-star feedback on all projects (>50 total completed projects). More than 90% of my completed projects are related to Excel and VBA Script. Please check my profile to confirm the quality of my work. Please connect with me to discuss more
£200 GBP in 7 days
4.9 (168 reviews)
7.0
7.0
User Avatar
Hello, my name is Andrés and this looks like a pretty exciting project. I am an industrial engineer with more than four years of experience in the simulation, process improvement and data analysis fields. Within this experience I have developed several skills in MS Excel, and various simulation software like Arena, PowerSim and Simul8. I can handle regression analysis, descriptive statistics, model construccion, complex data analysis, charts, VBA, macros and so on. For this project I would use Excel through with a Montecarlo simulation that would allow to change the number of iterations, and to extract the main statistics you need for every team. Honestly, I would need to discuss my methods with you and to make some research in order to create a good model (that's because I have some doubts). But I love football, the premier league and this field so I would love to work in this. Most importantly, I want to build a excellent reputation here as a freelancer so I will do my very best.
£150 GBP in 3 days
4.9 (125 reviews)
6.9
6.9
User Avatar
I am a top ranking freelancer of statistics and mathematics in freelancer.com and excellent in both the subjects. I am M.Sc. in mathematics. I have done a lot of similar jobs before. Please, check reviews of my past projects.
£200 GBP in 7 days
4.9 (233 reviews)
6.8
6.8
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
£177 GBP in 5 days
4.9 (230 reviews)
6.9
6.9
User Avatar
Hi. I am sure I can do this. As I know EXCEL ( and have an experience in Monte Carlo simulations in it) and know V. Basic (not profi but good enough for simple scripts). Regards
£200 GBP in 7 days
4.9 (154 reviews)
6.7
6.7
User Avatar
Dear, Regarding my qualifications, I hold a Master's degree in Electrical Power Systems and a Bachelor's degree in Engineering (Electrical) and I've been using Matlab/Excel/VBA for 5+ years. Regarding The project: I am a betfair trader (manual and quant/bots) for 3+ years. So familiar with betfair APi... Please check my portfolio/profile/reviews. I am an expert in excel/VBA and in statistics and stochastic calculus. I can do your project with relative ease... Please more info in PM if you are interested. Thank you. :) I await your reply. With Kind Regards Boris
£230 GBP in 4 days
4.9 (32 reviews)
5.4
5.4
User Avatar
hi i have done montecarlo simulation in finance (optiin pricing). i can start on Monday
£166 GBP in 10 days
5.0 (8 reviews)
3.8
3.8
User Avatar
I have the experience of using Monte Carlo simulation in the following projects. 1) Sales projections 2) Service Operations of a Hotel 3) Priority Queue model in Webservers I can solve the project in VBA. Since 380 games need 10000 simulations, the model and code needs to be written with minimum order O(n) so that excel returns faster results. Please ping me to discuss further.
£150 GBP in 5 days
4.9 (15 reviews)
3.7
3.7
User Avatar
SPSS Expert with more than 4+ years of experience. I have been doing descriptive and inferential statitistics Key Techniques are Regression Model Binary Logistic Model Factor Analysis Cluster Analysis Neural Network Parametric and Non-Parametric Test Good in data visualization using Data mining technique like CRT,QUESTetc Please refer my client's feedback ( 5 star rated) Kindly reach out to me for further discussions
£200 GBP in 1 day
4.3 (8 reviews)
4.4
4.4
User Avatar
Hi, I am really expert in Monte-Carlo Simulation and has experience of doing project in this field. It was one of my favorite simulation subject at university. I will love to work on this project. I have MSC in economics and Finance with majors in quantitative methods from Germany. Hope to hear from you soon. Kind Regards, Nadeem Hameed
£242 GBP in 3 days
4.5 (3 reviews)
1.7
1.7
User Avatar
Hello Sir, I am from BITS Pilani India one of the best colleges in the country.. I have holidays and lot of time to spare so i can easily complete your project. i have been doing analysis on excel for long now. I have done lot of monte carlo simulations. i have completed courses like financial management and financial engineering. I assure to do your work in time.
£133 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I belong to a Financial background. Courses like Financial Engineering require Monte Carlo Simulation. I am highly proficient in statistics and have had excel exposure since childhood. All this makes me highly efficient for your work.
£166 GBP in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
woodford green, United Kingdom
5.0
6
Payment method verified
Member since May 7, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.