You will get real duration of overlapped sales promotions or health treatments.


Let a pro handle the details

Buy Other Data Analysis & Reports services from Xavier, priced and ready to go.

You will get real duration of overlapped sales promotions or health treatments.


Select service tier

  • Delivery Time 2 days
  • Number of Revisions 1
2 days delivery — Feb 28, 2024
Revisions may occur after this date.
Upwork Payment Protection
Fund the project upfront. Xavier gets paid once you are satisfied with the work.

Let a pro handle the details

Buy Other Data Analysis & Reports services from Xavier, priced and ready to go.

Project details

Many times, events are first designed for a period of time but updated before their end (for instance, a new price or health treatment): lower price to foster sales, higher price before stockout, new treatment that may replace or not the precedent one.

With the correct duration, predictions of units sold based on price (by the event) are more accurate. In health, if a medicine or physical therapy is affected by another medicine or by a new condition of the patient, its performance is better estimated with the real duration: for instance, if a patient is unable to collaborate doing gymnastics due to new conditions or medicines, the original “gymnastics” event lasted (=duration) less days.

Starter is for up to 100,000 events (=rows in a worksheet) (No maximum number of events by ID). Standard is for up to 1 million events in a sheet (approaching Excel limit). Advanced is for over 1 million.

In Starter and Standard tiers, only days are considered: Duration is an integer number.
In Advanced, if you wish, hours and minutes are considered: Duration may have decimals.

Attached PDFs to understand how Duration is computed in Starter and Standard tiers. Advanced is a customized version.
What's included
Service Tiers
Delivery Time
2 days
3 days
5 days
Number of Revisions
Source Code

Frequently asked questions

7 reviews
4 stars
3 stars
2 stars
1 star
Rating breakdown


Tanveer A.
Aug 23, 2023


Menna E.
Apr 18, 2023
Catalan Native Speakers Needed || Audio Data Collection Project


Saurabh A.
Oct 7, 2022
Statistical analysis using EFA, CFA and SEM


Ulrich V.
May 5, 2021
Questions Concerning R Lavaan Multiple Imputation and Interaction Effects


Ulandi K.
May 27, 2019
Data Science - Ongoing Support
Xavier S.

About Xavier

Xavier S.
Data Scientist
100% Job Success
5.0  (7 reviews)
Barcelona, Spain - 10:10 pm local time
Over two decades on research, mainly in two universities (ESADE Business School, and UNISA-University of South Australia), also in an Artificial Intelligence start-up.

R-user. List of Methodologies and R packages:
- Regressions, Mediations, Moderations.
- IRT (Item Response Theory), IFA (Item Factor Analysis): psych.
- SEM (Structural Equation Models) (incl. Formative variables, and multilevel): lavaan, sem, umx, metaSEM.
- PLS (Partial Least Squares): semPLS, matrixPLS.
- Multilevel, Mixed models: nlme, lme4, MicroMacroMultilevel, lavaan.
- Association rules: arules.
- Functional Data Analysis: fda.
- "Forensic" statistics.

Other keywords in R: RStudio, Markdown, Shiny, Faultlines, kappalab, OpenMx.
Other keywords: SPSS, Amos, Weka, Python, Onyx (Ωnyx), Qualtrics.

Genetics: SNP (Single nucleotide polymorphism) markers to predict diseases or customized medical solutions. Mainly “SNP rs numbers” in 23andMe files. Nonlinear methods are used.

Ready for SSD (Summary Statistics Data) inputs (without datasets): most linear models can be obtained with just SSD (number of cases, means, standard deviation, correlations). It includes linear regressions, mediations (but not moderations), structural equation models, partial least squares. Same results as using the original datasets. No simulated data.

Languages: English, Spanish, French, Italian, and Catalan.

Steps for completing your project

After purchasing the project, send requirements so Xavier can start the project.

Delivery time starts when Xavier receives requirements from you.

Xavier works on your project following the steps below.

Revisions may occur after the delivery date.

You send me the dataset

event_start, event_end, and ID columns are required (or their equivalent name). Extra columns are optional but to no avail to compute the real duration: ex., to define the event (a price or discount, an item of the Health Fact Sheet).

I send you my output

My output is input data (3 or more columns) plus another column with the real duration in Day unit. No graphics at all. The only purpose of print screens in attached PDFs is to understand how valid days are estimated. They are not my output.

Review the work, release payment, and leave feedback to Xavier.