Reservation Prediction Model

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

I have a ~5000 data entries in an excel spreadsheet. Each entry is a reservation for a product which is defined by the "EntityID". Each entry also has "OrderDate", and "StartDate" and "End Date".

Based off this historical data, I would like to create an algorithm that makes a prediction whether a requested product is available given today's date, and a future start date/end date.

The expected inputs to the function will be the following:

1) entityID

2) Today's date

3) Future start date

4) Future end date.

The expected output required will be

1) Confidence %(100-0)

2) The number of days in advance of start which will achieve a 95% confidence rating or more.

IMPORTANT: I will be programming your prediction model into a system(Python or Javascript, not sure which). You don't need to do any programming, but I will need to interpret your functions or VB code. So either comment your code, or write notes in the table on how it works. This is essential.

Excel Mathematics Statistical Analysis Statistics

Project ID: #15135027

About the project

3 proposals Remote project Active 6 years ago

Awarded to:

osmemon

I can develop complete algorithem with statistics analysis on VB with complete comments on code.. See my profile to know client reviews about me Relevant Skills and Experience Excel VBA Statistics Proposed Milestones More

$86 USD in 1 day
(18 Reviews)
5.1

3 freelancers are bidding on average $162 for this job

Valuesolutions

Hello, how are you? I hope you have a bright day/evening from your side. I have read the details provided, but please contact me so that we can discuss more on the project Stay tuned, I'm still working on this propos More

$250 USD in 3 days
(12 Reviews)
4.5
dvcontact

Hi, If you are looking for a professional and reliable Excel expert with proficiency in data analysis, I'm your ideal candidate. I'm highly experienced in producing mathematical solutions with Excel and I have a stron More

$150 USD in 3 days
(8 Reviews)
3.8