What percentage of the total variability in monthly rent is

Reference no: EM13473122

In the Spring of 2013, 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 questions 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 explained 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? (3 points) e. What value from the printout measures the observed level of significance for the variable "gated security", in the regression model?

Reference no: EM13473122

Questions Cloud

Write down a 1-page memo to your companys top management : write a 1-page memo to your companys top management explaining the implementation process for transferring appropriate

The aliens said certain number of humans could tour their : the aliens said a certain number of humans could tour their spaceship. if the humans entered the ship in groups of 234

Let fnof represent the position of an object with respect : a. graph the function fnofx x3 - 4x 2.b. find the domain and range of fnof showing all work or explaining your

Olivia goes to egypt and saw a model of triangle shaped : olivia goes to egypt and saw a model of triangle shaped pyramid. she enlarged it using a scale factor of 1.2. what will

What percentage of the total variability in monthly rent is : in the spring of 2013 data was collected for 30 randomly selected apartments in the san diego area in an attempt to

In a sample with mean x 12 and standard deviation s 35 a : 1. which of the following statements is true?a. when taking a sample from the population the variable involved will

Describe how the guidelines for growth would align with the : imagine you are the newly appointed microsoft hrl who works in the u.s. but is responsible for the singapore operation.

Compute direction of deepest descent using direction of the : given the unconstrained functionf nbspnbsp x1sup2nbsp nbsp 1x1nbsp nbsp x2nbsp nbsp 1x2questiona atnbsp x1

A population of 200 voters contains 78 republicans 120 : a population of 200 voters contains 78 republicans 120 democrats and 2 independents and members of other parties. a

User Account

All Pages