September 2023 Download the Soft Drink Consumption Excel sheet Table Below Estimate the following multiple

2024 Econ Questions Below (see Attachment) Assignment Help

Download the Soft Drink Consumption Excel sheet Table Below Estimate the following multiple 2023

Download the “Soft Drink Consumption” Excel sheet (Table Below). Estimate the following multiple regression models (remember that all of your independent variables will have to be in adjacent columns in Excel). Look at each set of results critically and consider how you would interpret the strengths and weaknesses of each model. Save your results from each model for use when completing the end-of-module assessment. C , the dependent variable, will always be “Consumption of Soft Drinks per Capita;” for independent variables, use the following specifications. (The notation f( X , Y , Z ) means “a function of X , Y , Z ; i.e., X , Y , and Z are your independent variables. Even though it isn’t listed, each model will include an intercept.) NOTE: when Excel reports a value like 2.4E-06, this is scientific notation for 2.4 * (10^-6), or 0.0000024.Model A: C = f(food services, dentists, physicians) Model B: C = f(% obese, % smokers total) Model C: C = f(% obese, % male smokers, % female smokers) Model D: C = f(% obese, % smokers total, % male smokers) Model E: C = f(mean annual temp, per capita income) Model F: C = f(mean annual temp, per capita income, physicians) Model G: C = f(mean annual temp, per capita income, dentists) Question 1 In model A, how much of the variation in soft drink consumption is explained by number of food service businesses, dentists, and physicians? Select one: a. 6.83% b. 19.2% c. 75.8% d. 24.2% Question 2 In model A, how would you interpret the coefficient for physicians? Select one: a. When the number of physicians increases by 19.2%, the amount of soft drink consumption increases by 17.2%. b. As the number of physicians per 100,000 people increases by 1, annual soft drink consumption increases by about 0.192 per year. c. As the amount of soft drink consumption increases by 1, the amount of physicians per 100,000 people increases by 0.192. d. As the number of physicians per 100,000 people increases by 0.192, the amount of soft drink consumption increases by 0.242. Question 3 In model A, the coefficient for number of food service businesses is statistically significant at the 5% level. Select one: True False Question 4 In models B through D, what seems to be the relationship between soft drink consumption and the percent who smoke? Select one: a. As the % smokers rise, soft drink consumption increases, since all of the smoking coefficients in models B-D were positive. b. It is difficult to describe the effect of smoking since the obese variable is insignificant in all models and thus tainting the validity of the results for the other variables. c. It doesn’t appear that smokers (in total) is significant in model B, but separating male vs. female (in models C & D) shows that male smokers do have a significant positive effect on soft drink consumption. d. It is difficult to draw any conclusions about male smokers because the male smoker variables were all insignificant (at the 10% level) in all models. Question 5 A state that currently has 23.5% obese adults also currently has 20% of its population who smoke (total, both male and female). The state is considering a major initiative to reduce its smoking population to 15%. If it is successful, this will also cause soft drink consumption to fall from about 160 drinks annually to about Answer drinks annually (round to nearest whole number, no decimals). Question 6 a. is shown to be positive with a relatively high degree of confidence (better than 10% significance). b. is unimportant since, even though it was statistically significant, its coefficient estimate was always smaller in absolute value than the intercept. c. is difficult to interpret because the smoker variables occasionally have a higher level of significance in some models than the obese variable. d. cannot be reliably estimated since the coefficients always exceed the 10% significance level. Question 7 Of all the variables in models E through G, mean annual temperature is the only one that is statistically significant (at the 10% level). Select one: True False Question 8 In model A, it was seen that the dentist variable was negative and significant. In model E, the dentist variable is Select one: a. still has a negative coefficient but is insignificant (at the 10% level). b. even more significant since the p-value increases. c. more important since its coefficient is less negatively related to soft drink consumption. d. is still significant but now has a positive coefficient. Question 9 While insignificant in model A, the physicians variable is significant (at the 10% level) in model F. Select one: True False

#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational