Question: A study was commissioned by P&G (Malaysia) on the performance of Product A, and how its monthly sales were affected by promotions as well as
A study was commissioned by P&G (Malaysia) on the performance of Product A, and how its monthly sales were affected by promotions as well as its pricing strategy over a period of 12 months in Kuala Lumpur. The data collected was analysed and a model was constructed to attempt to better understand the underlying relationships among the variables. The attributes collected are: Price X = The average monthly price in Kuala Lumpur of Product X Price Y = The average monthly price in Kuala Lumpur of Product Y Promotion A = "Buy 2 - Get 1 free promotion" (1 = 'Yes', 0 = 'No') Promotion B = "10% discount (1 = 'Yes', 0 = 'No') The following outputs were the result of the study when Excel was used:

\f
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
