Question: Do use Minitab. This question has Categorical Dependent Variable, which means that you must use Logistic Regression. Include screen captures of the regression model Data

Do use Minitab. This question has "Categorical Dependent Variable", which means that you must use Logistic Regression.

Include screen captures of the regression model

Data is here:

S.No SALES(Yes_or_No) CLICKS IMPS Avg POS
1 0 4 112 6.5
2 0 2 100 6.5
3 0 2 127 17.4
4 0 3 22 1
5 0 4 86 7.5
6 1 26 1368 3.1
7 0 1 9 12.7
8 0 1 204 8.6
9 1 16 353 6.2
10 0 6 96 1.8
11 0 1 41 1.1
12 1 65 2142 4.6
13 0 3 101 3.9
14 0 1 35 3.1
15 0 7 40 1.2
16 0 2 93 3.9
17 0 7 450 6
18 0 3 600 2
19 1 12 470 3.8
20 0 5 136 1.2
21 0 2 16 2.1
22 0 4 59 2.7
23 0 2 80 1.1
24 0 1 14 1
25 0 3 25 2
26 1 73 2001 3.8
27 0 20 150 1.1
28 0 1 10 1
29 0 1 46 2.7
30 0 9 247 1.6
31 0 2 34 5.9
32 0 11 327 1.8
33 1 1 59 3
34 1 23 826 1.3
35 1 8 61 1.2
36 0 2 55 1.1
37 1 12 163 1.7
38 1 10 233 12.4
39 0 1 6 11
40 0 6 589 4.1
41 0 2 15 3.6
42 0 4 73 6.1
43 0 4 55 1
44 0 2 31 7.7
45 1 1 11 4.7
46 0 1 2 8
47 0 7 10 1
48 0 16 559 6.3
49 0 2 107 6.9
50 0 7 77 1.1
51 0 3 12 2.9
52 0 6 111 2.1
53 1 16 29 1.1
54 0 2 20 1.3
55 0 1 9 1.6
56 0 1 52 2.4
57 0 1 21 6.6
58 0 5 293 3.9
59 0 1 40 8
60 0 1 1 46
61 0 4 81 6
62 1 5 140 1.1
63 0 11 368 1.7
64 0 2 45 43.6
65 0 2 272 1.8
66 0 7 37 1.7
67 0 7 759 1.2
68 0 1 230 4.6
69 0 1 91 11.4
70 0 4 39 6.4
71 0 26 530 1.6
72 0 18 1110 6.3
73 1 17 409 1.8
74 0 2 56 8.3
75 1 14 38 1
76 0 5 433 6.6
77 0 2 13 1
78 0 5 258 1.8
79 0 5 65 1.8
80 0 2 73 1.1
81 0 1 47 3.5
82 0 29 1042 5.5
83 1 15 203 1.7
84 0 3 26 1
85 0 9 388 3.4
86 0 2 13 1.5
87 0 7 48 1.4
88 0 1 4 2
89 0 18 180 3.1
90 0 71 3144 7.8
91 1 216 470 1
92 0 10 136 1
93 0 7 164 1.3
94 1 2 89 1.7
95 0 5 56 2.2
96 0 7 103 2.2
97 0 4 258 18.3
98 0 3 77 3.6
99 0 6 97 2.1
100 0 7 16 1.1
101 0 9 237 2.3
102 0 5 278 5.4
103 0 1 28 3.9
104 0 27 646 1.4
105 0 2 15 4
106 0 12 520 4.6
107 0 3 9 2
108 0 3 100 6.9
109 0 3 177 5.3
110 0 1 2 2
111 1 40 284 1.9
112 0 2 117 16.6
113 0 1 44 5.2
114 0 13 98 1
115 1 12 225 1.5
116 0 1 17 20.5
117 0 5 200 9.1
118 0 1 9 1
119 0 1 16 4.3
120 0 12 554 5.5
121 0 3 47 3.9
122 0 2 24 1.7
123 0 3 101 8.2
124 0 2 201 9.6
125 0 20 816 4.5
126 0 5 276 7.5
127 0 3 82 1.1
128 0 2 67 3.1
129 0 17 1887 8.5
130 1 8 33 1
131 1 10 481 5.3
132 0 25 429 4.2
133 0 16 910 6.3
134 0 1 163 23.1
135 0 1 219 1.1
136 0 1 7 1
137 0 1 23 6
138 0 1 45 1.6
139 1 3 7 1
140 0 2 197 9.3
141 1 3 77 1
142 1 29 1067 1.1
143 0 1 36 2.7
144 0 3 150 3.3
145 0 2 83 6.7
146 0 42 1002 2.1
147 0 1 6 1.7
148 0 1 9 9.7
149 1 3 9 1
150 1 1 126 4
151 0 4 55 7.2
152 1 8 109 1.1
153 0 3 114 2.3
154 0 5 298 1.8
155 1 33 850 1.3
156 0 23 718 9.1
157 0 1 19 2.8
158 0 1 24 1.5
159 0 1 16 9.3
160 1 18 451 1.6
161 0 21 217 1.6
162 0 1 21 18
163 0 5 50 1.1
164 0 2 31 5.1
165 0 1 25 2
166 0 11 505 1.5
167 0 4 29 2.5
168 0 4 116 4.9
169 0 1 74 2.4
170 0 1 73 6.8
171 0 4 196 3.9
172 0 20 397 7.1
173 0 1 99 11.3
174 0 3 13 2.8
175 0 2 27 6.7
176 0 1 26 4.7
177 0 2 51 1.2
178 0 3 177 8.9
179 0 1 5 3.2
180 0 1 41 1
181 0 2 104 1.1
182 0 1 20 3
183 0 5 61 13.2
184 0 1 86 5.6
185 0 1 32 1.1
186 1 5 83 1.5
187 0 2 419 17.7
188 0 7 237 5.5
189 0 1 6 1
190 0 28 225 1.4
191 0 1 22 3
192 0 23 258 1.6
193 0 8 39 1.1
194 0 1 7 1.7
195 0 6 102 2.7
196 0 13 2533 4.6
197 0 13 254 4.1
198 0 1 161 1.7
199 0 7 326 5.2
200 1 1 54 9.4
201 0 3 32 2.6
202 1 35 256 1.1
203 0 2 74 5.4
204 0 3 35 1
205 0 7 273 3.5
206 0 1 2 1
207 1 20 136 1.4
208 1 5 9 1
209 1 17 150 2.2
210 1 25 1524 2.4
211 0 9 394 9.4
212 0 7 478 7.4
213 0 6 238 7.1
214 0 3 6 1
215 0 2 246 2.1
216 1 27 49 1
217 0 2 12 2.5
218 1 9 200 1.4
219 0 2 28 1.1
220 0 1 66 5.7
221 0 1 34 2.5
222 0 6 74 1.3
223 1 31 1070 1.6
224 0 21 2218 8.6
225 1 4 295 6.1
226 0 1 24 1
227 0 1 2 5.5
228 1 3 55 2.7
229 0 1 1 18
230 0 1 4 1.8
231 0 5 442 3.7
232 0 6 78 1.4
233 0 6 88 1.2
234 0 5 133 1
235 1 5 290 2.1
236 0 6 147 8.2
237 0 17 265 4.3
238 0 1 70 2.3
239 0 1 8 31.3
240 0 4 182 1.9
241 1 1 54 5
242 1 14 137 3.5
243 0 1 1 5
244 0 6 257 1.8
245 0 1 11 2.4
246 0 1 16 4.4
247 0 1 35 49.3
248 0 1 7 1
249 0 1 16 1.6
250 1 40 76 1
251 0 1 229 7.3
252 1 3 51 1.8
253 0 4 38 3.4
254 0 5 396 8.3
255 0 6 90 3.9
256 0 10 319 2.9
257 0 2 23 3.1
258 0 2 14 1.3
259 0 1 129 8.4
260 0 10 167 1.9
261 0 1 208 1.4
262 1 12 154 1
263 0 2 2 1
264 1 118 263 1
265 0 10 101 1.7
266 0 11 140 1.1
267 0 2 83 12.7
268 0 2 14 5.6
269 0 2 52 1.8
270 0 16 567 2.6
271 0 1 27 21.9
272 1 3 68 3.4
273 0 4 200 9.9
274 1 7 42 1.3
275 0 1 5 3.4
276 0 7 88 1
277 0 4 50 1.7
278 0 1 3 2.7
279 0 18 216 1.5
280 0 1 71 1.8
281 0 9 437 2.1
282 0 1 97 2.2
283 0 2 62 1
284 0 1 28 1.3
285 0 1 37 12.9
286 1 3 32 1
287 1 43 1742 6.8
288 0 17 42 1.1
289 0 20 412 1.1
290 0 10 194 8.1
291 0 1 97 6.9
292 0 1 11 2.4
293 1 27 1528 5.3
294 0 6 255 4.4
295 1 2 4 1
296 0 1 5 5
297 0 1 4 1
298 0 3 26 10.3
299 0 1 6 7.5
300 0 2 34 69.2
301 0 3 18 5.5
302 0 3 85 5
303 0 1 7 1.4
304 0 1 25 2.9
305 0 15 532 1.4
306 0 2 33 4.8
307 0 1 14 2.9
308 0 1 3 1
309 0 1 90 12.1
310 0 9 327 1
311 0 3 36 2.1
312 1 28 2990 4.6
313 1 5 218 1.8
314 0 1 40 1.3
315 0 4 58 1.9
316 1 41 490 1.9
317 0 1 26 12.1
318 0 2 62 4.9
319 0 1 120 13.6
320 0 1 39 1.1
321 0 3 32 6.1
322 0 2 29 2.8
323 1 32 70 1
324 0 1 66 2
325 1 1 24 1.4
326 0 8 149 1.4
327 0 12 100 1.1
328 0 4 33 1.1
329 0 6 77 2.9
330 0 1 44 8.1
331 0 1 54 4.7
332 1 53 1582 1.9
333 0 5 415 10.3
334 0 9 328 1
335 0 1 3 2.3
336 0 5 56 2
337 1 31 4738 3.3
338 0 1 31 5.4
339 0 1 2 1
340 1 54 1367 1.7
341 0 3 164 5.9
342 0 1 145 10.1
343 0 1 27 2
344 0 29 397 1.8
345 0 1 53 12
346 1 21 776 1.2
347 0 12 152 3.7
348 1 29 66 1.1
349 0 1 57 1.9
350 0 14 155 3.1
351 1 9 319 7.6
352 0 5 65 1.8
353 1 10 78 1.8
354 0 1 20 3.8
355 0 6 162 2.1
356 1 25 561 1.9
357 0 1 177 1.5
358 0 3 130 1.9
359 1 1 37 3.4
360 0 2 2 1
361 0 1 3 23.3
362 0 3 188 2.2
363 0 1 6 3.5
364 0 7 142 5.2
365 0 3 103 2
366 1 14 162 1.8
367 0 3 22 27.1
368 0 1 15 7.9
369 1 55 1132 2.7
370 0 2 29 3.3
371 0 1 26 1
372 0 11 371 1.3
373 1 14 529 1.1
374 0 1 30 2.7
375 0 5 110 8.2
376 0 3 147 2.7
377 0 5 21 1
378 0 6 242 1.6
379 0 1 16 7
380 1 40 1304 2.1
381 0 14 699 6.9
382 0 1 29 36.2
383 0 1 273 29.4
384 0 1 17 2.1
385 0 4 43 4.9
386 0 11 287 11
387 1 8 196 2.8
388 0 2 25 1.2
389 0 1 30 7.4
390 0 1 57 38.5
391 0 17 423 3.9
392 1 29 804 1.5
393 0 1 2 1
394 1 9 205 3.9
395 0 4 117 10.9
396 0 5 131 1.6
397 0 11 472 4.8
398 0 15 222 1.4
399 0 4 30 1.7
400 0 1 28 4.4
401 0 4 117 6.5
402 0 4 250 2.3
403 1 1 13 3.5
404 0 2 13 1
405 0 1 77 11.2
406 1 11 31 1.3
407 0 1 31 9.3
408 1 28 467 2
409 0 4 264 6.4
410 0 4 128 1.2
411 0 6 21 1
412 0 4 113 1.1
413 0 8 136 3.3
414 1 31 746 2.7
415 0 1 9 1.2
416 0 3 321 1.5
417 0 2 8 1.4
418 0 2 43 9.2
419 0 2 331 4.6
420 0 10 447 6
421 0 1 107 7.7
422 0 2 137 5.4
423 1 25 276 1.5
424 0 4 42 1.1
425 0 3 60 1.4
426 0 1 1 2
427 0 1 15 1.1
428 1 11 276 1.5
429 0 1 2 1.5
430 0 7 184 1.1
431 0 19 102 1.2
432 0 4 139 2
433 1 29 832 1.3
434 1 65 1147 3.1
435 0 1 109 35
436 0 7 124 2.1
437 0 2 21 1.1
438 1 12 412 7.5
439 0 2 6 1.8
440 0 1 65 3.8
441 1 8 98 2
442 0 7 254 2.9
443 1 5 149 2
444 0 32 1174 1.4
445 0 2 13 1
446 0 3 79 1.2
447 0 8 57 1.2
448 1 28 218 1.7
449 0 9 99 2.2
450 0 9 294 5.2
451 1 130 3094 2.8
452 0 12 500 5.9
453 0 3 10 2.1
454 0 1 12 1.2
455 0 1 4 16.8
456 0 1 51 11.3
457 0 2 199 2.6
458 1 2 47 2.8
459 0 8 1165 9.6
460 1 35 59 1
461 0 2 34 2.6
462 0 5 86 3.6
463 0 2 68 3.2
464 0 2 79 1.5
465 0 3 101 1.4
466 0 4 491 1.4
467 0 2 46 2.1
468 0 2 121 13.7
469 0 5 174 5.2
470 1 25 3896 3.5
471 0 6 79 2.1
472 0 1 6 2
473 0 1 41 1.2
474 0 3 28 4.8
475 0 1 52 1.9
476 0 5 118 12.5
477 0 2 140 1.9
478 0 8 226 1.1
479 0 1 38 26.1
480 0 1 21 1.6
481 0 1 12 2.1
482 0 1 11 1.1
483 0 11 154 4.5
484 0 1 33 10.3
485 0 1 16 4.6
486 1 25 503 2
487 0 1 34 3.2
488 0 5 129 2
489 0 1 19 7.3
490 0 2 174 9.8
491 0 3 70 1.3
492 1 30 79 1
493 0 6 38 1.3
494 0 4 73 1.1
495 0 24 186 1.5
496 1 1 38 2.1
497 0 5 153 5.5
498 0 1 7 32.3
499 0 1 4 5.3
500 0 1 1 1

