Reference no: EM131339465
Assignment
The estimated regression equation is not explaining about 67 percent of the variation of sales price (dependent variable). The search continues for additional statistically significant explanatory variables. The distance of homes for sale from the city center may be relevant in explaining the variation in the sales price of homes. A potential fourth explanatory variable (x4) has been included in the Real Estate Data workbook to make it easy to put together a scatterplot, simple regression equation and multiple regression equation. On the Computer (Insert (Scatterplot) & Tools/Data Analysis/Regression)
(a) What is your expectation about the direction of the relationship between sales price and distance from the center of the city?
(b) Construct and evaluate the scatterplot between sales price and distance from the city center.
(c) Estimate a simple regression between daily sales (y) and distance from the city center (x4). Using all the tests (including a hypothesis test on the slope coefficient), provide a written evaluation of the estimated simple regression equation.
(d) Estimate the multiple regression equation (include square footage, number of bedrooms, number of bathrooms, distance from the center of the city).
(e) Conduct individual hypothesis tests (alpha=.05) to determine if any of the explanatory variables can be dropped from the estimated multiple regression equation.
(f) Conduct a global hypothesis test (F-Test) to verify the overall statistical significance (p-value =.05) of the estimated multiple regression equation in part d.
(g) If any variables should be dropped from the multiple regression equation, re-run and repeat parts e and f.
(h) Provide an overall written evaluation of your final multiple regression equation justifying your decision. Is the explanatory variable distance from the city center a worthwhile addition to the multiple regression equation?
(i) Based on the final regression equation (you decide), forecast the sales price for a home which is 3,950 square feet has 4 bedrooms and 3 bathrooms, and is located 21 miles from the center of the city.
|
Technical paper-object-oriented programming
: Use the Internet or Strayer databases to research the advantages, features, and common examples of OOP and EDP. Note: You may use the Association for Computing Machinery (ACM) Digital Library to support research on the above topics. Instructions d..
|
|
Create in visual logic as well as a screenshot
: Submit the .vls file you create in Visual Logic as well as a screenshot of the output. For full credit, the program must function correctly, produce the correct answer, and be logically succinct.
|
|
Body mass index program
: Write a modularized Body Mass Index (BMI) Program which will calculate the BMI of a team player. The formula to calculate the BMI is as follows:
|
|
Explain a philosophical problem that exists in reconciling
: Explain a philosophical problem that exists in reconciling the 'external world' with a 'transcendental realm.' Use an example to illustrate the problem
|
|
Estimate a simple regression between daily sales
: Estimate a simple regression between daily sales (y) and distance from the city center (x4). Using all the tests, provide a written evaluation of the estimated simple regression equation.
|
|
Why the cliche of good and evil breaks down in friedrich
: Explain how and why the cliche of good and evil breaks down in Friedrich Durrenmatt"s novel The Pledge.Analyze the function of the fairy tale motifs in Durrenmatt"s novel The Pledge.
|
|
Types of database keys
: Describe the function of each of the following types of database keys: primary, alternate, secondary, and foreign.
|
|
Show the movement of tokens through the graph
: Draw a dataflow graph to achieve a BRANCH operation using two MERGE operations and a dataflow graph to achieve a MERGE operation using two BRANCH operations.
|
|
Write response essays to certain documentaries
: Write response essays to certain documentaries.- Do you think poor/developing countries should continue to burn coal moving forward to continue fast economic development, even if it worsens the effects of climate change?
|