# CREATE A STATISTICAL TOOL

DEVELOP A STATISTICAL TOOL

I am looking for a freelancer to develop a statistical tool to study numerical values stored in a database. The database contains values assigned progressively to Player 1 and Player 2 during a tennis match. (For example, we get the File1 informations, stored in the database)

MY NEEDS (all is well discribed in File2) :

1- First, I have to enter in the statical tool cotes I am looking for and coefficients I want to apply to each cote found. So I manually enter my cotes and their coefficients in the tool.

For example :

01st cote ≤ 1,400 and 01st coefficient = 10

02nd cote ≤ 1,525 and 02nd coefficient = 23

03rd cote ≤ 1,090 and 03rd coefficient = 58

04th cote ≤ 1,278 and 04th coefficient = 34

05th cote ≤ 1,833 and 05th coefficient = 108

06th cote ≤ 1,500 and 06th coefficient = 21

07th cote ≤ Not defined and 07th coefficient = Not defined

08th cote ≤ Not defined and 08th coefficient = Not defined

09th cote ≤ Not defined and 09th coefficient = Not defined

10th cote ≤ Not defined and 10th coefficient = Not defined

2- The tool now knows cotes I am researching and coefficients to apply. It can start to scan data to do the job expected.

a - The tool must scan the registered event informations, line after line, to find the first cote ≤ 1,400 and apply to the first cote found, the 1st coefficient (in this example 10).

b - If 1st cote ≤ 1.400 is found in a player's cotes, the tool must now scan the following lines ONLY IN THE OTHER PLAYER'S COTES to look for the 2nd cote ≤ 1.525 .

If cote ≤ 1.525 found in this player's cotes, the tool must apply the 2nd coefficient (in this example 23).

c - The tool must now scan the following lines ONLY IN THE OTHER PLAYER'S COTES to look for the 3rd cote ≤ 1.090.

If cote ≤ 1,090 found in this player's cotes, the tool must apply the 3rd coefficient (in this example 58).

d – and so on …

3- Then at the end of the match, the tool must now proceed 4 calculations :

a - The tool must add the results of Player 1 and Player 2 obtained during this match

b – The tool must add all coefficients applied during this match

c - Then the tool must do the following calculation :

"WINNER OF THIS EVENT" TOTAL SCORE - TOTAL COEFFICIENTS APPLIED DURING THIS EVENT = SCORE FOR THIS "GROUP OF COTES AND COEFFICIENTS"

d – The tool must also do the following calculation :

Score for this group of cotes and coefficients / Total coefficients applied during this event = Rate in %

4 - Conclusion for this group of cotes and coefficients :

The tool must now conclude that for these values I entered manually,

The score is -13,84 . (for this example)

The total coefficient applied is 91 .

The rate is -15,21% .

**** NOTES TO UNDERSTAND WELL THIS PROJECT : ****

- The tool must scan values in order of increasing time and must never scan the previous time.

- When a searched cote is found in a player's cotes, the tool must then look for the next cote researched « only in the other player's cotes ».

- The Score can be a positive or negative result.

- I must be able to enter from 1 to 10 cotes and coefficients in the tool interface before processing.

- The tool must be able to apply this group of cotes and cofficients to hundreds or thousands of events stocked in the database and provide the final results for this group of cotes and cofficients applied to all these events.

- I must be able to select Periods or Leagues I want to apply the group of cotes and coefficients when I manually enter values I want to study (at the first step of this process). The script to select Periods or Leagues is already written and stocked on my server, you should be able to use it.

- I stay 100% free to answer all questions you need

About the Employer:
( 20 reviews ) Orléans, France

Project ID: #11347738

## 15 freelancers are bidding on average \$206 for this job

someka

I will work on Excel and create you a statistical Exel template/tool to analyse your dataset. Mostly mathematical functions are already native but we can use VBA to code the necessary algorithms as well. I have an engi More

\$300 USD in 5 days
(52 Reviews)
6.2
sumbali

I can perform the analysis using any kind of Statistical Software like R, SPSS , MINITAB Eviews Statistica etc I Will perform analysis like , Regression ,Time series ,Panel Data Experimental Designs Factor analysi More

\$250 USD in 5 days
(81 Reviews)
5.8
Softeria

I am a STATISTICS tutor for last 5 years. I have expertise in Statistical Analysis. I can show you some of my previous analysis. I have excellent concepts of Random variables, Probability Distribution, Sampling and di More

\$200 USD in 10 days
(26 Reviews)
4.9
Tanmoy236

Your work can be done through Excel. I am extremely good with excel as it is part of my daily professional work. I am fast accurate and at the same time understand the value of quality and deadlines. I have already don More

\$150 USD in 3 days
(16 Reviews)
4.3
\$222 USD in 7 days
(12 Reviews)
4.2
logos104

Hi. I have about 15 years of programming experience. Mostly I used C, C++ and C# for my projects development. Let's discuss details of the projct.

\$250 USD in 4 days
(7 Reviews)
3.3
oda79

Hello! I am ready to help you with your task! What kind of software do you mean desktop or web-based? Do you need some chart implemented or only table views? Please do not hesitate to contact me via messenger!

\$222 USD in 10 days
(1 Review)
2.2
smartresearch1

I am an expert in data mining and predictive modeling and I can definitively create the tool in R. I have a PhD in physics and strong background in statistics, data manipulation and coding.

\$220 USD in 6 days
(1 Review)
1.7
fouadjabiri

Hi, I've been working on Excel macros and MySQL for several years, and would like to work on your project. I'm looking forward to hearing from you.

\$111 USD in 5 days
(1 Review)
1.1
DHSprout

Hi I have 3+ experience in web development. I did many job like this. I have strong knowledge of Mysql, Oracle, Database Design and I have also strong knowledge in languages like Java, JSP, PHP, Javascript, Boo More

\$144 USD in 3 days
(1 Review)
0.8
\$200 USD in 3 days
(1 Review)
0.8
hafizshoaib

Asalam o Alaikum, During my career, I have gained a wide knowledge and understanding of data collection methodologies, sampling methodologies, multivariate statistical analysis, Principles and techniques. I have out More

\$222 USD in 3 days
(1 Review)
0.4
AVRocker1

Hello Gentleman, I read your post regarding statistical tool, I have great experience working with PHP technology it's CMS & Frameworks like YII, Laravel, Codeigniter, CakePHP, OpenCart, WordPress, Prestashop & A More

\$250 USD in 3 days
(1 Review)
0.0
jokwon75113

hi, nice to meet u. i am statistical expert. i will meet your needs in 2 days. i have worked in statistical analysis , data entry, data processing. pls contact with me.

\$155 USD in 3 days
(0 Reviews)
0.0
javaconnect

Hello! I am an experienced R developer and Data Scientist. I am sure I can work for you and you won't regret it! Please consider my bid

\$200 USD in 3 days
(0 Reviews)
0.0