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.