Marketing Research COURSE problem

MKT 3600 - Liu Assignment 5: Regression Analysis using Excel (100 points) In this Assignment, we will use Excel Data Analysis tools. For windows users, if you do not see 'data analysis' under the 'Data' tab, please install the option following this video. https://www.youtube.com/watch?v=_yNxLFagKgw If you are a mac user, check out this video to install the 'data analysis' add-in. https://www.youtube.com/watch?v=mtmrAXwLcuU If 'data analysis' is not available in your mac Excel version, you may want to try the XLSTAT option suggested by Microsoft https://support.office.com/en-us/article/I-can-t-find-the-Analysis-ToolPak-d678dc08-bdc2-4eda-8b9408755fa4b55a Download the data file \"Tropicana Data.xlsx\" from the Blackboard Data Overview This is a sample of 116 weekly sales of Tropicana oranges juice, prices of Tropicana, Minute Made, Domick's orange juice, and dummy variables for feature and display. We want to predict sales of Tropicana give its price, its competitor's prices and whether it is on feature or display. The data has the variables: Variable Description Week SalesTrop PriceTrop PriceMM PriceDom Feature Display The number of week in which data was collected Sales of Tropicana for that week Price of Tropicana for that week Price of Minute Maid for that week Price of Domick for that week Dummy to indicate if Tropicana was on feature in that week Dummy to indicate if Tropicana was on display in that week 1. Estimate the following model: SalesTrop = 0 + 1PriceTrop + 2PriceMM + 3PriceDom + 4Feature + 5Display + 1.1) Copy and paste the result tables from Excel here. 1.2) What is the R-squared value of this regression? 1.3) What are the p-values for the coefficients of PriceDom and Feature? How should we interpret these two coefficients based on the p-values? 1.4) What is the coefficient of PriceTrop? Is this coefficient negative? What is the p-value for this coefficient? What is the meaning of this coefficient being negative? 2. Create Log Variables and Re-run Regression Now we need to estimate the following model, log(SalesTrop) = 0 + 1log(PriceTrop) + 2log(PriceMM) + 3Display + Create the variable log(PriceTrop) and log(PriceMM). Estimate the linear regression model above. 2.1) Copy and paste the result tables from Excel here. 2.2) What is the value of the coefficient of log(PriceTrop)? How to interpret this value? Is the coefficient of log(PriceTrop) negative or positive? Why? 2.3) What is the value of the coefficient of log(PriceMM)? How to interpret it? Is the coefficient of log(PriceMM) is negative or positive? Why? 2.4) What is value of the coefficient of Display? Is this coefficient positive or negative? How would you interpret this coefficient