Purchase Solution

Interpret the slope coefficient, test the hypothesis

Not what you're looking for?

Ask Custom Question

See attached file.

The file housing.xls contains sample data on the assessed price of a house (in $1,000s) and the house's floor space (in square feet). Pls Do with Excel, except where stated, and explain your results.

a. Determine the proper dependent variable and then plot a scatter diagram with the dependent variable on the vertical axis. Then, assuming a linear relationship, use the least squares method to find the regression coefficients b0 and b1. What is the regression equation?

b. Interpret the estimated slope coefficient in a sentence. Does the intercept have a meaning in your regression? Explain.

c. Test by hand the null hypothesis that the slope coefficient is equal to zero at the 99% level of confidence. Show your steps.

d. Give a 95% confidence interval for b1. Interpret this interval.

e. Interpret the estimated coefficient of determination.

f. By hand predict the price for a 7,200 square foot house. Then use Excel to construct the prediction interval of an individual 7,200 square foot house. After reporting the results comment on the appropriateness of this particular forecast.

note- Use a 0.05 level of significance
unless otherwise stated.

Attachments
Purchase this Solution
Solution Summary

A Complete, Neat and Step-by-step Solution is provided in the attached file.

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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.

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

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

View More Free Quizzes
Related BrainMass Solutions

  • Sample Correlation, Intercepts, and the Coefficient of Determination

    Test the null hypothesis that the slope of the population regression line is 0 against the alternative that the true slope is not equal to zero, and interpret your results. a.

  • Inflation Rate: Regression

    Test the null hypothesis that the slope of the population regression line is 0 against the alternative that the true slope is not equal to zero at the 5% significance level, and interpret you results. d.

  • Regression Analysis: IRS Audit

    5. test the overall significant of the regression model, 6. interpret the coefficient of determination, and 7. are there any violations of the general linear model?

  • Emily Smith decides to buy a fuel-efficient used car

    (f) Using the 0.10 significance level, test the significance of the slope. Interpret the result. Is there a significant between the two variables?

  • Scattergrams, hypothesis, confidence interval

    Set up the appropriate null and alternative hypothesis and test them using the t test. Note: Use a =5 Please see the attached file. Interpret the estimated intercept and slope in this posting.

  • Testing of hypothesis, Interpreataion of linear correlation

    How do you interpret the linear correlation coefficient? 3. How do you test the equality of population variances? 4.How do you test the significant differences between treatment means?

  • Linear Regression and Correlation

    Does there appear to be a relationship between the percentage of the population over 65 and the literacy percentage? Support your answer with statistical evidence. Conduct an appropriate test of hypothesis and interpret the results.

  • Regression analysis and 5-Step Hypothesis Test

    Correlation coefficient b. Coefficient of determination c. Slope and intercept of the regression equation 3.

  • Hypothesis testing and correlation coefficient

    Problem 5: Calculate the correlation coefficient and interpret its meaning as applied to this problem.In addition using a hypothesis test to determine if the correlation coefficient is statistically different from 0 (Ho:p=0).

View More Related Solutions