Question
The following table gives the quantity demanded of ice cream (Qic) in kgs per year in Sardinia (Italy), its price (Pic) in $ per kg,
The following table gives the quantity demanded of ice cream (Qic) in kgs per year in Sardinia (Italy), its price (Pic) in $ per kg, consumers' income (I) in $, the temperature (T) in Celsius, and the price of cappuccino (Pc) in $ per kg Based on the data provided in the table: (A) Given the nature of the problem, which would be the dependent variable and which would be the independent variables? (B) Using the regression facility in Excel, determine the estimated regression line using a linear multiple regression. Does this model fit the data? If it does, please write the estimated equation. If not, what do you think the problem might be? How do you know? Please, attach the page of the regression analysis output. (C) Using the regression facility in Excel, determine the estimated regression line using a nonlinear multiple regression. Does this model fit the data? Why? If it does, please write the estimated equation. Please, attach the page of the regression analysis output. (D) Based on the best model, test the hypothesis that there is no relationship between the demand for ice cream and each one of the independent variables. Also, indicate the statistical significance of each of the independent variables. (E) Based on the best model, how much is the coefficient of determination? What does it mean? (F) For the best model, what does the F-test result tell us? (G) Interpret the coefficients of the independent variables based on the best model. (H) Also, describe the demand for ice cream with respect to Pic, I, T and indicate the relationship between ice cream and cappuccino. (I) Determine the point estimate of the demand for ice cream, based on the best regression model, given that the Pic = $10/kg , I = $4,000, T = 30 Celsius, and Pc = $20/kg. (J) Then, construct an approximate 95 percent confidence level prediction interval of the demand for ice cream. (K) If you know that the Durbin-Watson statistic for the data of the this case study is 1.609, what can you conclude about the possibility of autocorrelation?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started