Download the dataset. The data set is information about the

 Download the dataset. The data set is 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:

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

As you work through the following exercises, note your answers to the given questions so you can easily summarize them in your reflection.

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

1. Construct a scatter plot in Excel with Floor Area as the independent variable and Assessment Value as the dependent variable. Insert the bivariate linear regression equation and R2 in your graph. 

  • Do you observe a linear relationship between the 2      variables?

2. Use Excels Analysis ToolPak to conduct a regression analysis of Floor Area and Assessment Value. 

  • Is Floor Area a significant predictor of Assessment      Value?

3. Construct a scatter plot in Excel with Age as the independent variable and Assessment Value as the dependent variable. Insert the bivariate linear regression equation and R2 in your graph. 

  • Do you observe a linear relationship between the 2      variables?

4. Use Excels Analysis ToolPak to conduct a regression analysis of Age and Assessment Value. 

  • Is Age a significant predictor of Assessment Value?

Construct a multiple regression model.

  • Use Excels Analysis ToolPak to conduct a regression      analysis with Assessment Value as the dependent variable and Floor Area,      Offices, Entrances, and Age as independent variables. 
  • What is the overall fit R2? What is the adjusted R2?
  • 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 Floor Area and      Offices as predictors?
  • Suppose our final model is: Assessed Value = 115.9 +      0.26 x Floor Area + 78.34 x Offices. 
  • 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?

Reflection

In a minimum of 500 words, reflect on the types of medical offices you would advise management to close and open, and why. Use your exercise notes to support your rationale. 

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Strong opinion about false advertisement (stereotypes, manipulative,

 OP-ED 900 words i. Lead/Hook ii. Thesis/Debatable Claim iii. Counter-Argument iv. Argument v. Conclusion/Call to action B – Organizing Have you used an appropriate and effective layout? Do you use organizational structures such as subheadings, captions, title effectively? Have you followed the conventional structure of an op-ed, including: i. Lead/Hook

Confucianism, Shinto Choose one of the religious systems above; find

  Confucianism, Shinto Choose one of the religious systems above; find some point of interest to discuss  (350 wds). You may use your textbook OR any other reputable encyclopedia or source. ALWAYS CITE your source. To support your response you are required to provide at least one supporting reference with

when dealing with angry people, it is best to stay

  when dealing with angry people, it is best to stay calm and be empathic, using thoughtful, reflective statements. Other tips are to never use rebuttal, derogatory, or negative statements that may further anger the person or situation. Consider and briefly share a conflict you observed or encountered; what was

Unit 1.1 DB: Understanding How Family is Defined in Today’s

Unit 1.1 DB: Understanding How Family is Defined in Today’s Society “Family” means many things to many people. How do you define family? Think about other diverse family structures that are present in society. Discuss some of the elements that remind you of what makes it like a family. While working with individuals, why is

Easy two page assignment that provides an overview or summary

Easy two page assignment that provides an overview or summary of the provided readings, and include one outside source that relates to the topic.  A very brief, synthesized summary of the important ideas discussed in a selection of readings and a logically reasoned critique of the theoretical development, main argument

Create 3 color schemes. You will create a power point

 Create 3 color schemes.  You will create a power point presentation consisting of a total of 4 slides. A title/cover slide and one slide for each color scheme.  You should have a total of 4 slides, no more. Your colors will be to the right and a text box explaining

Conduct a google search about “Technology advancements in” the year

 Conduct a google search about “Technology advancements in” the year of your birth to select a topics for your final assignment.  Your presentation outline should explain why you selected that topic or event. If you want to report on something not listed in the year of your birth than you

Please complete the following steps to annotate and submit the

 Please complete the following steps to annotate and submit the attached reading assignment. Download the Microsoft Word file. Annotate the article. Turn on Track Changes in Microsoft Word under the Review tab first. Complete Step 1: Predict and Preview before you read. Read a paragraph and then summarize (paraphrase) it

Based on the theory of attachment, what behaviors would a

 Based on the theory of attachment, what behaviors would a nurse attempt to stimulate when working with parent to promote health attachment?   Please use APA 7th Edition. Minimum 450 words, use in text citation, with 2 scholarly references (Within 5 years).  Also include 2 replies to the same discussion post

Use the HeartDesease_DataFile.xls file as training data set and create

 Use the HeartDesease_DataFile.xls file as training data set and create a decision tree, and a Naïve Bayes Classifier in R that will predict the following records (AKA test data) for Heart Disease. For the Decision Tree section of this assignment, show your tree in R based on the training data

Choose one nursing model or conceptual framework that can guide

Choose one nursing model or conceptual framework that can guide an EBP change in either practice, education, leadership, informatics, etc. Describe the chosen model or conceptual framework for change and explain why it would create an environment of innovation and evidentiary dynamics. Discuss one (1) specific type of information technology

This assignment relates to the following Course Learning Requirements: CLR

  This assignment relates to the following Course Learning Requirements: CLR 3: Discuss what it means to conduct business ethically and responsibly. Identify programs to aid a small Canadian business achieve its responsibilities to the various stakeholders.CLR 2: Explain how events external to a business can influence business decisions, and

Strengths: What are the advantages of the technology? How will

Strengths: What are the advantages of the technology? How will it positively impact culture and society? What are other potential gains? Weaknesses: What features of the technology may hinder success? What are the limitations of the technology? How does the technology address issues of equity? Opportunities: What are external factors

Questions 1-3 are related to the Variable-Cost Contract: 1. Develop

Questions 1-3 are related to the Variable-Cost Contract: 1. Develop a descriptive model that shows, for any given demand level and any quantity ordered by Predicto, the following measures: (i) Predicto’s profit; (ii) InTech’s profit; (iii) the total profit of Predicto and InTech. In order to do so: Clearly list

Overview A good marketing plan needs to translate into quantifiable

Overview A good marketing plan needs to translate into quantifiable measures. Without such quantification, a plan will often fall apart. Thus, defining objectives and respective key performance indicators (KPIs) to measure the effectiveness of the plan is essential. Your CMO has asked you to create a strategic marketing plan and

Week 1 DiscussionDiscussion Topic Due August 18 at 11:59 PM

 Week 1 DiscussionDiscussion Topic Due August 18 at 11:59 PM Assignment 2: Discussion Assignment The discussion assignment provides a forum for discussing relevant topics for this week based on the course competencies covered. For this assignment, make sure you post your initial response to the Discussion Area by the due