Purchase Solution

Regression Analysis

Not what you're looking for?

Ask Custom Question

The data file contains information on 76 single-family homes in Eugene, Oregon during 2005. At the time the data were collected, the data submitter was preparing to place his house on the market and it was important to come up with a reasonable asking price. Whereas realtors use experience and local knowledge to subjectively value a house based on its characteristics (size, amenities, location, etc.) and the prices of similar houses nearby, regression analysis provides an alternative that more objectively models local house prices using these same data. Please address items (a) through (c) below

a) Using price as the dependent variable (Y) use regression to determine the fitted regression equation using size, bath, bed, and garage. (Use Data Analysis in Excel or MegaStat)
b) What does the R-squared value tell you?
c) Using an alpha value of 0.05, which variables are significant (size, bath, bed, garage)?
d) The variable "bed" has a negative coefficients. What does this mean. (i.e. what happens to the selling price when the number of bedrooms increases)

[Please refer to the attachment for the data]

Attachments
Purchase this Solution

Solution Summary

The solution provides detailed Regression Analysis performed on the given data.

Solution provided by:
Education
  • MSc, Osmania University
  • MSc, Indian Institute of Technology - Roorkee (I.I.T.-ROORKEE)
  • BSc, Banaras Hindu University
Recent Feedback
  • "Very fast turnaround. Excellent communication! Much appreciated!"
  • "excellent"
  • "excellent"
  • "excellent work"
  • "Fantastic..great solution and very well explained!!!!"
Purchase this Solution


Free BrainMass Quizzes
Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.