I want the attached probability formula to be coded for both Access VBA and T-SQL (Server 2019 Express).
The situation is that I have n numbers in a set (N1, N2, N3 ... Nn). For each number I choose a random number (R1, R2, R3 ... Rn) between 1 and the number (e.g. 0 < R1 < N1, 0 < R2 < N2, 0 < R3 < N3 ... 0 < Rn < Nn ). My quest is to seek the probability for each random number that it should be the largest of the random numbers in the set i.e. P(R1=max(R1 ... Rn)), P(R2=max(R1 ... Rn)) etc. up to P(Rn=max(R1 ... Rn)).
I need the code to be able to read just one or multiple groups of numbers from an SQL database. I can set the selection code in SSMS (version 18.12.1). I want your code to read and process the list of numbers from a vertical record set of [Group_ID], [Number_ID]. Each group can contain from 2 numbers up to and including 40 numbers and the numbers within a group are not sequenced though they could be if advantageous. I have been given the attached formula and have tested it against Monty Carlo Simulations and it gives accurate returns. The formula needs to be applied for each number in a group as it calculates probability for each number individually.
I want to be able to perform the calculations direct from SSMS and from Access 365 being used as a Front End to the SQL Server database. I want the output to mirror the input so that I can easily make comparisons in Excel.
Please ask if further questions and confirm you understand the formula notation ... it took quite a bit of research on my part to understand it as I never went beyond "A" level pure maths!
Note: I may want to publish the project on a website in the future but this should only be born in mind in the design if it has minimal impact on your design. I would not want inflated work time (and inflated cost!) at this stage because this is only a 'maybe'.
I look forward to receiving considered proposals describing how you will structure this and how you see me applying it. I am surprised to see that PPH is offering this project at a "fixed price" of £363. That is not the case ... they suggested that as a "Budget" not a "fixed price" and I accepted their suggestion on that basis! The price is not fixed ... I have no idea what the cost may be and will decide if this is a project to go forward with depending on the value to me of the cost.
