The google file at the bottom of this question contains regional market data on Jim's Cheesesteak sales and other economic variables. The variables are: Unit Sales (Q), Price (P), Advertising Expenditures (A), Competitors' Price (CP), Income (I), Population (P). Time (T).

A.)Regress Sales (dependent variable) linearly versus independent variables P, A, CP, I, P, T. Report your results.

B.) Based on economic theory, what signs would you expect these coefficients have? Do they have the hypothesized signs? Which of the variables are statistically significant (different from zero) at the 99 percent confidence level? Explain why.

C.) Now use this data to estimate the multiplicative form of this demand model (use the same dependent and independent variables). Report your results. Compare the statistical properties of your multiplicative model with the linear model. Which fits the data better? Explain why.

D.) What is your estimate of the price elasticity of demand (P), income elasticity of demand (I), and cross price elasticity of demand (CP) in the multiplicative model? Compare these elasticity estimates with the corresponding elasticities in the linear model when calculated at mean values for each variable.

E.)In the multiplicative model perform a statistical test to determine whether demand is elastic, competitors' price is a complement good, and if Jim's Cheesesteaks are a normal good at the 95 percent confidence level.

F.) Using the linear model forecast Jim's Steaks sales during a year in which the price (P) is $6.50, Advertising Expenditures (A) is $29,900, Competitors' Price (CP) is $6.70, Income (I) is $52,000, Population (P) is 7,300,000. Time (T) is 9. Derive a 95 percent confidence interval around this forecast.

Use the demand elasticities from your multiplicative model to analyze the impact of the following management decisions:

1. If Jim's Cheesesteak's competitor lowers price by 20 percent how will this impact Jim's sales (percentage change)? To offset this Jim's Steaks strategically cuts price by 5 percent. Does this strategy work? Explain.
2. If income increases by 20 percent how will this impact Jim's sales (percentage change)? In percentage terms how much can Jim's Steaks increase price without lowering sales below previous levels. Explain.

https://docs.google.com/spreadsheets/d/e/2PACX-1vRZ-KD9JYPEOaA1M5kQd8iJiO2d0dD6Z9Bppn0ijmYhbYtybqMoWcXVBssAwyutr2jUPco7vd9kN7KL/pubhtml

This is the google doc's for the information needed to answer the last two parts ^