DAT 565 University of Phoenix Week 5 Regression Modeling Paper

Instructions: This assignment must be submitted as a Single Sheet Excel document! 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

1. 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?

Note: To write the verbiages of your assignment, please use a single text box on the excel page and type your responses. Please see the example I attached below. If you have any questions, please ask not in a private message but in the course question section because my response to your question may help other students also.
Submit your assignment by following the guidance below. 

Save it in your local drive with your first name-last name-week-5 assignment. Please do not type any extensions (such as XLSX or XLS, etc.). The system will automatically add the extension. (10 points)

Please make sure that you answered all 4 questions in this worksheet. (each question is worth 10 points total of 40 points)

Please follow the example I provided for the week 5 assignment and submit it as a single Excel page with the exact structure shown in the examples. (10 deductions for failure to the structure)

Upload the document.

Once uploaded, please open the document from your submission to make sure that this is the document you wanted to submit. Because once I grade the assignment, you cannot resubmit the assignment for a higher grade.

Point distribution for this assignment: each of the questions has 8 points a total of 4*10 = 40 points, and failure to comply, with the format, has a deduction of (10 points). If you do not want to lose unnecessarily any points, please carefully follow the above instructions. The purpose of this assignment is for you to show and as a manager, you can use Excel proficiently to do data analysis. For that reason, if this assignment is submitted in any format other than Excel; it will automatically earn 0.