Reservation Prediction Model

Completado Publicado hace 6 años Pagado a la entrega
Completado Pagado a la entrega

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 Matemáticas Análisis estadístico Estadísticas

Nº del proyecto: #15135027

Sobre el proyecto

3 propuestas Proyecto remoto Activo hace 6 años

Adjudicado a:

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 Más

$86 USD en 1 día
(18 comentarios)
5.1

3 freelancers están ofertando un promedio de $162 por este trabajo

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 Más

$250 USD en 3 días
(12 comentarios)
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 Más

$150 USD en 3 días
(8 comentarios)
3.8