Question

Question 2 (30 marks) The following table gives the auctioned price of 18 antique grandfather clocks and the age of the clocks: Age Age of the clock (in years) 127 115 Price Selling price (in pounds sterling 1235 1080 845 1522 1047 1979 1822 1253 1297 946 1713 1024 1147 1092 1152 1336 1483 2041 Clock 127 150 156 182 156 132 137 10 113 137 12 13 137 153 15 16 17 18 126 159 184 Assignment File 11

Answer 1

Age of Clocks Selling Price XY x2 127 115 127 150 156 182 156 132 137 113 137 12351,56,84516,12915,25,225 10801,24,200 13,22511,66,400 845 1,07,31516,1297,14,025 15222,28,30022,50023,16,484 10471,63,332 24,336 10,96,209 19793,60,17833,12439,16,441 18222,84,23224,336 33,19,684 12531,65,39617,42415,70,009 12971,77,68918,76916,82,209 9461,06,898 12,7698,94,916 17132,34,681 18,769 29,34,369 10241,19,808 13,68910,48,576 11471,57,13918,769 13,15,609 10921,67,07623,409 11,92,464 11521,34,784 13,689 13,27,104 13361,68,33615,876 17,84,896 1483 2,35,79725,28121,99,289 20413,75,54433,85641,65,681 2401434,67,5503,62,079341,69,590 137 153 126 159 184 2525 18 140.28 21.53 Total Mean Std Dev 18 1,334.11 354.16

ression U n-Σ RY.- SX.EY -Ig x 2y砰530. 2r2p万 = 12-56 anel 424-36- 12.SX-427 36 e rgreaion LSI

Regression Statistics MultipleR R Square Adjusted R Square Standard Error Observations 0.763 0.583 0.556 235.864 18 ANOVA MS Significance F Regression Residual Total 1 12,42,135.00 12,42,135.00 22.33 16 8,90,110.78 55,631.92 17 21,32,245.78 0.00 Coefficients Standard Error 376.904 2.657 P-value Lower 95% Uper 95% 371.638 18.191 t Stat Intercept -427.362 12.557 -1.134 4.725 0.274 1,226.362 6.923 0.000

u且 out can Linear-relahancん