Assignment:
Using the below table solve the following:
| TRx |
TV$ |
Conference$ |
JournalAd$ |
| 88,000 |
100,000 |
95,000 |
87,000 |
| 80,000 |
99,000 |
99,000 |
98,000 |
| 96,000 |
101,000 |
103,000 |
101,000 |
| 76,000 |
93,000 |
95,000 |
91,000 |
| 80,000 |
95,000 |
102,000 |
88,000 |
| 73,000 |
95,000 |
94,000 |
84,000 |
| 58,000 |
80,000 |
89,000 |
74,000 |
| 116,000 |
116,000 |
112,000 |
102,000 |
| 104,000 |
106,000 |
110,000 |
105,000 |
| 99,000 |
105,000 |
87,000 |
97,000 |
| 64,000 |
90,000 |
90,000 |
88,000 |
| 126,000 |
113,000 |
101,000 |
108,000 |
| 94,000 |
96,000 |
100,000 |
89,000 |
| 71,000 |
98,000 |
85,000 |
78,000 |
| 111,000 |
109,000 |
99,000 |
109,000 |
| 109,000 |
102,000 |
101,000 |
108,000 |
| 100,000 |
100,000 |
93,000 |
102,000 |
| 127,000 |
107,000 |
108,000 |
110,000 |
| 99,000 |
108,000 |
100,000 |
95,000 |
| 82,000 |
95,000 |
69,000 |
90,000 |
| 67,000 |
91,000 |
95,000 |
85,000 |
| 100,000 |
114,000 |
91,000 |
103,000 |
| 78,000 |
93,000 |
80,000 |
80,000 |
| 115,000 |
115,000 |
85,000 |
104,000 |
| 83,000 |
97,000 |
105,000 |
83,000 |
| 125,000 |
110,000 |
98,000 |
100,000 |
| 92,000 |
90,000 |
100,000 |
85,000 |
| 72,000 |
95,000 |
86,000 |
80,000 |
Q1) Which promotional mix strategy is forecasted to produce most TRx?
|
TV$ |
Conference |
JournalAd |
| Strategy A) |
95,000 |
55,000 |
88,000 |
| Strategy B) |
77,000 |
88,000 |
99,000 |
| Strategy C) |
80,000 |
70,000 |
80,000 |
| Strategy D) |
90,000 |
60,000 |
85,000 |
| Strategy E) |
50,000 |
100,000 |
100,000 |
| Strategy F) |
100,000 |
80,000 |
70,000 |
Q2) Which variable is the most significant to forecasting TRx?