Can anyone provide a function in Excel provides a set of odds (2 to 5 numbers, I choose) based on mathematics and statistics to the next event in a series of random events, like the following on the worksheet attached.
The numbers will be presented in an order nonlinear and random, the function must try to predict what the next number between 2 and 5 possibilities.
The bids should include all costs of the project and should briefly describe what the method to be used in PM.
26 freelancers are bidding on average $153 for this job
I have analyzed your data. And the ocurrence of next value is just random corresponding to current value. Please see the pivot table on attached file. I won't propose any predictive model to it.
I am very much comfot in Excel and able to make many types of MIS according to requirement. I have already made many spreadsheet,which provides results on the base of farmulas and programming.