Management of Marketing Information MARK7362
Assignment #4
Due Date: Nov 8, 2021 (in class)
To ensure that you know how to do regression in both EXCEL and SPSS, some questions
specifically ask you to use EXCEL and some ask you to use SPSS.
1. Regression Application I: Forecasting sales from pre-orders using EXCEL
NOTE: You are required to use EXCEL to answer this question. Please attach EXCEL
screenshots as part of your answer.
In this question, we use the “DVD data” dataset which we went over in class. Suppose the online
retailer would like to improve the forecast for post-release DVD sales (sales3) potentially
incorporating more independent variables in additional to preorder4. Specifically, the retailer is
considering two additional variables: cumbox, which records the total box office revenue for a
movie (in units of $,000), and movdvdgap, which records the number of weeks between the
theatrical release date and the dvd release date.
(a) Run a multiple regression with ln(sale3) as the dependent variable, with ln(preorder4) and
