Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following table gives the quantity demanded of ice cream (Cic) in kgs per year in Sardinia (Italy), its price (Pic) in $ per kg,

image text in transcribedimage text in transcribed

The following table gives the quantity demanded of ice cream (Cic) in kgs per year in Sardinia (Italy), its price (Pic) in $ per kg, consumers' income (1) in $, the temperature (T) in Celsius, and the price of cappuccino (Pc) in $ per kg: Year Dic Pic ($/kg) I ($) T Pc (S/kg) 2000 72000 11 2000 20 14 2001 81000 10 2100 24 15 2002 90000 9 2200 25 15 2003 99000 7 2305 26 16 2004 108000 6 2407 30 17 2005 126000 4 2500 32 18 2006 117000 7 2610 26 16 2007 117000 8 2698 25 16 2008 35000 2801 31 18 2009 135000 2921 31 18 2010 144000 3000 34 20 2011 180000 3099 36 21 UN 2012 162000 3201 33 19 2013 171000 4 3308 35 21 2014 153000 3397 30 BT 2015 180000 W 3501 35 22 2016 171000 4 3689 33 20 2017 180000 3 3800 36 23 2018 98000 2 3896 36 25 2019 189000 4 3989 34 23 2020 175000 6 3600 30 18Based on the data provided in the table: USE MICROSOFT EXCEL FOR DATA ANALYSIS Given the nature of the problem, which would be the dependent variable and which would be the independent variables? Using the regression facility in Excel, determine the estimated regression line using a linear multiple regression. Does this model t 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. Using the regression facility in Excel, determine the estimated regression line using a nonlinear multiple regression. Does this model t the data? Why? If it does, please write the estimated equation. Please, attach the page of the regression analysis output. 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 signicance of each of the independent variables. Based on the best model, how much is the coefcient of determination? What does it mean? For the best model, what does the F-test result tell us? Interpret the coefficients of the independent variables based on the best model. Also, describe the demand for ice cream with respect to Pic, 1, T and indicate the relationship between ice cream and cappuccino. Determine the point estimate of the demand for ice cream, based on the best regression model, given that the Pic = $1 Mtg, I = $4, 000, T = 30 Celsius, and Pa = $20/l'cg. 10. Then, construct an approximate 95 percent confidence level prediction interval of the demand for ice cream. 11. If you know that the Durbin Watson statistic for the data of this case study is 1. 609, what can you conclude about the possibility of aurocorrelation

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mining And The State In Brazilian Development

Authors: Gail D Triner

1st Edition

1317323580, 9781317323587

More Books

Students also viewed these Economics questions

Question

5. How quickly can we manage to collect the information?

Answered: 1 week ago

Question

3. Tactical/strategic information.

Answered: 1 week ago

Question

3. To retrieve information from memory.

Answered: 1 week ago