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?