The file problem5.xlsx contains data from a campaign run by a retailer for a period of 1 month. The retailer "bought" a set of adwords from Google and monitored the performance of those adwords over this time period.

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

HERE IS THE DATA NEEDED TO ANSWER THE QUESTION

https://docs.google.com/spreadsheets/d/1k-C2-n8z4c22_L9bjkSq44AfxJBHEke-iwuD-ZYG_E0/edit?usp=sharing

(a) (3 pts) 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) (5 pts) 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) (3 pts) 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) (6 pts) 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.