The accounting department began extending its historical records by recording the sales volume for each month over the past four years, starting in January. The company engages in various kinds of direct to consumer advertising and, until recently, has never studied the effect its advertising dollars have on sales, although some data had also been collected. Their hope was that after several months the collected data could be examined to possibly reveal any relationships that would help in future advertising expenditures.The accounting department besides extending its historical records by recording the sales volume for each month, they also collected advertising dollars for both magazine and TV spots. They also recorded both these values lagged one and two months. This was done because some people on the executive committee thought that sales might lag advertising expenditures rather than respond in the month the ads appeared. It was also believed that sales experienced a seasonal effect and management further wondered about any trend in the sales volume. Finally, it was believed that Alomegas advertising dollars might have an effect on its major competitors advertising budgets the following month. For each following month it was decided that competitors advertising could be classified as: (1): little; (2): a moderate amount, or; (3): a great amount. After a few months of data collection and analysis of past records, the accounting department completed an Excel file using the following variables:Sales dollars, Magazine advertising dollars, TV advertising dollars. Compete - competitors advertising efforts, Weak, Moderate, and Strong.Build a regression model with only the causal variables (hint Independent variables), paper advertising, tv advertising, and competitors advertising (compete).

Build a regression model with only the causal variables (hint Independent variables), paper advertising, tv advertising, and competitors advertising (compete).