Purchase Solution

Multiple Regression Analysis explained in this solution

Not what you're looking for?

Ask Custom Question

A collector of antique grandfather clocks believes that the price (in dollars) received for the clocks at an antique auction increases with the age of the clocks and with the number of bidders. Thus the model is hypothesized is where Y = auction price, x1 = age of clock (years) and x2 = number of bidders.

A sample of 32 auction prices of grandfather clocks, along with their ages and the number of bidders, is given below.

Age (x1) Bidders (x2) Price (y) Age (x1) Bidders (x2) Price (y)
127 13 1235 170 14 2131
115 12 1080 182 8 1550
127 7 845 162 11 1884
150 9 1522 184 10 2041
156 6 1047 143 6 854
182 11 1979 159 9 1483
156 12 1822 108 14 1055
132 10 1253 175 8 1545
137 9 1297 108 6 729
113 9 946 179 9 1792
137 15 1713 111 15 1175
117 11 1024 187 8 1593
137 8 1147 111 7 785
153 6 1092 115 7 744
117 13 1152 194 5 1356
126 10 1336 168 7 1262

a) State the multiple regression equation.

b) Interpret the meaning of the slopes b1 and b2 in the model.

c) Interpret the meaning of the regression coefficient b0.

d) Test H0: ?2 = 0 against H1: ?2 > 0. Interpret your finding.

e) Use a 95% confidence interval to estimate ?2. Interpret the p-value corresponding to the estimate ?2. Does the confidence interval support your interpretation in d)?

f) Determine the coefficient of multiple determination r2Y.12 and interpret its meaning.

g) Perform a residual analysis on your results and determine the adequacy of the fit of the model.

h) Plot the residuals against the prices. Is there evidence of a pattern in the residuals? Explain.

i) At ? = 0.05, is there evidence of positive autocorrelation in the residuals?

j) Suppose the collector, having observed many auctions, believes that the rate of increase of the auction price with age will be driven upward by a large number of bidders. In other words, the collector believes that the age of clock and the number of bidders should interact. Is there evidence to support his claim that the rate of change in the mean price of the clocks with age increases as the number of bidders increases? Should the interaction term (x1 x2) be included in the model? If so, what is the multiple regression equation?

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
Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

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.

Probability Quiz

Some questions on probability

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

View More Free Quizzes
Related BrainMass Solutions

  • Statistics: Multiple Regression for a Data Set

    To conduct this analysis we have to run multiple regression analysis by taking number of wins as the independent variable and size of the stadium, ERA and Stolen Bases as dependent variables. In MS Excel this can be implemented as follows.

  • Multiple regression analysis with the attached data

    Step by step method for regression analysis is discussed here. Regression coefficients, coefficient of determination, scatter diagram and significance of regression model are explained in the solution.

  • Statistics - Regression - Excel Output - Interpretation

    194687 Regression Output - Multiple Regression - Regression Coefficients - R-squared Value - Adjusted R squared value and other factors of Regression are explained in detail.

  • Multiple regression output and correlation analysis variables

    The solution examines multiple regression output and correlation analysis variables.

  • Multiple Regression Analysis and Least Squares Regression

    The null hypothesis is: "This independent variable does not explain any of the variation in y, beyond the variation explained by the other variables".

  • Multiple regression analysis

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

  • Regression analysis

    Step by step method for regression analysis is discussed here. Regression coefficients, coefficient of determination, scatter diagram and significance of regression model are explained in the solution.

  • Multiple regression analysis

    Please see the answers Step by step method for multiple regression analysis is discussed here. Regression coefficients, coefficient of determination, scatter diagram and significance of regression model are explained in the solution.

  • Multiple regression analysis for production cost

    Step by step method for regression analysis is discussed here. Regression coefficients, coefficient of determination, scatter diagram and significance of regression model are explained in the solution.

  • Performing a multiple regression with 3 independent variables

    This means that there is no strong relationship between dependent and independent variables. The solution gives detailed steps on performing a multiple regression with 3 independent variables. All formula and calculations are shown and explained.

View More Related Solutions