[Solution] (31 points) Download the data on Pepsi. The file contains 1460 observations for the following series: Pepsi: A dummy variable where 1 denotes
Question: ( 31 points)
Download the data on Pepsi. The file contains 1460 observations for the following series:
Pepsi: A dummy variable where 1 denotes choice of Pepsi by the i-th customer and 0 otherwise
Price_P: The price of a 2-liter bottle of Pepsi at the time of purchase
Price_7: The price of a 2-liter bottle of 7-Up at the time of purchase
Price_C: The price of a 2-liter bottle of Coke at the time of purchase
Disp_P: A dummy variable where 1 denotes whether Pepsi was displayed at the time of purchase and 0
otherwise
The purpose of this exercise is to determine the factors that explain the choice of Pepsi over other types of colas.
- Using these data, estimate the probability (proportion) of a customer choosing Pepsi for (i) all cases; and (ii) for the cases where Pepsi is displayed. (3 points)
- Assuming that a relationship exists between choosing Pepsi as the dependent variable and the rest as the independent variables, hypothesize the signs of the β k coefficients. (4 points)
- Run 3 regressions of this relationship using a linear probability model, a logit model, and a probit model, and make a summary table including the estimated coefficients with their t/z ratios, R 2 , coming from the 3 models. (6 points)
- Calculate the proportion of correct predictions coming from the 3 models. (6 points)
- Without running a significance test, evaluate the estimated coefficients. (3 points)
- Create a second table with the transformed coefficients of the logit and probit models to make them comparable to those of the linear probability model E. (3 points)
- Using the 3 models, evaluate the probability of choosing Pepsi when Pepsi is displayed and when Pepsi is not displayed while the prices of all three drinks are equal at $1.50 per 2-liter bottle. (6 points)
Deliverable: Word Document 