We have daily data on the following variables, - Whether any sale can be attributable to the adword (SALE [Yes=1 or No=0]) - Number of Clicks (CLICKS) generated by the adword - Number of impressions (IMPS) adword gets - The average position (AvgPOS) occupied by the adword.

Higher the AvgPOS, lower is the adword displayed in the rankings and hence less likely to be viewed

(a) Estimate an appropriate regression model with SALE as your dependent variable and CLICKS, IMPS and AvgPOS as the independent variables. Report and interpret the estimated coefficient on AvgPOS

(b) Notice that the CLICKS have a 'positive' impact on the likelihood of SALE, while AvgPOS has a 'negative' impact on the likelihood of sale. Suppose the average position occupied by an adword drops by 3 (i.e. the variable AvgPOS increases by 3). How much should the number of CLICKS increase so that the odds of getting a SALE do not change. Briefly show your working in support of your answer.

(c) We will now investigate the interaction between AvgPOS and CLICKS. Please introduce such an interaction variable in your model and estimate the model. Report and interpret the estimated coefficient on this interaction variable.

(d) Please use the estimated model (with interaction effects) from part(c) for this question.. An adword currently occupies an average position equal to 1.9 and the number of CLICKS generated by the adword are 5 Suppose the average position occupied by the adword increases by 3 (i.e. the variable AvgPOS drops from 1.9 to 4.9). By what % do the odds of getting a SALE change? Please briefly show your calculations.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

