The Kentucky Department of Agriculture is concerned about the number of acres of farmland being withdrawn from farming. The department would like to propose new legislation to prevent this but wants to show the legislature what would happen if it does not act. Drew Johnson, the department’s statistician, regresses the number of acres used for farming in the state on time. Johnson finds the following: Model R R Square Adjusted R Square Std. Error of the Estimate 1 .943a .890 .795 3.2875 Predictors: (Constant), Number of Years Model Sum of Squares df Mean Square F Sig. 1 Regression 1378.458 1 1378.458 141.149 .000a Residual 478.567 49 9.766 9.766 Total 1857.025 50 Predictors: (Constant), Number of Years Dependent Variable: Acres (in Millions) Unstandardized Standardized B Std. Error Beta t Sig. 1 constant 2.743 .357 7.683 .000 year -.027 .0007 -.025 -38.571 .000 Dependent Variable: Acres (in Millions) What is the IV? What is the DV? How strong is the relationship? From the results shown above, write the regression equation. How many acres of farmland will be lost in the next 10 years if the legislature does not act and if past practices continue?
The Kentucky Department of Agriculture is concerned about the number of acres of farmland being withdrawn from farming. The department would like to propose new legislation to prevent this but wants to show the legislature what would happen if it does not act. Drew Johnson, the department’s statistician, regresses the number of acres used for farming in the state on time. Johnson finds the following:
Model |
R |
R Square |
Adjusted R Square |
Std. Error of the Estimate |
1 |
.943a |
.890 |
.795 |
3.2875 |
Predictors: (Constant), Number of Years
Model |
|
Sum of Squares |
df |
Mean Square |
F |
Sig. |
|
1 |
Regression |
1378.458 |
1 |
1378.458 |
141.149 |
.000a |
|
|
Residual |
478.567 |
49 |
9.766 |
9.766 |
|
|
|
Total |
1857.025 |
50 |
|
|
|
|
Predictors: (Constant), Number of Years
Dependent Variable: Acres (in Millions)
|
Unstandardized |
|
Standardized |
|
|
|
B |
Std. Error |
Beta |
t |
Sig. |
1 constant |
2.743 |
.357 |
|
7.683 |
.000 |
year |
-.027 |
.0007 |
-.025 |
-38.571 |
.000 |
Dependent Variable: Acres (in Millions)
What is the IV? What is the DV? How strong is the relationship?
From the results shown above, write the regression equation.
How many acres of farmland will be lost in the next 10 years if the legislature does not act and if past practices continue?
Trending now
This is a popular solution!
Step by step
Solved in 3 steps