Purchase Solution

Regression Lines, Coefficient of Squares, Graphing Dependent and Independent Variables

Not what you're looking for?

Ask Custom Question

Calculating regression lines, coefficient of squares, graphing dependent and independent variables using home sales vs square footage.

1. The data in the table below are the results of a random sample of recent home sales in your neighborhood that your boss has asked you to use to estimate the relationship between the selling price of the house and the number of square feet in it.

Observation Number Sale Price (in thousands) Square Feet (in hundreds)
1 280 20.3
2 328 30.0
3 281 21.5
4 293 25.4
5 263 14.5
6 291 22.3
7 320 31.0
8 256 37.2
9 311 27.1
10 352 30.2
11 288 21.2
12 356 37.2
13 293 23.0
14 272 26.7
15 308 26.5

a. First plot the data, with number of square feet on the "X" axis and the price of the house on the "Y" axis. Explain why housing price is the dependent variable and square feet is the independent variable.
b. What is the estimated regression line? What does the coefficient of square feet represent?
c. Is the sample size large enough for the estimated coefficient of square feet to be statistically significant at the 5% level?
d. What is the coefficient of determination (R2)?
e. Perform an F-test, again at the 5% level.

Purchase this Solution
Solution provided by:
Robert Reinhart, MBA
Education
  • MBA, Merage School of Business, Univ of Cal, Irvine
  • BA, Univ of Cal, Irvine
Recent Feedback
  • "Thank you so much for your help, it was very helpful to see how you did it in excel. Thanks again!"
  • "Awesome review. Thank you!!!!!"
  • "Wow - Amazing - Thanks"
  • "Thanks"
  • "Thanks for your help. Your solution helps me understand the problem and its solution."
Purchase this Solution
Free BrainMass Quizzes
Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

View More Free Quizzes
Related BrainMass Solutions

  • Questions and Problems

    several independent and several dependent variables are related c. one dependent and one or more independent variables are related. d. None of the above answers is correct. 2.

  • Correlation and Simple Linear Regression

    What value represents the strength of the relationship between the independent and dependent variable? In simple linear regression, how many independent variables may be used? How many dependent variables may be used?

  • MCQs on regression and correlation

    Several independent and several dependent variables are related c. One dependent and one or more independent variables are related d. None of the above answers is correct. 2.

  • Job Satisfaction-Statistical Survey and Regression Anaylsis

    The Regression Analysis has been done, and the Slope and the Y-Intercept of the required regression lines has been calculated by using the function LINEST in Excel.

  • Regression analysis - Least Squares Regression Line

    Y and X are your dependent and independent variables. Just based on the name of the tabs in Excel I assume they are Benefits and Intrinsic, respectively What are the slope and the y-intercept?

  • Regression Analysis: AIU Job Satisfaction Data Base

    First run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable and the INTRINSIC job satisfaction column of all data points in the AIU data set as the dependent variable.

  • Statistics of simple regression analyses

    First run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable and the INTRINSIC job satisfaction column of all data points in the AIU data set as the dependent variable.

  • Multiple Choice Questions in Statistics

    Several dependent variables and several independent variables d. Several regression equations and a single sample Please see the attached file.

  • Hypothesis and statistical variables

    analysis - We want to see the relashiopnship between one independent variable and one dependent variable - We want to see the strength and direction of a linear relationship between two random variables - We really are more interested in the y-intercept

View More Related Solutions