multiple regression model

multiple regression model. 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 FloorAreaOfficesEntrances, 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?

Submit your assignment.

Resources

multiple regression model

Get a Quick Quote

Approximately 250 words
Total price (USD) $: 10.99

Don't Let that Essay bug you Anymore

At Online Writing Help, we get lots of students asking us, “Can you help me write my essay for me?” and for sure our answer is always a big YES! Writing a proficient essay requires quite alot in terms of :

  • Qualitative research from recent materials and research
  • Compiling valid arguments and backed up theoretical perspectives
  • Writing, editing & proofreading
  • proper citation and so much more

At Online Writing Help, we understand that writing such a paper requires more than the time, effort and an understanding of concepts learned in class. Our College Essay Help Online service incorporates all these to develop a custom written paper from scratch from our pool of professional writers. You need not fear anymore about asking us for help with essay.

How can we help with your College Essay Help Online?

Our winning strategy is founded on having a great team of writers, editors & support team. whether you need help with a discussion board assignment, responses, quiz & exam, final paper, case study and so much more, we got you covered!

The vast majority of students who seek online writing service are always enamoured due to the many benefits they can get from us. We simply make your college life easy and leave you with more time to do your other stuff like working part time. Working with homeworktutorlib.com gives you a great experience through letting off all your writing baggage.

Why Choose us?

w

24 Hour Support

Our customer support are remotey available to help with all your queries
U

Quality Essays

We have quality assurance team to ensure you get quality work. We use control tools to ensure quality work

Varied Disciplines

At homeworktutorlib.com, we do not turn down any assignment

Affordable Prices

We have competitive rates matched with quality work. We also give regular discounts for new and return clients
}

Active Writers

Our active writers are more than enough to handle all your writing needs
Z

Client Trust Score

More than 90% Return rate from our clients. We are five star rated across varied platforms
Z

Quality Assurance

We understand what your grade means and our QA team is here to ensure that for every paper