Please answer the following questions using the data provided. d ) Calculate SSR
ID: 3359588 • Letter: P
Question
Please answer the following questions using the data provided.
d) Calculate SSR(X1X2 , X12, X22| X1, X2) and MSR(X1X2 , X12, X22| X1, X2).
e) Perform a nested models test to test H0: B3 = B4 = B5 in the model:
Y = B0 B1X1 + B2X2 + B3X1X2 + B4X12 + B5X22 + E
f) Which model would you use when trying to predict the delivery time?
Observation Delivery Time, y Number of Cases, x1 Distance, x2 (ft) 1 16.68 7 560 2 11.5 3 220 3 12.03 3 340 4 14.88 4 80 5 13.75 6 150 6 18.11 7 330 7 8 2 110 8 17.83 7 210 9 21.5 5 605 10 40.33 16 688 11 21 10 215 12 13.5 4 255 13 19.75 6 462 14 24 9 448 15 29 10 776 16 15.35 6 200 17 19 7 132 18 9.5 3 36 19 35.1 17 770 20 17.9 10 140 21 52.32 26 810 22 18.75 9 450 23 19.83 8 635 24 10.75 4 150Explanation / Answer
The highlighted number in the red coulor line denotes the sum of the sqaured residule form regression (SSR)
Model is the sum of sqaure deiations of the independent varaible from the dependent variable and residule is the sum of saure of saured resuidules .
The coloum righ to MS id the mean sqaures (158315198). MSR is the measn sqaure of the resuidal.
For easy understandsing. The root of MSE is the sqaure root of SSR divided by degree of freedom