Surname 1
DAT 565 WEEK 5 REGRESSION MODELING
Student’s Name
Institutional Affiliation
Professor’s Name
Date
Wk 5 - Apply: Regression Modeling [due Mon] Wk 5 - Apply: Regression Modeling
1) Construct a scatter plot in Excel with FloorArea as the independent variable
and AssessmentValue as the dependent variable. Insert the bivariate linear
regression equation and r^2 in your graph. Do you observe a linear
relationship between the 2 variables?
AssessedValue ($'000)
2500
2000
f(x) = 0.31 x + 162.66
R² = 0.94
1500
1000
500
0
0 1000 2000 3000 4000 5000 6000 7000
Yes, a linear relationship is observable between Floor Area and Assessment Value.
DAT 565 WEEK 5 REGRESSION MODELING
Student’s Name
Institutional Affiliation
Professor’s Name
Date
Wk 5 - Apply: Regression Modeling [due Mon] Wk 5 - Apply: Regression Modeling
1) Construct a scatter plot in Excel with FloorArea as the independent variable
and AssessmentValue as the dependent variable. Insert the bivariate linear
regression equation and r^2 in your graph. Do you observe a linear
relationship between the 2 variables?
AssessedValue ($'000)
2500
2000
f(x) = 0.31 x + 162.66
R² = 0.94
1500
1000
500
0
0 1000 2000 3000 4000 5000 6000 7000
Yes, a linear relationship is observable between Floor Area and Assessment Value.
