# Dat 565 week 5 assignment apply regression modelling

Wk 5 – Apply: Regression Modeling [due Mon]

## Assignment Content

1.

Purpose

This assignment provides an opportunity to develop, evaluate, and apply bivariate and multivariate linear regression models.

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:

o FloorArea: square feet of floor space

o Offices: number of offices in the building

o Entrances: number of customer entrances

o Age: age of the building (years)

o 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.

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

o Use Excel’s Analysis ToolPak to conduct a regression analysis of FloorArea and AssessmentValue. Is FloorArea a significant predictor of AssessmentValue?

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

o 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.

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

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

o What is the final model if we only use FloorArea and Offices as predictors?

o Suppose our final model is:

o AssessedValue = 115.9 + 0.26 x FloorArea + 78.34 x Offices

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

Calculate the price
Pages (550 words)
\$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Australia Assessments
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Military
Good job
Customer 456821, January 11th, 2023
Nursing
Excellent work!!!
Customer 453939, June 16th, 2020
Military
very good job
Customer 456821, August 3rd, 2022
Education
Excellent.
Customer 452441, April 19th, 2022
Science
Good one.
Customer 453625, May 21st, 2022
SEO
good
Customer 463813, March 8th, 2023
English 101
Good work.
Customer 453625, May 25th, 2022
Other
The PowerPoint Presentation is PHENOMENAL! The writer went above and beyond my expectations! Thank you so much.
Customer 452455, February 15th, 2023
Human Resources Management (HRM)
Excellent combination.
Customer 462485, April 3rd, 2022
Law
good job
Customer 452741, March 27th, 2020
Film & Theater studies
Good work.
Customer 462687, July 4th, 2022
Nursing
Excellent paper!
Customer 454007, June 8th, 2020
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend