Wk 5 – Apply: Regression Modeling [due Mon] Wk 5 – Apply: Regression Modeling

  Assignment Content Purpose  This assignment provides an occasion to eliminate, evaluate, and apportion bivariate and multivariate rectirectirectirectidirect retrogradation examples. Resources: Microsoft Excel®, DAT565_v3_Wk5_Data_File Instructions: The Excel refine for this assignment contains a groundsbase delay notification about the tax rate appraise assigned to medical employment erections in a city. The forthcoming is a inventory of the shiftings in the groundsbase: FloorArea: balance feet of foot space Offices: reckon of employments in the erection Entrances: reckon of customer entrances Age: age of the erection (years) AssessedValue: tax rate appraise (thousands of dollars) Use the grounds to erect a example that predicts the tax rate appraise assigned to medical employment erections delay particular characteristics. Construct a disseminate frame in Excel delay FloorArea as the refractory shifting and AssessmentValue as the subject shifting. Insert the bivariate rectirectirectirectidirect retrogradation equation and r^2 in your graph. Do you watch a rectirectirectirectidirect connection between the 2 shiftings? Use Excel’s Decomposition ToolPak to convoy a retrogradation decomposition of FloorArea and AssessmentValue. Is FloorArea a weighty predictor of AssessmentValue? Construct a disseminate frame in Excel delay Age as the refractory shifting and AssessmentValue as the subject shifting. Insert the bivariate rectirectirectirectidirect retrogradation equation and r^2 in your graph. Do you watch a rectirectirectirectidirect connection between the 2 shiftings? Use Excel’s Decomposition ToolPak to convoy a retrogradation decomposition of Age and Rate Value. Is Age a weighty predictor of AssessmentValue? Construct a multiple retrogradation example. Use Excel’s Decomposition ToolPak to convoy a retrogradation decomposition delay AssessmentValue as the subject shifting and FloorArea, Offices, Entrances, and Age as refractory shiftings. What is the overall fit r^2? What is the adjusted r^2? Which predictors are considered weighty if we exertion delay α=0.05? Which predictors can be eliminated? What is the developed example if we singly use FloorArea and Offices as predictors? Suppose our developed example is: AssessedValue = 115.9 + 0.26 x FloorArea + 78.34 x Offices What wouldbe the assessed appraise of a medical employment erection delay a foot area of 3500 sq. ft., 2 employments, that was built 15 years ago? Is this assessed appraise congruous delay what appears in the groundsbase? Submit your assignment.  Resources Center for Writing Excellence Reference and Citation Generator Grammar and Writing Guides