### Free Educational Resources

• > ESTIMATE THE FOLLOWING MULTIPLE REGRESSION MODELS
+

# ESTIMATE THE FOLLOWING MULTIPLE REGRESSION MODELS

##### Rating:
(0)
Author: Christine Farr
##### Description:

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)

(more)
##### Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial