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

Now, pick up from where you left off last week.

  Now, pick up from where you left off last week. Last week, you identified rapid assessment instruments that could be utilized for screening/assessing a client that has the behavioral health issue that is related to your focus topic. You will now create a biopsychosocial (spiritual) assessment template that could

Plato The Allegory of the cave

Description Summarize and respond to Plato’s The Allegory of the Cave. Organize around a strong thesis and top sentences. In this type of essay, your goal is to capture the controlling idea and the supporting details of a text, then respond by deceiving your reaction to the text . Your

Do research on the effect of COVID -19 pandemic on

 Do research on the effect of COVID -19 pandemic on this company. Answer the following questions in detail based on your research: How has the current COVID-19 pandemic aFfected the operations of this company? Do they have parts or inventory shortages? Do they have to shut down factories or warehouses?

In this assignment, you will propose a quality improvement initiative from your place of employment that could easily be implemented if approved. Assume you are presenting this program to the board fo Nursing Assignment Help

In this assignment, you will propose a quality improvement initiative from your place of employment that could easily be implemented if approved. Assume you are presenting this program to the board for approval of funding. Write an executive summary (750-1,000 words) to present to the board, from which the board

The final paper will include an assessment of a business

  The final paper will include an assessment of a business entity or organization that you are familiar with.  You will create a 10-page (minimum) double-spaced paper that includes the following: ·  Detailed analysis on how the organization applies the lessons learned in the course, including the following concepts (select those

Instructions Women, Work, and Family 1950-2000 HIST 2020 Capstone Primary

 Instructions Women, Work, and Family 1950-2000 HIST 2020 Capstone Primary Source Esay writing topic Drawing specific examples from the D2L reading “Organizing Their Lives: Women, Work, and Family, 1950-2000,” write a five (5) to seven (7) page writing explaining how second wave feminism affected American views on women in the

Hi all, I’m having difficulty with this and need help.

Hi all, I’m having difficulty with this and need help.  Here’s the Instructions and Prompt below: “Instructions- Projects that start with effective planning have a better chance of finishing strong. The creation of a good project charter will help the team coalesce around clarified objectives and will help guide the

Select an organization; once you have, describe the importance of

Select an organization; once you have, describe the importance of operations management (OM) for that organization.  You will then pick a country, or foreign market that the organization is planning to move operation into. Describe the country; completing a SWOT analysis; and describing the organization’s operations strategy for this new market.

Mini-Research Project of an Organic Molecule in Your House

 1. choose a valid organic molecule 2. contain a product figure – A picture of the product used was included with the name of the compound clearly visible. 3. have an chemical structure. 4. Was there a clear description of what product your molecule came from and why you chose

ENG 101 Academy for Five Element Acupuncture Annotation of a Research Study Essay Nursing Assignment Help

Expert Solution Preview Introduction: As a medical professor responsible for creating college assignments and evaluating medical college students, my role is to design comprehensive learning experiences that promote knowledge and critical thinking within the medical field. This involves conducting lectures, developing assignments and examinations, and providing constructive feedback to help

This forum is based on Chapter 11: Building Customer Relationships

This forum is based on Chapter 11: Building Customer Relationships Through Effective Marketing. Based on your reading, respond to the following questions:  Explain the major components of a marketing strategy that a company might use to attract customers? Be sure to reference the reading. What new information technologies are changing the ways that

this is due today within 8 hours child education read

this is due today within 8 hours  child education  read the attachment chapter 8  Answer:   Why is it important to consider the child’s perspective when designing a learning environment?  What can teachers do to make sure that their environment addresses each child’s development and learning?  make 2 references to the

INSTRUCTIONS ATTACHED Case Study # 1 You are being given

INSTRUCTIONS ATTACHED    Case Study # 1 You are being given a printed copy of background and case study information on Ted Bundy. Please read through the materials provided and then respond to the following questions on a separate sheet of paper. Your responses should be typed in 12 point

1-2 paragraphs apa format references Why is it important to

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.

Produce and publish a TEN paragraph project (a paragraph =

  Produce and publish a TEN paragraph project (a paragraph = 5-7 sentences) as a STAND-ALONE post (with a sexy title)  Thesis statement The Holocaust was a tragic incident in the history of human being that taught us very significant lessons such as the danger of silence, the importance of standing

Critical reflection on your growth and development during your practicum

Critical reflection on your growth and development during your practicum experience in a clinical setting helps you identify opportunities for improvement in your clinical skills, while also recognizing your strengths and successes. Use this Journal to reflect on your clinical strengths and opportunities for improvement, the progress you made, and