The Data is structured as: Date of Sale | Order Amt | Price of product | Qty.

Product A was sold independent of Product B(thus, 2 datasets), so dates do not match at certain instances, and entries are also not continuous do to the same reasons, both products may also have days of 0 sale.. so no entry at all.

Both products have sold for different prices at different moments, I want to see if the price drop of Product A affects the Qty sold of Product B, and vice versa.

Also the same for price increase.

In general the trend of Product A price to Qty of Product B.

I am confused how to tackle this problem.



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.