Reference no: EM131350129
Assignment
Please create a power point presentation with detailed speaker notes for answers to this assignment
Real Estate Regression Exercise
Directions: Use the real estate data you used for your 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)?
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?
|
Servings of green beans and shrimp
: Jim wants to plan a meal with 134 grams of carbohydrates and 1180 calories. If green beans have 7 grams of carbohydrates and 30 calories per half-cup serving and french fried shrimp have 9 grams of carbohydrates and 190 calories per three-ounce se..
|
|
Describe the role of women in these stories
: Choose two to three works. Describe the role of women in these stories. How are they depicted? What kinds of power do they have? How are they similar and different
|
|
Which city should be chosen
: Which city should Moodie select - Assume a minimum score of 5 is now required for all factors. Which city should be chosen?
|
|
Find a formula for the inverse of function
: Where x is the number of people in the group and C(x) is in dollars. Find a formula for the inverse of this function.
|
|
What is coefficient of correlation between square footage
: 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?
|
|
Circular ripple is spreading over the pond
: A stone is thrown into a pond. A circular ripple is spreading over the pond in such a way that the radius is increasing at the rate of 6.4 feet per second. Find a function, r(t), for the radius in terms of t. Find a function, A(r), for the area of..
|
|
Find an equation that gives the phon level of a sound
: The sone is another unit of comparative loudness. The table below lists some equivalent values of phons and sones. Find an equation that gives the phon level of a sound in terms of the number of sones.
|
|
Negative correlation between gpa and athletic pursuits
: Data is collected on 20 teenagers to see if there is a correlation between GPA and hours spent in athletic pursuits each week. If r= -0.4, at the 0.05 level is there a negative correlation between GPA and athletic pursuits?
|
|
Find the number of items sold per month
: The sales of a new product (in items per month) can be approximated by S(x)=325+400log(3t+1), where t represents the number of months after the item first becomes available. Find the number of items sold per month 33 months after the item first be..
|