THIS IS 1 QUESTION. PLEASE ANSWER ALL. THANKS

The Pilot Pen Company has decided to use 15 test markets to examine the sensitivity of demand for its new product to various prices, as shown in the following table. Advertising effort was identical in each market. Each market had approximately the same level of business activity and population. Complete the following worksheet and then estimate the demand function for Pilot's new pen using a linear regression model. What is the standard error of the estimate (se)? 1.567 1.618 104.776 0.028 0.029 1.890 Can you reject the hypothesis (at the 0.05 level of significance) that there is no relationship (i.e., =0 ) between the price and quantity variables? (Hint: t0.025,13=2.16) Yes No Complete the following worksheet and then use it to calculate the coefficient of determination. The coefficient of determination (r2) is What is the price elasticity of demand at a price of 50 cents? 0.46 0.03 0.50 0.02 The Pilot Pen Company has decided to use 15 test markets to examine the sensitivity of demand for its new product to various prices, as shown in the following table. Advertising effort was identical in each market. Each market had approximately the same level of business activity and population. Complete the following worksheet and then estimate the demand function for Pilot's new pen using a linear regression model. What is the standard error of the estimate (se)? 1.567 1.618 104.776 0.028 0.029 1.890 Can you reject the hypothesis (at the 0.05 level of significance) that there is no relationship (i.e., =0 ) between the price and quantity variables? (Hint: t0.025,13=2.16) Yes No Complete the following worksheet and then use it to calculate the coefficient of determination. The coefficient of determination (r2) is What is the price elasticity of demand at a price of 50 cents? 0.46 0.03 0.50 0.02