Question: kindly please follow the instructions Preject Descriptien: Use a cell reference or a single formula where appropriate in order to receive full credit. Do not


Preject Descriptien: Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, as you will not receive full credit for your answers. The ice cream store Cool Stuff sells exotic ice creams, including Tropical Cream and Green Mango. Cool Stuff has been varying the prices of these two flavors over the past 12 weeks and has recorded the sales data. The table shows the quantity sold of Tropical Cream, Q, given the price of a half gallon of Tropical Cream, P, and the price of the other flavor, Green Mango, P0, Use these data on the Data worksheet to estimate the demand function for Tropical Cream. a) What is the estimated demand function? Q=P+P0 b) Are the coefficients on the two prices statistically significantly different from zero at the 5% significance level? Since the absolute value of the t-statistic for the coefficient of P equal to is than 2.262, the coefficient on P significantly different from zero. Since the absolute value of the t-statistic for the coefficient of P0 equal to is than 2.262, the coefficient on P0 significantly different from zero. c) What is R2? R2 is equal to
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
