Run Regression

 
Adam’s Pizza operates in six cities in Texas and Oklahoma. The owner, Mr. Jenkins, wants to have an empirical estimation of the demand for his pizza. He plans to formulate pricing and promotion decisions for the next year, and he wants to know how price and advertising expenditure affect sales and use the results of the estimation to make a forecast for the next year (2015-1). He hired an economist to do a regression analysis. The economist collected data for 2013-1-2014-4 (quarterly) for sales, price, competitor’s price, income, and population. This data is available in Table 1 (link provided below).
The following regression model was fit to the collected data:

where Px is the price of pizza, Py is the competitor’s price, A is advertising expenditure, Y is income, Pop is population, T is trend, and is a residual or error term. Least square regression results based on the data are provided in Table 2 (link provided below).
Write a report on the findings of the regression. Include the following elements in your report:

Describe the economic meaning and statistical significance of each independent variable.
Interpret the coefficient of determination (R2).
Use a regression model and 2014 data to estimate 2015-1 sales.
Derive 95% and 99% confidence intervals for the 2015-1 estimate.

Your report must be a minimum of 2 pages in length.