0
$\begingroup$

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.

$\endgroup$

0

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.