This is a somewhat simple data job for a skilled person. I have been tracking three different sports prediction services. I would like to know whether any conclusion can be drawn when the different prediction services agree.
For example, if A, B and C represent prediction services, and if A=1 and B=1 and C=2, when compared to the actual results, 1 is the result xx% of the time, and 2 is the result xx% of the time.
Or, if A=1 and B=2 and C=1, when compared to the actual results, 1 is the result xx% of the time, and 2 is the result xx% of the time.
Using the aforementioned methodology, I have approximately 1000 lines of data for A, B and C as well as the actual data. All data is in an excel file.
You'll need to look at the prediction (this value represents a margin of victory) and then the actual margin, and conclude as to win/loss. Then you'll need to compare the relationship between 1, 2 and 3 and determine if there is value when 1 and 2, or 1 and 3, or 2 and 3 or all agree.
I'm sure for you this will be an easy project but I'm tired of trying to learn excel formulas.
There will probably be additional work along these lines if the project is successful.
Dear Kawi Consulting! I am an Engineer with pretty good knowledge in math - and also and experienced VB and VBA programmer. Would be happy to work for you. Please, check PMB. Sincerely yours, John.
Hi kawiconsulting,
I can say that I am an expert in writing evaluation scripts. My solution will take one to two days. First, I will store the excel file as a text file and then I consider to use a Perl or PHP script to make all the calculations needed to estimate the conditional probabilities.
Best regards:
I have understand your requirement, please provide the source and further instruction to proceed further. Please consider and reply asap.
Iam expert in excel. So dont worry about quality and time.
Regards
Mahes
I will give you a excel to do that. Data should be test for it's distribution (normal/not). I already experience make this before. Then if it's normal distribution proceed to make analysis of data, if not it's useless to make prediction. It will be very simple excel that I provide to you. I need escrow to do any project, please don't respond if you not willing to use escrow. Thanks.
Dear sir/madam,
I used to work with database specially using excel, can you give more details, so i can give you example for the number of calculations you want.
I am a software professional and worked for big firms. I would make sure that i utilize my skill set to the fullest and deliver the quality product in the given timespan.