Essay about 2255 Assessment 3 Final Report

Essay about 2255 Assessment 3 Final Report Essay about 2255 Assessment 3 Final Report Content Part A 2 ï  ¬ Question 1 2 ï  ¬ Question 2 3 ï  ¬ Question 3 4 ï  ¬ Question 4 6 ï  ¬ Question 5 8 ï  ¬ Question 6 9 Part B 13 ï  ¬ Question7 13 ï  ¬ Question 8 16 ï  ¬ Question 9 19 Part C 21 ï  ¬ Question 10 21 ï  ¬ Question 11 25 ï  ¬ Question 12 35 Part A Introduction Given the background that motorcycles registration growth faster in last year, the purpose the subject is to study different market differentiation among different brands. The variables are given and the data were collected in order to work out the relationship among variables and the price of the motorcycles. Question 1 Using Ordinary Least Square (OLS) method estimates the regression model. The below is the estimating model to help with model estimation (hint: use the estimated coefficients to write the regression equation based on the following model). Answer: Coefficientsa Model Unstandardized Coefficients Standardized Coefficients t Sig. B Std. Error Beta 1 (Constant) -438.487 775.027 -.566 .573 Bore .508 18.895 .005 .027 .979 Displacement 7.552 2.187 .567 3.453 .001 Clearance 259.345 44.955 .360 5.769 .000 Stroke 946.424 224.885 .216 4.208 .000 Wheelbase -11.057 22.872 -.039 -.483 .630 a. Dependent Variable: MSRP Figure A-1 The following formula is to estimate the regression model: MSRP = ÃŽ ²0 + ÃŽ ²1 BORE + ÃŽ ²2 DISPLACEMENT + ÃŽ ²3 CLEARANCE + ÃŽ ²4 ENGINE STROKES + ÃŽ ²5 WHEELBASE + ÃŽ µ Note: a) ÃŽ ²0 is constant, which means as a decisive factor of price, it does not change when the regressors or the random factor change. b) ÃŽ µ is the random error, we assume that the random error with a mean equal to 0 and constant variance As graph shows above, ÃŽ ²0 (constant)=-438.487, ÃŽ ²1 (Bore)=0.508, ÃŽ ²2 (DISPLACEMENT)=7.552, ÃŽ ²3 (CLEARANCE)=259.345, ÃŽ ²4 (ENGINE STROKES)=946.424, ÃŽ ²5 (WHEELBASE)=-11.057 Therefore, the outcome is: MSRP=-438.487+0.508 BORE+7.552 DISPLACEMENT+259.345 CLEARANCE+946.424 ENGINE STROKES-11.057 WHEELBASE Question 2 What are the a priori signs of the coefficients based on your experience or theories and are they the same as the signs of the estimated coefficients from the model in the SPSS output? Answer: The priori signs: Based on the experience of real life, Bore: ÃŽ ²1 (coefficient of Bore) should be positive. Because the larger the bore is, the higher price of the motorcycle would be. Displacement: ÃŽ ²2 (coefficient of displacement) should be positive. Because the larger displacement is, the higher cost of the motorcycle would be. Clearance: ÃŽ ²3 (coefficient of clearance) should be positive. Because the larger clearance is, the higher cost of the motorcycle would be. Stroke: ÃŽ ²4 (coefficient of stroke) should be positive. Because the larger stroke is, the higher cost of the motorcycle would be. Wheelbase: ÃŽ ²5 (coefficient of wheelbase) should be positive. Because the larger wheelbase is, the higher cost of the motorcycle would be. As Figure A-1 shows, the coefficient of priori signs are all positive besides Wheelbase which means that signs of the estimated coefficients of bore, displacement, clearance, stroke are the same as the a priori signs. However, the coefficient of priori sign for wheelbase is different. In conclusion, priori signs of the coefficients based on our experience or theories are the same as the signs of the estimated coefficients besides wheelbase from the model in the Figure A-1. Because a priori signs do agree with those in the estimated model, the regression may be worthwhile. Question 3 Interpret the estimated coefficients of the model and check whether these coefficients are significant Answer: Interpretation: According to the equation above, MSRP=-438.487+0.508 BORE+7.552 DISPLACEMENT+259.345 CLEARANCE+946.424 ENGINE STROKES-11.057 WHEELBASE ï‚ŸThe price of motorcycle increases by 0.508, on average, for the each 1 inch increase in Bore. ï‚Ÿ The price of motorcycle increases by 7.552, on average, for the each 1 cu inch increase in Displacement. The price of motorcycle increases by 259.345, on average, for the each 1 inch increase