Reference no: EM131026917
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 home in the city you'be been researching. You have data on square footages and listing prices for 100 homes.
Which variable is the independent variable (x) and which is the dependent variable (y)?
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?
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".
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?
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?
Check the coefficients in your summary output. What is the regression equation relating square footage to listing price?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?
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:- Data.xlsx
|
Write a balanced equation for combustion of acetylene gas
: Acetylene gas, C2H2(g), is used in welding. (a) Write a balanced equation for the combustion of acetylene gas to CO2(g) and H2O(l). How much heat is produced in burning 1 mol of C2H2 under standard conditions if both\ reactants and products are bro..
|
|
Prove that if p is a prime number of the form 4n + 1
: Prove that if p is a prime number of the form 4n + 1, then the following congruence hold
|
|
Financial statement analysis
: Judith, an accounting major, states, "Strategy analysis seems to be an unnecessary detour in doing financial statement analysis. Why can't we just get straight to the accounting issues?" Explain to Judith why she might be wrong?
|
|
Target market (address relevant characteristics
: Psychographics: values, lifestyles, activities, interests, opinions, VALS2 type, media habits, shopping habits, spending habits, charitable activities etc.
|
|
What proportion of variation in listing price is determined
: 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?
|
|
How would you teach the multiplication of polynomials
: Do you always use the property of distribution when multiplying monomials and polynomials? Explain why or why not. Also what type of situations would distribution become important?
|
|
Explain how the mean of the means is equal or not
: Compute the mean of each of the 10 samples and list them. Explain how the mean of the means is equal, or not, to the population mean of the 100 listing prices from above.
|
|
What assumptions must you make in arriving at this estimate
: Using data in Appendix C, estimate the temperature at which the free-energy change for the transformation from I2(s) to I2(g) is zero.What assumptions must you make in arriving at this estimate?
|
|
Estimate the boiling point of benzene
: Use a reference source, such as the CRC Handbook of Chemistry and Physics, to find the experimental boiling point of benzene. How do you explain any deviation between your answer in part (a) and the experimental value?
|