5. Allot: Retirement 

Provision Content

Purpose 

This provision provides an opening to unravel, evaluate, and allot bivariate and multivariate straight retirement types.

Resources: Microsoft Excel®, DAT565_v3_Wk5_Data_File (Attached)

Instructions: 

The Excel smooth restraint this provision contains a postulatesbase with instruction environing the toll toll esteem assigned to medical service erections in a city. The aftercited is a register of the changeables in the postulatesbase:

  • FloorArea:       square feet of floor space
  • Offices:       number of services in the erection
  • Entrances:       number of customer entrances
  • Age:       age of the erection (years)
  • AssessedValue:       toll toll esteem (thousands of dollars)

Use the postulates to compose a type that predicts the toll toll esteem assigned to medical service erections with local characteristics.

  • Compose a strew conspire in Excel with FloorArea as the defiant changeable and AssessmentValue as the hanging changeable. Insert the bivariate straight retirement equation and r^2 in your graph. Do you remark a straight harmony betwixt the 2 changeables?
  • Manifestation Excel’s Decomposition ToolPak to influence a retirement decomposition of FloorArea and AssessmentValue. Is FloorArea a suggestive predictor of AssessmentValue?
  • Compose a strew conspire in Excel with Age as the defiant changeable and AssessmentValue as the hanging changeable. Insert the bivariate straight retirement equation and r^2 in your graph. Do you remark a straight harmony betwixt the 2 changeables?
  • Manifestation Excel’s Decomposition ToolPak to influence a retirement decomposition of Age and Toll Esteem. Is Age a suggestive predictor of AssessmentValue?

Compose a multiple retirement type.

  • Manifestation Excel’s Decomposition ToolPak to influence a retirement decomposition with AssessmentEsteem as the hanging changeable and FloorArea, Offices, Entrances, and Age as defiant changeables. What is the overall comport r^2? What is the adjusted r^2?
  • Which predictors are considered suggestive if we is-sue with α=0.05? Which predictors can be eliminated?
  • What is the decisive type if we solely manifestation FloorArea and Services as predictors?
  • Suppose our decisive type is:
  • AssessedValue = 115.9 + 0.26 x FloorArea + 78.34 x Offices

What would be the assessed esteem of a medical service erection with a floor area of 3500 sq. ft., 2 services, that was built 15 years since? Is this assessed esteem consonant with what appears in the postulatesbase? 

~~~For this or similar assignment papers~~~