Reference materials; ducks.mwx In this EMA, you will analyse some data on the survival times of ducks described below. Some female ducks, taken from two locations in New J ersey, were captured and...

Q:

** You can use EXCEL or any other software. ** You need to include your printout in your submissions. The layout and format of the paper should include the following sections: Title page, Abstract,...

Q:

Goizueta Business School Emory University BookBinders: Predicting Response with Logistic Regression As a direct marketer of specialty books, the BookBinders Book Club has achieved steady growth in...

Q:

Name: T.A. name/Class time: MW Lecturer: Lab 11: Multiple Regression Open the lab dataset on Blackboard Learn or previously saved in SPSS. This dataset contains the data for 96 subjects. The...

Q:

I need to see the SPSS output. You need to have all z-scores, all charts, all descriptives data from SPSS, everything you used to answer the questions. I am sending you what the previous tutor sent...

Q:

10. An experimenter has some degree of control over the: a. independent variable. b. correlative variable. c. history effect. d. All of the above, if the experiment is conducted properly. 11. If a...

Q:

Business Research MethodologyQuestion Bank 1 1. When the marketing department of an organization attempts to determine the amount of time the managers in this department spend at their computers in...

Q:

Business Research Methodology- Question Bank 1 1. When the marketing department of an organization attempts to determine the amount of time the managers in this department spend at their computers in...

