Reference no: EM131050414
Real Estate Regression Exercise
Directions: Use the real estate data you used for your Week 2 learning team assignment. Analyze the data and explain your answers.
You are consulting for a large real estate firm. You have been asked to construct a model that can predict listing prices based on square footages for homes in the city you've been researching. You have data on square footages and listing prices for 100 homes.
1. Which variable is the independent variable (x) and which is the dependent variable (y)?
The sold price is the independent variable X and the square footage is the dependent Y varialble
2. Click on any cell. Click on Insert→Scatter→Scatter with markers (upper left).
To add a trendline, click Tools→Layout→Trendline→Linear Trendline
Does the scatterplot indicate observable correlation? If so, does it seem to be strong or weak? In what direction?
Yes there is a strong correlation with an increase in price there is also an increase in square footage. The line has a positive slope.
3. Click on Data→Data Analysis→Regression→OK. Highlight your data (including your two headings) and input the correct columns into Input Y Range and Input X Range, respectively. Make sure to check the box entitled "Labels".
(a) What is the Coefficient of Correlation between square footage and listing price?
|
Regression Statistics
|
|
Multiple R
|
0.814503773
|
|
R Square
|
0.663416397
|
|
Adjusted R Square
|
0.65998187
|
(b) Does your Coefficient of Correlation seem consistent with your answer to #2 above? Why or why not?
(c) What proportion of the variation in listing price is determined by variation in the square footage? What proportion of the variation in listing price is due to other factors?
(d) Check the coefficients in your summary output. What is the regression equation relating square footage to listing price?
(e) Test the significance of the slope. What is your t-value for the slope? Do you conclude that there is no significant relationship between the two variables or do you conclude that there is a significant relationship between the variables
(f) Using the regression equation that you designated in #3(d) above, what is the predicted sales price for a house of 2100 square feet?
|
Difference in abilities of students enrolled in statistics
: A statistics teacher wants to see if there is any difference in the abilities of students enrolled in statistics today and those enrolled five years ago. A sample of final examination scores from students enrolled today and from students enrolled ..
|
|
According to the pilot run-estimate the learning rate
: You’ve just completed a pilot run of 10 units of a major product and found the processing time for each unit was as follows: UNIT NUMBER TIME (HOURS) 1 970 2 640 3 420 4 380 5 320 6 250 7 220 8 207 9 190 10 190. According to the pilot run, what would..
|
|
Ways in which science and pseudoscience
: As critical thinkers, we understand that our identity has grown and evolved since we came into this world. The influences that have shaped our sense of self over time (enculturation, experience, education, beliefs) have given each of us-tovarying ..
|
|
What is the percentage change in the price of bond
: Both Bond Sam and Bond Dave have 8 percent coupons, make semiannual payments, and are priced at par value. Bond Sam has three years to maturity, whereas Bond Dave has 20 years to maturity. If interest rates suddenly rise by 2 percent, what is the per..
|
|
Real estate regression exercise
: Directions: Use the real estate data you used for your Week 2 learning team assignment. Analyze the data and explain your answers. You are consulting for a large real estate firm. You have been asked to construct a model that can predict listing..
|
|
The investment will result in additional cash flows
: Payback is in 2.94 years. Warrior Industries is getting ready to produce a car component by investing $2,700,000. The investment will result in additional cash flows of $600,000, $785,000 and $1,400,000 over the next three years.
|
|
Different capital structures-equity plan and levered plan
: Vanier Corporation is comparing two different capital structures: an all-equity plan (Plan I) and a levered plan (Plan II). Under Plan I, the company would have 210,000 shares of stock outstanding. What is the break-even EBIT?
|
|
Expected rate of return is equal to required rate of return
: In market equilibrium, stock price is stable. There is no tendency for people to buy versus to sell. The reason is that the expected rate of return is equal to required rate of return in equilibrium and stocks are fairly priced
|
|
Write a paper in which describe three pieces of legislation
: Write a paper in which you describe three pieces of legislation that have been the most critical in defining the rights of management and unions.
|