Full question and table for data is below. Thank you in advance for your help.

Exercise 15.19 (Testing for Significance) The following estimated regression equation is based on 10 observations was presented. $ = 29.1270 + 0.5906c1 + 0.4080ry Here SST = 6,724.125, 88R. = 6,216.375, as = 0.0813, and #6, = 0.0567- a. Compute MSR and MSE (to 3 decimals). MBR = MSE = b. Compute F and perform the appropriate F test (to 2 decimals). Use a = 0.06. Use F table. F= The p-value is less than 0.01 At a = 0.05, the overall model is significant c. Perform a t test for the significance of 81 (to 2 decimals). Use a = 0.06. Use t table. to = The p-value is less than 0.01 At a = 0.05, there is a significant relationship between y and $1. d. Perform a t test for the significance of By (to 2 decimals). Use a = 0.06. Use t table. The p-value is less than 0.01 At a = 0.05, there is a significant relationship between # and #2.Area or probability Fax Entries in the table give F, values, where a is the area or probability in the upper tail of the F distribution. For example, with 4 numerator degrees of freedom, 8 denominator degrees of freedom, and a .05 area in the upper tail, For = 3.84. Denomination Area in Numerator Degrees of Freedom Degrees Upper of Freedom Tail 2 3 5 6 7 10 15 20 25 30 100 100 .10 39.86 49.50 53.50 35.83 57.24 58.20 58.91 59.44 59.86 60.19 61.22 61.74 62.05 62 26 62 53 62.79 63.01 63.30 161.45 100.50 215.71 224 58 230.16 213.90 236.77 218.88 240 54 241.88 245.05 248.02 240.26 250.10 251.14 252.20 253.04 254.19 025 647.79 790.48 864.15 890.60 921.83 937.11 948.20 956.64 063 28 968.63 084.87 093.08 908.09 1001.40 1005.60 1009.79 1013.16 1017.76 4052.18 4990.34 5403.53 5624 26 5763.96 5858.95 5928 33 5980.95 6022.40 6055.03 6156.97 6208.66 6239.86 6260 35 628643 6312.97 6333.92 6362 80 10 8.53 9.16 9.24 9.20 9.33 9 35 9.37 38 9.30 942 9.44 9.45 9 46 9.47 9.47 9 48 9 40 05 18.51 19.00 19.16 19 25 19.30 19 43 10 35 19.37 19 38 19.40 19 43 19,45 19.46 19 46 19 47 19 48 19 40 19 40 025 38.51 30.00 39,17 39 25 30.30 30 13 30 36 10.37 30 30 30,40 30 43 30 45 30,46 30 46 30 47 39 48 39 40 30 50 08 50 90,00 09.16 90 25 09 33 00 30 90.40 09 43 90,45 90.46 90 47 00 48 90 40 09 50 .10 3.34 3.46 3.39 5.34 3.31 3.28 3.27 5.25 3.24 3.23 3.20 3.18 3.17 3.17 3.16 3.15 3.14 3.13 .05 10.13 9.53 9.28 9.12 9.01 8.94 8.89 8.85 8.81 8.79 8.70 8.66 8.63 8.62 8.59 857 8.55 853 025 17.44 16.0 13.44 15.10 14.88 14.73 14.62 14.54 14.47 14.42 14.25 14.17 14.12 1408 140 13.9 13.96 13.91 34.12 30.82 29.46 28.71 28.24 27.91 27.67 27.49 27.34 27.23 26.8 26.69 26.58 26.50 26.41 26 32 26.24 26.14 .10 4.54 4.32 4.19 4.11 4.05 4.01 3.98 3.95 3.94 3.92 3.87 3.8 3.83 3.82 3.80 3.79 3.78 3.76 7.71 6.04 6.50 5.30 5.26 6.16 6.00 6.04 5.06 5.86 5,77 5.75 5.72 5.60 5.66 5.63 025 12 22 10.65 0.60 9.36 0.20 8.90 8.84 8.66 3.56 8.50 8.46 8.41 8 36 8.32 8.26 21.20 18.00 16.60 15.08 15.52 15.21 1403 14 80 14.66 14.55 14.20 14.02 13.01 1384 13.75 13.65 13.47 .10 4.06 3.78 3.62 3.52 3.45 3140 3.37 3.34 3.32 3.30 3.324 3.21 3.19 3.17 3.16 3.14 3.13 3.11 05 6.61. 5.79 541 5.19 5.05 4.95 4.88 4.82 4 77 4,74 4.62 4.56 4.52 450 4.46 4.43 441 4 37 025 10.01 8.43 7.76 7.30 7.15 6.98 6.85 6.76 6.68 6.62 643 6.33 6.27 6.23 6.18 6.12 6 08 6.02 16.26 13.27 12 06 11.39 10.97 10.67 10.46 10.29 10.16 10.05 9.72 9.55 945 9 38 9.20 9.20 9.13 9.03Numerator Degrees of Freedom Denominator Area in 15 Degrees Upper 5 7 10 of Freedom 2.80 278 2.76 2.75 2.72 301 296 2:96 294 281 3.74 171 3.67 3.46 3.29 3.18 3.11 4 06 101 3.47 3.83 3.81 3.71 402 $14 4.76 453 4.39 4.21 4.17 5.11 401 4.46 7.36 623 7.40 J.M 7.73 9.15 8.75 BAT 8.26 7.87 1.56 13.75 9.78 250 2.50 257 256 2 54 251 2.47 3.UT 283 2.TH 275 171 2 70 263 3.64 3.51 3.44 3.40 3.38 3.34 3.30 3.27 -10 3.59 3.M 3.97 3.87 3.79 3.73 4.31 4.25 4.15 436 4.21 105 5.59 4.74 4.35 4.12 5.12 4.99 4.90 4.81 4.76 4.37 4.47 5.90 5.75 025 807 654 5.89 5.52 5.29 631 6.16 3.45 T.HS 7.46 7.19 12.25 2.40 2.38 2.34 2.32 2.30 2.59 2.56 2.54 2.46 2.42 2.67 2.62 304 3.01 2.07 206 2.73 3.15 3.11 308 .10 3.46 3.11 2.92 2.81 3.50 3.44 3.21 4.07 4.00 3.94 3.89 1.84 3.78 3.74 3.68 4.46 4.36 4.30 4.10 1.06 025 757 5.42 5.05 4.82 4.65 4.53 4.43 5.81 5.52 5.36 5.36 $.20 5.12 5.03 5.91 8.45 7.01 6.63 637 6.18 603 .DI 11.26 7.59 221 2.19 2.16 2.55 2.51 2.47 2.44 2.34 230 2.27 2.25 2.21 2.71 3.36 3.01 2.81 2.69 2.61 3.18 3.14 3.01 2.94 2.89 2.86 2.83 2.79 2.76 .10 105 5.12 4.26 3.86 3.43 3.48 3.37 3.29 3.27 3 56 3.51 345 1.40 4.20 4.10 4,03 3.96 3.77 3 67 4.32 4 65 457 4 48 4.41 4 42 7.21 5.71 4 72 4 46 606 5.47 4.26 4.71 6.42 5.61 10.56 8102 206 2.35 2.32 2.24 2 20 2.17 2.16 2.13 211 2.09 2.35 254 3.29 2.92 2.73 2.61 2.51 2.46 2.41 2.98 2.85 277 2.73 270 261 1.90 10 10 3.48 3.30 3.12 3.14 3.0 3.31 3.16 3.20 3.15 3109 4.96 4.10 3.71 3.35 3.85 3.78 3.72 3.52 3.42 4,17 025 6.94 5.46 4.83 4.47 4.24 4.07 3.95 4 35 404 456 4 41 4.31 5.90 5.39 530 1.98 10 10.04 756 2.27 2.25 2.17 212 2.10 208 2.01 2.30 2.66 2.51 2.45 2.34 2.34 2.72 2 65 257 253 2 40 241 10 3.23 2.86 2.90 2.85 296 484 3.98 3.50 1.16 3.20 3.09 3.01 295 3.50 3.53 3.13 3,16 3.12 404 3.#8 3,76 3.66 3.04 1.78 3.71 025 6.72 4.64 4.74 4.54 4.35 4.10 0.65 721 5.47 5.32 5.07 201 1.06 1.94 2.61 1.34 2.31 2.18 2.14 2.21 2.19 2.10 2.43 2.35 2.30 250 -10 3.18 281 2.91 2.35 2.80 2.75 2.42 254 12 2.85 2.50 2.73 4.75 3.89 4.11 3.61 3.51 3.44 3.37 3.18 3.07 3.01 2.96 2.91 3.84 3.73 3.76 1.70 344 3.47 025 6.55 5.10 4.47 4.12 4.37 4.64 4.50 4.30 4.30 401 973 1.90 1.85 2.13 2.20 2.16 2.14 2.05 201 1.98 1.96 1.93 235 2.18 241 2.36 234 2 26 7.21 2.43 13 .10 3.14 2.76 2.56 2.77 2.67 246 2.83 2.71 2.53 2.84 271 2 67 200 4 67 3.81 341 3.18 3.03 2.92 3.30 331 3.25 2.95 2.88 3.34 3 27 3. 15 025 641 4.97 4.35 3.77 3.60 3.48 3.51 3.43 462 4.44 4.30 4.19 4,10 3.82 3.66 3.57 6.70 5.21 4.86 9 07 2.10 1.06 1.90 1.89 1.86 I.M 215 2.12 201 2.19 2.14 .10 273 252 324 2.19 2.39 234 2.31 2.17 2.22 14 334 3.11 2.96 2.85 3.76 2.70 265 2.60 2.46 2 50 3.71 3.15 296 2.78 2.73 2.67 2.61 2 56 05 4.60 4.86 3.80 3.50 1.38 3.29 3.66 ISE 341 3.35 3.17 3,18 3.11 3.012 025 630 4 28 4.14 4.03 3.04 N.NG 3.56 4 46 651 1.79 2.12 209 7 06 1.92 1.67 1.85 2.20 2.16 212 207 13 3.07 1 70 249 2.25 2 64 2 40 2.33 1.68 1 06 270 2.71 240 2.90 286 2.76 2 60 2.64 2.50 2.52 247 2.40 454 3.41 3.20 1.20 3.12 106 6.20 4.77 4.15 158 3.89 3.37 3.28 3.21 1.13 298 025 6.36 4 56 4 32 4.00Denominaior Area In Numerator Degrees of Freedom Degrees Upper of Freedom Tail I 1 3 4 6 T 15 20 25 30 16 10 3.05 2.67 2.46 2.33 2.24 2.18 2.13 2.09 2.06 2.03 1.94 1.69 1.86 1.34 1.81 1.78 1.76 1.7 4.19 3.63 3.24 3.0 2.85 2.66 2.59 251 2.49 2.35 2.28 2 71 215 2.15 211 2.07 202 035 6. 17 4 0 3.50 3.14 3,17 3.05 2.19 261 2 40 5.20 4.44 4.20 3.41 3.26 3.16 17 2.64 2.44 2.10 2.0 1.91 I.86 1.23 1.75 1.73 4.45 3.50 3.20 2.96 2.70 2.61 2.5 2.40 2.45 2.31 221 2.18 215 2.10 2.02 025 6.04 4.62 4.01 3.66 3.44 3.28 3.16 3.06 2.98 2.92 2.72 2.61 2.55 2.50 244 236 2.33 2.26 8.40 6.11 5.10 4.67 134 4.10 3.94 3.70 3.68 3.50 3.31 3.16 3.07 3.00 202 2.76 3.01 2.62 2.42 2.29 2.20 2.13 2.08 200 1.98 1.89 1.75 1.72 1.70 1.66 4.41 3.45 3.16 2.93 2.77 2 58 25 2.46 2.41 2.17 219 2.14 2.11 207 1.97 456 3.09 3.61 3 38 3.72 3.10 3.01 2.09 2.87 2.67 2.40 2.44 2.27 8.29 6.01 5.09 458 4.25 3.84 3.71 360 351 3.23 2.98 2.01 2.84 2.75 2.68 2.81 2.40 2.27 2.18 2.11 2106 198 1.96 1.86 1.81 178 1.76 1.73 1.70 1.87 1.64 4 38 3.52 3.13 2.90 2.74 154 2.48 242 2.38 2.13 2.16 211 2.07 2.00 1.94 1.88 5.92 451 3.90 3.56 3.33 3.17 2.96 2 88 2.82 2.62 2.51 244 2.34 2.33 2.27 2.22 2.14 5.03 5.01 4.50 4.17 3.04 3.77 342 143 1.15 3100 201 284 276 2.67 2.An 20 -10 297 259 238 2.25 2.16 2009 2.00 196 1.94 184 1.79 1.76 1.74 171 1.68 165 1.61 135 349 3.10 2 87 271 2.60 251 245 230 235 2.20 2.12 207 2/04 1.99 1.95 191 025 5.87 4.46 3.86 351 3.20 3.13 291 2.84 277 2.57 2.46 240 2.35 229 2.12 2.17 8.10 5.85 1.94 4.43 4.10 3.37 3.70 3.56 3.46 3.37 3.09 2.94 2.84 2.78 2.69 2.61 2.54 2.43 21 257 236 2.14 208 1.98 1.95 1.92 1.83 1.78 1.74 1.12 1.66 1.63 1.50 1.32 347 3.07 2.34 268 2:49 242 2.37 2.32 218 2.10 2.05 2.01 1.96 1.92 1.82 3.83 4.42 3.82 3.48 3.25 2 97 2 87 2.80 273 253 2.42 2.36 2.31 275 2.18 2.13 2.05 ANT 437 4 04 351 3.40 331 3.03 2.12 248 21 10 256 235 2.13 2016 201 1.03 1.90 1.81 I,76 1.73 1,TO 1.61 1.57 4.30 3.44 305 282 2.66 146 240 230 215 202 1.98 1.04 1.85 1.70 025 5.79 4.38 3.78 3.41 122 203 2.84 2.76 2. 70 250 2.39 2.32 2.17 2.21 2.14 209 2.01 431 145 173 267 2.42 21 .10 2.55 134 2.21 2.11 205 1.90 1.95 1.92 1.89 1.80 1.74 1.71 1.65 1.62 1.59 1.55 3.42 3.03 2.80 264 253 244 237 2.32 2.27 2.13 200 1.96 1.91 1.82 1.765 025 4.35 3.75 3.41 3.18 3.02 2:40 281 273 267 2.36 220 2.24 218 2.11 1.PH 5.66 4.76 4.36 3.04 3.71 354 3.41 3.30 3.21 203 2.78 2.62 244 2.45 2.37 254 2.19 2.10 304 1.08 1.04 1.91 I.HE 1.78 1.73 1.70 1.67 1.64 161 154 24 .10 103 105 4.26 3.40 3.01 1.78 2.62 2.51 2.41 IM 2.30 1.25 2.11 1.97 1.94 1.89 184 1.80 1.74 025 5.71 4.32 3.71 3.15 209 2.87 270 264 2.41 2.33 2.26 2.21 2.15 2.08 2702 1.94 5.60 4.72 4.22 3,67 3.50 3.36 3.26 3.17 2.74 264 258 7.40 2 40 2.33 272Denominator Aires in Numerator Dagross of Freedom Degrees Upper Freedom Tail 1 2 5 7 15 25 40 100 10 291 253 218 209 201 1.97 1.01 1.89 1.87 1.77 1.72 1.68 1.66 1.63 1.50 1.56 151 4.2 3.39 2.99 276 2.60 249 240 2.34 2.28 2.24 2.09 2.01 1.96 1.92 I.ST 1.82 I.76 1.7 4.79 3.69 3.31 3,13 207 275 261 241 2.30 2.18 205 200 1.91 7.7 5.57 4.GE 3.85 3.46 3.31 3.13 2.85 2.70 2.60 2.54 245 236 2.18 ,10 2.51 2.31 2.17 1.96 1.01 1.86 I, M6 1,71 1.61 151 105 4.21 3.37 2.74 259 247 2.27 2.22 2.07 1.90 1.04 1.90 1.85 1.80 1.76 1.70 1025 5.66 4.27 3.67 3.31 3.10 204 2.81 273 2.65 2.59 2.28 2.21 2.16 1.97 1.80 7.72 5.53 4.64 4.14 3.82 3.59 3.42 3.29 309 2.66 257 2 50 2.41 2.33 2.25 2.14 27 .10 2.90 2.51 2.30 2.17 2.07 2.00 1.95 1.91 1.67 1.85 1.75 1.70 1.66 1.64 1.60 1.57 1.54 1.50 105 4.21 3.35 2.96 2.73 257 246 2.37 2.31 2.25 2.20 2.06 1.97 1.92 I.88 1.70 1.74 168 025 4.24 3.31 2.01 2.71 263 257 2.25 2.18 213 20 200 1.94 .DI 7.6 1.49 4.11 3.7% 3.56 3.26 3.15 3.06 263 2.54 247 120 2.12 2.11 2.16 205 200 1.94 1.90 1.57 1.84 1,74 1.63 1.56 4.20 3.34 2.95 2.71 2.56 2.45 2.36 2.29 2.24 2.19 2.04 1.96 1.91 1.87 1.82 1.77 1.73 1.66 025 5.61 4.22 3.63 3.29 3/06 2.90 2.78 2.69 2.61 2.55 234 2.23 2.16 211 2.05 1.98 1.92 7.64 145 457 4.75 3.12 2.75 260 2.51 244 2.35 2.26 2.19 .10 2.50 2.15 2.06 1.90 1.93 1.86. 1.73 1.68 1.6 1.62 158 1.53 1.52 4.18 203 2.70 2.55 2.43 2.35 2.28 2.22 2.18 203 1.04 1.80 1.85 1.21 1.75 1.71 1.65 025 4:20 3.61 3.17 2.T6 2.67 2 50 253 212 2.21 2.14 2 0 FOZ 1.06 1.90 1.82 5.42 154 TH 3.73 3.50 3.33 3.20 300 2.73 257 248 2.33 2.23 2.16 30 .10 2.83 2.49 2.18 2.14 2105 1.98 1.93 1.88 1.85 1.82 1.72 1.67 1.63 1.61 1.57 1.54 1.51 1.46 .05 4.17 3.32 2.92 2.53 2.42 2.33 2.27 2.21 2.16 2.01 1.93 1.68 1.84 1.79 1.74 1.70 1.63 035 4.18 3.50 3.25 3.03 2 87 2.75 2.65 2.57 251 231 2.20 2.12 201 1.94 7.30 4.41 102 3.70 1.47 3.30 3.17 270 245 2.45 2.30 2.21 2.13 201 40 -10 2.44 2.23 2109 2.00 1.93 187 1.79 1.76 1.61 1.57 1.54 15I 143 1.3 TOH 261 2.45 2.34 2.25 2.18 2.12 1.84 1.78 1.74 1.60 1.64 1.51 025 5.42 105 3.46 3.13 2.90 2.74 2.62 2.53 2.45 2.39 2.18 2.07 1.99 1.94 1.80 1.74 1.65 7.31 5.18 4.31 151 3.29 3.12 2.90 2.89 2.37 2.27 2.10 2.01 1.81 -10 2.79 2.39 2.18 1.95 1.87 182 1.77 1.74 1.71 1.60 1.54 1.50 1.48 1.44 1.40 1.36 1.30 4 0 3.15 2.76 243 2.37 2.25 2.17 2.10 204 1.90 1.75 1.65 1.50 1.53 1.40 075 3.03 3 34 3.DI 2.79 2.63 251 241 2.33 2.27 1.94 1.27 1.74 1.49 7.08 113 3.65 134 3.12 2.95 2.82 2.72 263 135 2.20 2.10 1.94 1.84 1.75 1.62 2.76 2 36 214 191 1.83 1.73 1.60 1656 1.49 145 1.41 1.38 1.34 1.21 1.70 146 211 210 2.10 103 1.77 1.68 1.61 1.57 1.52 1.45 1 30 1.30 025 125 292 2.70 254 242 232 1.97 1.85 1.77 1.71 1.56 1.48 136 351 209 207 1 60 1.45 10OO 2.71 231 1.95 1.78 1.72 168 1.61 1.61 1.49 143 138 1.35 1.30 1.25 1.20 3 8 261 2 38 2.22 202 1.93 1.58 1.52 1.47 141 1.26 1.II 025 504 3.13 2 40 258 242 230 2.20 213 206 1.85 1.72 1.64 1.58 1.50 1.41 1.32 1.13 3.80 3.04 182 266 2.53 243 134 1.90 1.79 1.72 1.61 1.50 1.3 1.16TABLE 2 DISTRIBUTION Area or probability Entries in the table give values for an area or probability in the upper tail of the N distribution. For example, with 10 degrees - of freedom and a .05 area in the upper tail, "" tes = 1.812. Area in Upper Tail Degrees _ of Freedom .20 A0 05 025 A1 D05 I 1.376 3.078 6314 12.706 31.821 63.656 2 1.061 1.886 2.920 4.303 6.965 9.925 3 978 1.638 2.353 3.182 4541 5.841 4 941 1.533 2,132 2776 3.747 4.604 5 920 1.476 2.015 2.571 3.365 4032 6 906 1.440 1.943 2447 3.143 3.707 7 896 1.415 1.895 2.365 2.998 3499 8 889 1.397 1.860 2.306 2.896 3.355 9 883 1.383 1.833 2.262 2.821 3.250 10 879 1.372 1.812 2228 2.764 3.169 11 876 1.363 1.796 2201 2718 3.106 12 873 1.356 1.782 2.179 2.681 3.055 13 870 1.350 1.771 2.160 2.650 3.012 14 868 1.345 1.761 2,145 2.624 2977 15 .866 1.341 1.753 2.131 2.602 2047 16 .865 1.337 1.746 2.120 2583 2921 17 .863 1.333 1.740 2.110 2.567 2.898 18 .862 1.330 1.734 2.101 2552 2.878 19 861 1.328 1.729 2.003 2539 2.861 \f\f