Reference no: EM131056701
Real Estate Regression Exercise
Directions: Use the real estate data. 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)?
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?
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?
(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?
Attachment:- Real-Estate-Data.xlsx
|
Perform the same comparisons on those systems
: If you have access to other UNIX implementations, perform the same comparisons on those systems.
|
|
Write a program that measures the bandwidth provided by pipe
: After all data has been read, the parent should print the elapsed time required and the bandwidth (bytes transferred per second). Measure the bandwidth for different data block sizes
|
|
Plot the data on weibull hazard paper
: Shave die. Use the shave die data of Problem 4.1. Other events that stop the process are thought to occur at random and independently. If so, the times to when the process is stopped for other reasons have an exponential distribution.
|
|
Price promotion profitable
: If this past relationship between sales of whole fryers and increased sales of other goods holds, by how much must chicken sales increase to make this price promotion profitable?
|
|
What is the coefficient of correlation
: What is the Coefficient of Correlation between square footage and listing price? Does your Coefficient of Correlation seem consistent with your answer to #2 above? Why or why not?
|
|
Percentage change in the price of bond
: If rates were to suddenly fall by 2 percent instead, what would be the percentage change in the price of each bond? (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places (e.g., 32.16).)
|
|
Maintain a data structure that associates the file stream
: Obtaining the correct process ID from this structure will allow pclose() to select the child upon which to wait. This structure will also assist with the SUSv3 requirement that any still-open file streams created by earlier calls to popen() must b..
|
|
Determine the net income of a comparable
: Determine the net income of a "comparable" firm based on the following information: value of target firm = $4,000,000; net income of target firm = $200,000; stock price of "comparable" firm = $30.00; and 300,000 shares of stock outstanding for th..
|
|
What on-the-spot tactic of conflict resolution
: What on-the-spot tactic of conflict resolution can you recommend to Tammy - what should Tammy do as a long-range solution to the problem of men trying to convert business occasions into social occasions, when she wants to keep them as business occa..
|