Find Jobs
Hire Freelancers

Creating a Monte Carlo simulation in excel

£20-250 GBP

Terminado
Publicado hace casi 9 años

£20-250 GBP

Pagado a la entrega
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.
ID del proyecto: 7799958

Información sobre el proyecto

14 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 3 días
5,0 (9 comentarios)
4,9
4,9
14 freelancers están ofertando un promedio de £178 GBP por este trabajo
Avatar del usuario
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 en 7 días
4,9 (168 comentarios)
7,0
7,0
Avatar del usuario
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 en 3 días
4,9 (125 comentarios)
6,9
6,9
Avatar del usuario
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 en 7 días
4,9 (233 comentarios)
6,8
6,8
Avatar del usuario
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 en 5 días
4,9 (230 comentarios)
6,9
6,9
Avatar del usuario
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 en 7 días
4,9 (154 comentarios)
6,7
6,7
Avatar del usuario
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 en 4 días
4,9 (32 comentarios)
5,4
5,4
Avatar del usuario
hi i have done montecarlo simulation in finance (optiin pricing). i can start on Monday
£166 GBP en 10 días
5,0 (8 comentarios)
3,8
3,8
Avatar del usuario
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 en 5 días
4,9 (15 comentarios)
3,7
3,7
Avatar del usuario
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 en 1 día
4,3 (8 comentarios)
4,4
4,4
Avatar del usuario
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 en 3 días
4,5 (3 comentarios)
1,7
1,7
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
woodford green, United Kingdom
5,0
6
Forma de pago verificada
Miembro desde may 7, 2012

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.