• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
  • 4.6 TrustPilot
0
Sell
Where do you study
Your language
Start selling Create your account
  • University Of The Cumberlands
  • GENERAL BI 200
To add items to your wishlist, you must be logged in
Document preview thumbnail
Preview 1 out of 6 pages
Exam (elaborations)

DAT 565 WEEK 5 REGRESSION MODELING

0.0
(0 reviews)
- sold
6 pages
2021/2022 Written for academic year
Institution
University Of The Cumberlands
Course
GENERAL BI 200
Document preview thumbnail
Preview 1 out of 6 pages

DAT 565 WEEK 5 REGRESSION MODELING 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? Which predictors are considered significant if we work with α=0.05? Which predictors can be eliminated? Floor Area and Offices are significant predictors. Entrances and Age can be removed from the model. What is the final model if we only use FloorArea and Offices as predictors? What would be the assessed value of a medical office building with a floor area of 3500 sq. ft., 2 offices, that was built 15 years ago? Is this assessed value consistent with what appears in the database?

Content preview

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.

Document information

Uploaded on
January 19, 2022
Number of pages
6
Written in
2021/2022
Type
Exam (elaborations)
Contains
Questions & answers
Report Copyright Violation
$10.99
Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF
Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
Smartsolutions
3.9
(520)
Sold
2968
Followers
2545
Items
1165
Last sold
1 month ago

Browse related subjects

Subjects

  • dat 565 week 5 regression modeling
  • construct a scatter plot in excel with floorarea as the independent variable and assessmentvalue as the dependent variable insert the bivariate linear regression eq

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Learn more Create citation
Working on your references?

Frequently asked questions