Q:

Abstract In this paper, the analysis will reveal a significant correlation between body weight and brain weight in various, different mammals. Introduction Talk about your other resources here. What...

Q:

ssignment you will work on datasets that are related with direct marketing campaigns (phone calls) of a Portuguese banking institution. The classification goal is to predict if the client will...

Q:

In general, what is the limitation on the deductibility of business interest expense? What happens to any business interest deduction disallowed under the limitation'

Q:

On June 10, 201X, Even Co. issued debit memorandum no. 1 for $360 to Mango Co. for merchandise returned from invoice no. 312. Your task is to journalize, record, and post this transaction as...

Q:

What is the correct order to present the following items in the income statement? Multiple Choice Other revenues and expenses, income tax expense, net income, discontinued operations Discontinued...

Q:

Question 2 4 of 3 0 . Rufus must make one payment to his ex - spouse, Debra, for the sum of $ 7 , 5 0 0 . This is the only and final payment following the end of their marriage. Is Debra required to...

Q:

Labor variances (Appendix 11.1). Assume Burgers To Go has two categories of direct labor: unskilled, which costs S6 per hour, and skilled, which costs $10 per hour. Management established standards...

Q:

Hospital supply variances (Appendix 11.1). Assume Jackson Community Hospital had the following supplies costs for two products used in its operating room. Standard costs for one surgery: Item X. 5...

Q:

Solving for materials and labor (Appendix 11.1). Western Company makes fireplace screens. Under the flexible budget, when the firm uses 75,000 direct labor hours, budgeted variable overhead is...