Week 7 tests.docx - Question 1 of 20 0.0/ 1.0 Points Due to...

Question 1 of 20
0.0/ 1.0 Points
Due to erosion, a river shoreline is losing several thousand pounds of soil each year. A linear
equation that expresses the total amount of soil lost per year is y = 12,000x.
How many pounds of soil does the shoreline lose in a year? Round to a whole number. Don't use
any commas or decimals.
Question 2 of 20
1.0/ 1.0 Points
Which of the following equations are linear?

D.
y-x=8x
2
Answer Key:B
Feedback:
A linear equation is a linear line. If a problem has a squared or a cubed term, it isn't linear. It is a
quadratic equation.
Part 2 of 9 - Multiple Linear Regression 3.0/ 4.0 Points
Question 3 of 20
1.0/ 1.0 Points
With Obesity on the rise, a Doctor wants to see if there is a linear relationship between the Age
and Weight and estimating a person's Systolic Blood Pressure. Interpret the slope(s) of the
significant predictors for Systolic BP (if there are any).
See Attached Excel for Data.
BP data.xlsx 9 KB

A.
When you hold Weight constant, as Age increases by 1 year, your Systolic BP will
increase by 0.9388
When you hold Age constant, as Weight increases by 1 pound, your Systolic BP will
increase by 0.3092

B.
When you hold Weight constant, as Age increases by 1 year, your Systolic BP will
increase by 4.0792
When you hold Age constant, as Weight increases by 1 pound, your Systolic BP will

Feedback:
You can run a Multiple Linear Regression in Excel using the Data Analysis ToolPak.
Data -> Data Analysis -> Scroll to Regression
Highlight Systolic BP for the Y Input:
Highlight Both Age and Weight columns for the X Input:
Make sure you click on Labels and Click OK
If done correctly then you look under the Coefficients for the values to write out the Regression
Equation
Coefficients
Intercept 31.73252234
Age in Yrs. 0.938835263
Weight in lbs. 0.309246373
Systolic BP = 31.73252234 + 0.938835263(Age) + 0.309246373(Weight)
You need to interpret the slope coefficients for all significant predictors.
When you hold Weight constant, as Age increases by 1 year, your Systolic BP will increase by
0.9388
When you hold Age constant, as Weight increases by 1 pound, your Systolic BP will increase by

0.3092