Purpose This assignment provides an opportunity to develop, evaluate, and

 

Purpose 

This assignment provides an opportunity to develop, evaluate, and apply bivariate and multivariate linear regression models.

Resources: Microsoft Excel®, DAT565_v3_Wk5_Data_File

Instructions: 

The Excel file for this assignment contains a database with information about the tax assessment value assigned to medical office buildings in a city. The following is a list of the variables in the database:

  • FloorArea: square feet of floor space
  • Offices: number of offices in the building
  • Entrances: number of customer entrances
  • Age: age of the building (years)
  • AssessedValue: tax assessment value (thousands of dollars)

Use the data to construct a model that predicts the tax assessment value assigned to medical office buildings with specific characteristics.

  • 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?
  • Use Excel’s Analysis ToolPak to conduct a regression analysis of FloorArea and AssessmentValue. Is FloorArea a significant predictor of AssessmentValue?
  • Construct a scatter plot in Excel with Age 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?
  • Use Excel’s Analysis ToolPak to conduct a regression analysis of Age and Assessment Value. Is Age a significant predictor of AssessmentValue?

Construct a multiple regression model.

  • Use Excel’s Analysis ToolPak to conduct a regression analysis with AssessmentValue as the dependent variable and FloorArea, Offices, Entrances, and Age as independent variables. What is the overall fit r^2? What is the adjusted r^2?
  • Which predictors are considered significant if we work with α=0.05? Which predictors can be eliminated?
  • What is the final model if we only use FloorArea and Offices as predictors?
  • Suppose our final model is:
  • AssessedValue = 115.9 + 0.26 x FloorArea + 78.34 x Offices
  • What wouldbe 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?

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

DOMAIN: HISTORY 1a) Identify two (2) additional questions that were

DOMAIN: HISTORY1a) Identify two (2) additional questions that were not asked in the case stud and should have been?1b) Explain your rationale for asking these two additional questions.1c) Describe what the two (2) additional questions might reveal about the patient’s health. DOMAIN: PHYSICAL assessmentFor each system examin in this case;2a)

1) Do you support compassionate release for elderly inmates, elaborate?

1)  Do you support compassionate release for elderly inmates, elaborate?   2)  What are the factors that are important in making a decision on releasing terminally ill and/or elderly inmates?  3)  Would you date someone 20+ years older than you, explain? 4) Would you be concerned if your grandparents were

Download and read: Zamudio KR, Sinervo B (2000) Polygyny, mate-guarding,

Download and read: Zamudio KR, Sinervo B (2000) Polygyny, mate-guarding, and posthumous fertilization as alternative male mating strategies. Proc Natl Acad Sci U S A 97:14427-32. Find and download another paper on the same topic. Write 2 critical summaries, one on each paper.   Combine both critical summaries in one

sources: attached to post Give a brief review or summary

sources: attached to post Give a brief review or summary of the two articles (no more than one third of your post). Give you own reaction to the points raised in the articles. Do you agree? Disagree? Give the relevance of the author’s main points to our survey of Latin

The Picture of Dorian Gray by Oscar Wilde

Research papers will have a body of seven to ten (7-10) pages. The paper must also have an outline, and Works Cited page. (These pages are NOT considered as part of the body page count.) You will find a sample research paper, including a sample Bibliography at the Purdue OWL

Over the past two weeks, our readings and discussions have

Over the past two weeks, our readings and discussions have been focused on establishing a baseline for understanding diversity. In this module, we’ll begin our tour through the four lenses, beginning with history. As we dive into the four lenses, keep in mind that each lens is framed as a

My motor skill is: Body Management In week one you

 My motor skill is: Body Management In week one you selected a motor skill.  You’ve been working on writing a lesson plan in CAP 1 and CAP 2. Use the attached documents to write a lesson plan for your selected motor skill. Your lesson plan can look differently but needs to include

Equality for All: Gay Marriage in the African American Community

 One way to find a problem is to read a source looking for creative agreement. Chapter 6 of The Craft offers 3 different ways to activate a source in this way. 1. Offer Additional Support 2. Confirm Unsupported Claims 3. Apply a Claim more Widely Choose one of your sources

How Sustainability can be Profitable Position Paper: Plenty More Fish

In his article Plenty More Fish in the Sea, Pooley describes the problem with sustainable fish markets. Relate the model of sustainability discussed in Zencey’s Theses on Sustainability to apply to the modern fishing industry. Please submit your assignment saved in the following format; lastname_week_X. Each position paper should be

, titled “Agency’s Law and Ethics of Hiring a Diverse

, titled “Agency’s Law and Ethics of Hiring a Diverse Workforce,” in which you: Analyze at least two laws or two court decisions that have implications for the agency’s personnel management (title this section “Laws Affecting the Agency”). Evaluate the agency’s approach to diversity issues, highlighting the strengths and weaknesses

Think about the following scenario and reply to the questions

Think about the following scenario and reply to the questions below. In replying, do your best to be as honest as possible when stating your reasons. Imagine one day you hear a knock on your door. You open the door and there stands Morgan Freeman with two doctors. Freeman appears

Challenges in the Business Environment Overview Changing, or even stating,

Challenges in the Business Environment Overview Changing, or even stating, a company’s values can be a long and arduous process, but it often pales in comparison to the effort it takes to make sure they are honored, implemented and projected. In this assignment, you evaluate how well your chosen company from

Stoneman Douglas Analysis

After reviewing the On-Line Presentation for January 15, and the CNN article on Stoneman Douglas (Links to an external site.)Links to an external site., research and discuss what indicators were present regarding the shooter’s (Cruz) abnormal behavior(s). Did they warrant intervention and if so, what were they? Where was the

Use the information presented in the module folder along with

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Your reading assignments for lesson # 8 are: a. Chapters

  Your reading assignments for lesson # 8 are: a. Chapters 14 and 15 from “the Struggle for Democracy” by Drs. Greenberg and Page; b. Chapters 10 and 18 from the 9th Edition of “Democracy for the Few” by Dr. Parenti Then you must answer the following question.  Please read

Input Paper: You ARE required to reach the full word count on the

On your Draft 1: You are NOT required to reach the full word count on the paper. You should have a minimum of 2-3 full pages of writing, double-spaced (not including reference list). You should touch on each of the three questions you are writing about. You are REQUIRED to