In the Fall of 2011, data was collected for 30 randomly selected apartments in the San Diego area in an attempt to determine the major determinants of rent prices. The group collecting the data believe that rent price is determined by apartment size in square feet, existence of a tennis court(s) in the complex and the existence of gated security for the complex. Complete the following steps:
1. Use Excel to construct an (xy) scatterplot for y=Rent versus x=Square Feet. Put the scatterplot in a new worksheet. Be sure to provide a meaningful title and informative axis labels.
2. Regress the dependent variable rent on the independent variables square feet, tennis court, gated security. Put your regression output in the designated area of the worksheet "Data." Use the regression output to answer problems a - e below:
a. Type the estimated regression function. y-hat = estimated monthly rent.
b. What percentage of the total variability in monthly rent is describeed by the variability in the square feet, tennis court(s) and gated security variables?
c. What is the observed significance level of the estimated regression model?
d. For the given sample of apartments, what is the average value of an additional square foot of apartment space?
e. What value from the printout measures the observed level of significance for the variable "gated security", in the regression model?