\n

\n Purpose\n <\/p>\n

\n This assignment provides an opportunity to develop, evaluate, and apply bivariate and multivariate linear regression models.\n <\/p>\n

\n Resources:Template attached\n <\/p>\n

\n Instructions:\n <\/p>\n

\n 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:\n <\/p>\n

\n
• \n FloorArea: square feet of floor space\n <\/li>\n
• \n Offices: number of offices in the building\n <\/li>\n
• \n Entrances: number of customer entrances\n <\/li>\n
• \n Age: age of the building (years)\n <\/li>\n
• \n AssessedValue: tax assessment value (thousands of dollars)\n <\/li>\n<\/ul>\n

  \n Use\u00a0the data to construct a model that predicts the tax assessment value assigned to medical office buildings with specific characteristics.\n <\/p>\n

  \n
  • \n Construct a scatter plot in Excel with\u00a0FloorArea\u00a0as the independent variable and\u00a0AssessmentValue\u00a0as 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?\n <\/li>\n
  • \n Use Excel\u2019s Analysis ToolPak to conduct a regression analysis of\u00a0FloorArea\u00a0and\u00a0AssessmentValue. Is\u00a0FloorArea\u00a0a significant predictor of\u00a0AssessmentValue?\n <\/li>\n
  • \n Construct a scatter plot in Excel with\u00a0Age\u00a0as the independent variable and\u00a0AssessmentValue\u00a0as 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?\n <\/li>\n
  • \n Use Excel\u2019s Analysis ToolPak to conduct a regression analysis of Age and Assessment Value. Is\u00a0Age\u00a0a significant predictor of\u00a0AssessmentValue?\n <\/li>\n<\/ul>\n

    \n Construct\u00a0a multiple regression model.\n <\/p>\n

    \n
    • \n Use Excel\u2019s Analysis ToolPak to conduct a regression analysis with\u00a0AssessmentValue\u00a0as the dependent variable and\u00a0FloorArea,\u00a0Offices,\u00a0Entrances, and\u00a0Age\u00a0as independent variables. What is the overall fit r^2? What is the adjusted r^2?\n <\/li>\n
    • \n Which predictors are considered significant if we work with \u03b1=0.05? Which predictors can be eliminated?\n <\/li>\n
    • \n What is the final model if we only use\u00a0FloorArea\u00a0and Offices as predictors?\n <\/li>\n
    • \n Suppose our final model is:\n <\/li>\n
    • \n AssessedValue\u00a0= 115.9 + 0.26 x\u00a0FloorArea\u00a0+ 78.34 x\u00a0Offices\n <\/li>\n
    • \n 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?\n <\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

      Purpose This assignment provides an opportunity to develop, evaluate, and apply bivariate and multivariate linear regression models. Resources:Template attached 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: […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_joinchat":[]},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/286309"}],"collection":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/comments?post=286309"}],"version-history":[{"count":0,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/286309\/revisions"}],"wp:attachment":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/media?parent=286309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/categories?post=286309"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/tags?post=286309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}