Purchase Solution

Regression Analysis and Hypothesis Test

Not what you're looking for?

Ask Custom Question

The Director of a Real Estate Economics consulting firm is hired to determine better ways property values. However, the clients do not have background in statistics. In order to analyze the data (and get their questions answered), they have hired you as a statistical consultant to answer these questions:

Run a complete model using all variables in the data set where: Y(selling price in $000) = a+b1X1 (number of bedrooms)+ b2X2 (size of the home in square feet)+ b3X3 (pool; 1= yes, 0 = no)+ b4X4 (distance from center of city in miles)+ b5X5 (township)+ b6X6 (Garage attached; 1 = yes, 0 = no)+ b7X7 (number of bathrooms)

a. Determine which independent variable has the strongest correlation with selling price.

b. Comment on multicollinearity

c. Conduct a test of hypothesis to determine if any of the regression coefficients are not equal to zero.

d. Determine which of the regression coefficients is not equal to zero.

e. Would you consider deleting any of the independent variables?

VARIABLES

X1 = Selling price in $000

X2 = Number of bedrooms

X3 = Size of the house in square feet

X4 = Pool (1 = yes, 0 = no)

X5 = Distance from center of the city in miles.

X6 = Township

X7 = Garage Attached (1 = yes, 0 = no)

X8 = Number of bathrooms

Number of observations (n) = 105

Attachments
Purchase this Solution
Solution Summary

The solution provides step-by-step method of performing a Regression Analysis and a Regression Hypothesis Test in EXCEL. All the steps of hypothesis testing (formulation of null and alternate hypotheses, selection of significance level, choosing the appropriate test-statistic, decision rule, calculation of test-statistic and conclusion) have been explained and the Regression Analysis has been shown in details.

Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Linear Regression Analysis

    Perform a regression analysis to test your hypothesis. One hypothesis that you could test is that wages are positively correlated with age.

  • Is an F-statistic used to test the global hypothesis

    Yes or no: Is an F-statistic used to test the global hypothesis in multiple regression analysis? Yes, F statistic is used to test the global hypothesis in Multiple Regression analysis.

  • Regression Analysis and Testing Hypotheses

    For the hypothesis test, I could recommend that it should be done to the correlation coefficient r or the slope of the regression line. Regression analysis and testing hypothesis is examined.

  • Regression Analysis F-Test

    518417 Regression Analysis F-Test What can we say about the F-test (and its p-value) for the regression analysis using X1, X2 and X3?

  • Hypothesis, Regression

    222838 1) If we do not reject the null hypothesis we conclude that 2) Use excel to perform the regression analysis on the data. What is the regression equation? If we do not reject the null hypothesis we conclude that; a.

  • Interpret the results of this regression hypothesis test.

    Here we will develop a hypothesis and then test that hypothesis using linear regression analysis.

  • Regression analysis

    Regression coefficients, coefficient of determination, scatter diagram and significance of regression model are explained in the solution.

  • Statistics - Regression - Salaries Vs Stadium- Baseball 2005

    Explain the regression line and the significance of its slope. c. Formulate a hypothesis statement regarding your research issue. d. Perform a regression hypothesis test on the data. e. Interpret the results of your regression hypothesis test.

  • Linear Regression Analysis on Education and Wages

    236012 Linear Regression Analysis on Education and Wages From the following data set, develop a research question and formulate a hypothesis that can be tested with linear regression analysis.

  • Non-parametric Hypothesis Tests, Correlation & Regression

    - Conduct a linear regression analysis and test for correlation. - Copy and paste the output in a Word processor in RTF format. - State the hypothesis to be tested.

View More Related Solutions