FloorArea (Sq.Ft.) Offices Entrances Age AssessedValue ($'000) 4790 4 2 8 1796 4720 3 2 12 1544 5940 4 2 2 2094 5720 4 2 34 1968 3660 3 2 38 1567 5000 4 2 31 1878 2990 2 1 19 949 2610 2 1 48 910 5650...

The following is a list of the variables in the database:

• 
  FloorArea: square feet of floor space


• 
  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)

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