Sherri Cola Company Has Developed a Regression Model Relating Its $\alpha$

Essay

Sherri Cola Company has developed a regression model relating its sales (Y in $10,000s)with four independent variables.The four independent variables are price per unit (PRICE,in dollars),competitor's price (COMPRICE,in dollars),advertising (ADV,in $1,000s)and type of container used (CONTAIN;1 = Cans and 0 = Bottles).Part of the regression results is shown below.(Assume n = 25)

a.If the manufacturer uses can containers,his price is $1.25,advertising $200,000,and his competitor's price is $1.50,what is your estimate of his sales? Give your answer in dollars.
b.Test to see if there is a significant relationship between sales and unit price.Let $\alpha$ = 0.05.
c.Test to see if there is a significant relationship between sales and advertising.Let $\alpha$ = 0.05.
d.Is the type of container a significant variable? Let $\alpha$ = 0.05.
e.Test to see if there is a significant relationship between sales and competitor's price.Let $\alpha$ = 0.05.