Question

In: Statistics and Probability

The Sales Manager at City Real Estate Company is interested in describing the relationship between condo...

The Sales Manager at City Real Estate Company is interested in describing the relationship between condo sales prices and the number of weeks the condo is on the market before its sells. He has collected a random sample of 17 low end condos that have sold within the past three months. These data are as follows:

Weeks on the Market

Selling Price

23

$                76,500.00

48

$             102,000.00

9

$                53,000.00

26

$                84,200.00

20

$                73,000.00

40

$             125,000.00

51

$             109,000.00

18

$                60,000.00

25

$                87,000.00

62

$                94,000.00

33

$                76,000.00

11

$                90,000.00

15

$                61,000.00

26

$                86,000.00

27

$                70,000.00

56

$             133,000.00

12

$                93,000.00

  1. Develop a simple linear regression model to explain the variation in selling price based on the number of weeks the condo is on the market.
  2. Test to determine whether the regression slope coefficient is significantly different from 0 using a significance level equal to 0.05.
  3. Construct and intrepret a 95% confidence interval estimate for the regression slope coefficient.

Solutions

Expert Solution

Develop a simple linear regression model to explain the variation in selling price based on the number of weeks the condo is on the market.

y = 943.58x + 58766

st to determine whether the regression slope coefficient is significantly different from 0 using a significance level equal to 0.05.

Construct and interpret a 95% confidence interval estimate for the regression slope coefficient.


Related Solutions

A real estate developer is interested in determining the relationship between family income (X) and the...
A real estate developer is interested in determining the relationship between family income (X) and the square footage of their home (Y). Seven families are randomly selected and the (X, Y) measurements are as follows: X ($1000) 22, 26, 45, 37, 28, 50, 56 Y (Sq Ft) 16, 17, 26 ,24, 22 ,21, 32 ? = 37.71, ? = 22.57 Sxx = 1017.43, Sxy = 351.14, Sxyy = 179.71 (a) Sketch a scatter plot and determine whether it is acceptable...
A sales manager is interested in determining the relationship between the amount spent on advertising and...
A sales manager is interested in determining the relationship between the amount spent on advertising and total sales. the manger collects data for the past  months and runs a regression of sales on advertising expenditures. The results wıth some missing values are presented below. Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.492 0.242 0.208 40.975 ANOVA df SS MS F Significance Regression Residual Total 1 Coefficients Standard Error t Stat P-value Constant Advertising To test the...
A real estate agent in Athens used regression analysis to investigate the relationship between apartment sales...
A real estate agent in Athens used regression analysis to investigate the relationship between apartment sales prices and the various characteristics of apartments and buildings. The variables collected from a random sample of 25 compartments are as follows: Sale price: The sale price of the apartment (in €) Apartments: Number of apartments in the building Age: Age of the building (in years) Size: Apartment size (area in square meters) Parking spaces: Number of car parking spaces in the building Excellent...
A real estate agent in Athens used regression analysis to investigate the relationship between apartment sales...
A real estate agent in Athens used regression analysis to investigate the relationship between apartment sales prices and the various characteristics of apartments and buildings. The variables collected from a random sample of 25 compartments are as follows: Sale price: The sale price of the apartment (in €) Apartments: Number of apartments in the building Age: Age of the building (in years) Size: Apartment size (area in square meters) Parking spaces: Number of car parking spaces in the building Excellent...
A real estate agency says that the mean home sales price in City A is the...
A real estate agency says that the mean home sales price in City A is the same as in City B. The mean home sales price for 30 homes in City A is ​$127,402. Assume the population standard deviation is ​$25,880. The mean home sales price for 30 homes in City B is ​$112, 276. Assume the population standard deviation is ​$27,112. At alpha =0.01​, is there enough evidence to reject the​ agency's claim? Find the critical​ value(s) and identify...
A real estate agency says that the mean home sales price in City A is the...
A real estate agency says that the mean home sales price in City A is the same as in City B. The mean home sales price for 20 homes in City A is ​$127 comma 462. Assume the population standard deviation is ​$25 comma 879. The mean home sales price for 20 homes in City B is ​$112 comma 289. Assume the population standard deviation is ​$27 comma 112. At alphaequals0.01​, is there enough evidence to reject the​ agency's claim?...
A real estate agent wants to study the relationship between the size of an apartment and...
A real estate agent wants to study the relationship between the size of an apartment and its monthly rent price. The table below presents the size in square feet and the monthly rent in dollars, for a sample of apartments in a suburban neighborhood. Rent ($) 720 595 915 760 1000 790 880 845 650 748 685 755 815 745 715 885 Size (Square Feet) 1000 900 1200 810 1210 860 1135 960 800 960 650 970 1000 1000 1000...
An agent for a residential real estate company in a suburblocated outside a major city...
An agent for a residential real estate company in a suburb located outside a major city has the business objective of developing more accurate estimates of the monthly rental cost for apartments. Toward the goal, the agent would like to use the size of an apartment, as defined by square footage to predict the monthly rental cost. The agent selects a sample of 8 one-bedroom apartments and the data are shown. Complete parts (a) through (f).\(\begin{array}{lllllllll}\text { Monthly Rent (\$)...
An agent for a real estate company in a large city would like to be able...
An agent for a real estate company in a large city would like to be able to predict the monthly rental cost for apartments, based on the size of the apartment, as defined by square footage. A sample of eight apartments in a neighborhood was selected, and the information gathered revealed the data shown below. For these data, the regression coefficients are bo = 173.0964 and b = 1.0343. Complete parts (a) through (d). Monthly Rent ($) 950 1,550 800 1,550...
An agent for a real estate company in a large city would like to be able...
An agent for a real estate company in a large city would like to be able to predict the monthly rental cost for​ apartments, based on the size of the​ apartment, as defined by square footage. A sample of eight apartments in a neighborhood was​ selected, and the information gathered revealed the data shown below. For these​ data, the regression coefficients are b0 =121.0967 and b1 =1.0301. Complete parts​(a) through​ (d). Monthly Rent​ ($) 875 1,550 800 1,450 1,950 925...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT