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

The student will create a PowerPoint presentation consisting of 9

The student will create a PowerPoint presentation consisting of 9 slides(excluding the cover page and reference) which will allow them to demonstrate a developing sense of themselves as learners. FirstStudents build on prior experiences and how those experiences led to an understanding of self, others, and program content (Slides 1,

Assignment: A document titled “Evaluating Data Elements” is available to

  Assignment: A document titled “Evaluating Data Elements” is available to you in Document Sharing. This document provides a summary of a dissertation study conducted by an alumnus of UoF. Review the summary of the research and the adaptation of the survey instrument that was developed for the study. For this

Assess the strengths and weaknesses of authoritarianism

Essay topic : Who should rule? Assess the strengths and weaknesses of authoritarianism OR democracy (choose one of the two) . Use examples (not only China and Singapore). •Be careful about your existing assumptions. •E.g. About the benevolent role of the state, about the superiority of democracy. •You need to

First Exercise – Chapter 7 – List the keys to

    First Exercise – Chapter 7 – List the keys to using return on investment (ROI) successfully in the pursuit of profit and channel effectiveness.  Second Exercise – Chapter 8 – How do you position a product or service so that it is differentiated from products or services of

Using 2 motivation theories, explain some of the reasons behind the

INTRODUCTION TO OB: CASE STUDY Birmingham Fitness Gym (BFGym) is a medium-sized gym that is very popular among the residents of Birmingham City Centre. The gym has an excellent location right at the heart of the city and is reputable for its friendly staff and amiable atmosphere. The gym consists

DISCUSSION 1-1 In response to at least two of your

DISCUSSION 1-1  In response to at least two of your peers, address the following: Suggest relevant strategies and techniques for your peers to use that you learned about in the module resources, making sure to use APA style citations to cite your source(s). Elaborate on the general value and impact

WIM’s transition to ERP Welding Industries Malaysia (WIM) is the

  WIM’s transition to ERP Welding Industries Malaysia (WIM) is the only local Malaysian company that manufactures welding machines for commercial use. WIM’s remarkable success story, which includes surviving the 1997/8 financial crisis and the rise of competition from China, is attributable to the very effective enterprise resource planning (ERP)

Read and summarize chapter 25 of Biz Law in at

 Read and summarize chapter 25 of Biz Law in at least 300 words.    25.1 Award of DamagesThe  law  on  remedies  for  breach  of  contract  is  contained  in  both  the  common  law  and  under  Statute  to  provide  the  particular  remedy  of  damages  and  determining  the  award  of  damages.  Irrespective  of

Learning Goal: I’m working on a writing discussion question and

 Learning Goal: I’m working on a writing discussion question and need an explanation and answer to help me learn. check the attachment Requirements: 500-800 words no questions at all. I’ve attached all the documents. It should be between 500-800 words (Critical Summary)the topic is as follows“To Be or Not to Be

Introduce yourself to the class and me by answering this

  Introduce yourself to the class and me by answering this question: Imagine what your life would be like if there was no local or state government. Better? Worse? The same? Do we need local and state governments when we have a national government?  Write at least 250 words explaining your

Watch a recording of a previous meeting, a Planning Commission

Watch a recording of a previous meeting, a Planning Commission meeting in the San Diego, California jurisdiction.  USE THE TEMPLATE*Respond thoroughly and thoughtfully to each of the questions, in order, as set out in the template. I am looking for you to demonstrate that you understand how the actions and

Research Poster Non-communicable diseases (NCDs) not only lead the way

Research Poster  Non-communicable diseases (NCDs) not only lead the way with respect to mortality rates at a global level but also account for the majority of deaths in high-income countries. According to Bashir (2021), the most common causes of death in Saudi Arabia are ischemic heart disease, road injuries, stroke,

FIU Individualism vs Collectivism Discussion Nursing Assignment Help

I’m studying for my Health & Medical class and need an explanation. Take the quiz: Individualism vs. Collectivism Quiz: How Do You See Your Role in Society? (Links to an external site.) Where do you stand on the individualist / collectivist continuum, based on your scores? Why do you think

Seven to ten literature reviews on; What issues do mentally

Seven to ten literature reviews on; What issues do mentally ill prisoners face upon release; what the Harris Center offer/assist with the needs of prisoners upon release; What other states or countries participate in programs or services to assist with mentally ill offenders upon release; And what are the programs;