What would be the assessed value of a medical office

Assignment Help Accounting Basics

Reference no: EM132640316

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.

Question 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?

Question 2: Use Excel's Analysis ToolPak to conduct a regression analysis of FloorArea and AssessmentValue. Is FloorArea a significant predictor of AssessmentValue?

Question 3: 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?

Question 4: Use Excel's Analysis ToolPak to conduct a regression analysis of Age and Assessment Value. Is Age a significant predictor of AssessmentValue?

Question 5: Construct a multiple regression model.

Question 6: 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?

Question 7: Which predictors are considered significant if we work with α=0.05? Which predictors can be eliminated?

Question 8: 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

Question 9: 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?

Attachment:- ToolPak.zip

Reference no: EM132640316

Questions Cloud

Is tommy behaving ethically and explain : The company's internal audit department determined that an important internal control. Is Tommy behaving ethically? Why or why not?

Contrast the leadership of two leaders steve jobs : 1. Compare and contrast the leadership of two leaders Steve Jobs

What are two types of value-based pricing methods : What are two types of value-based pricing methods? How would you describe them, and for what types of products would these pricing methods be good?

Provisions of family and medical leave act : Describe the requirements and provisions of the Family and Medical Leave Act. What are the pros and cons of high executive pay?

What would be the assessed value of a medical office : 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?

Interview with entrepreneur essay : Asks quality questions (examples below) to capture the entrepreneur's journey. Why the entrepreneur is passionate about the product/service

Identify the type of auditor report : You are required to: Identify the type of auditor's report to be issued for each of the above situations

Mass customization of products : Mass customization of products has become a common approach in manufacturing organizations. How can/should a biblical worldview be applied?

What are the dangers of implementing this strategy : The normal selling price of the product is $173.00 per unit. What are the dangers of implementing this strategy

User Account

All Pages