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(% obese, dentists, physicians)
Model B: C = f(food services, % smokers total)
Model C: C = f(food services, % male smokers, % female smokers)
Model D: C = f(food services, % smokers total, % male smokers)
Model E: C = f(per capita income, mean annual temp)
Model F: C = f(mean annual temp, % obese, dentists, food services, % male smokers)
Model G: C = f(mean annual temp, % obese, dentists, food services, % smokers total)