x | y | (x-xbar)^2 | (y-ybar)^2 | (x-xbar)*(y-ybar) | |
0.15 | 284 | 0.005776 | 83203.403 | 21.9222 | |
0.21 | 470 | 0.000256 | 10496.003 | 1.6392 | |
0.34 | 1017 | 0.012996 | 197624.7 | 50.6787 | |
0.12 | 206 | 0.011236 | 134285.6 | 38.8437 | |
0.3 | 893 | 0.005476 | 102752.3 | 23.7207 | |
0.37 | 1106 | 0.020736 | 284675.6 | 76.8312 | |
0.12 | 157 | 0.011236 | 172598.7 | 44.0377 | |
0.33 | 955 | 0.010816 | 146344.5 | 39.7852 | |
0.18 | 412 | 0.002116 | 25744.203 | 7.3807 | |
0.14 | 224 | 0.007396 | 121417.4 | 29.9667 | |
0.31 | 893 | 0.007056 | 102752.3 | 26.9262 | |
0.13 | 235 | 0.009216 | 113872.5 | 32.3952 | |
0.11 | 101 | 0.013456 | 222265.1 | 54.6882 | |
0.34 | 1029 | 0.012996 | 208437.9 | 52.0467 | |
0.25 | 674 | 0.000576 | 10312.403 | 2.4372 | |
0.13 | 253 | 0.009216 | 102048.3 | 30.6672 | |
0.33 | 935 | 0.010816 | 131442.5 | 37.7052 | |
0.12 | 165 | 0.011236 | 166015.5 | 43.1897 | |
0.25 | 652 | 0.000576 | 6328.2025 | 1.9092 | |
0.29 | 788 | 0.004096 | 46461.803 | 13.7952 | |
sum | 4.52 | 11449 | 0.16728 | 2389079 | 630.566 |
mean | 0.226 | 572.45 | sxx | syy | sxy |
slope=b1=sxy/sxx | 3769.524151 | ||||
intercept=b0=ybar-(slope*xbar) | -279.4624582 | ||||
SST | SYY | 2389079 | |||
SSR | sxy^2/sxx | 2376933.8 | |||
SSE | syy-sxy^2/sxx | 12145.184 | |||
r^2 | SSR/SST | 0.9949164 |
#
b) We can form regression eqn as Price = -279.46 + 3769.52*Weight
As we can see form the eqn if we put carats Weight =0 then Price=-279.46 Hence we can say that
#The intercept is the price in dollars of a ring with a diamond weighing 0 carats.
c) r^2 = 0.9949
#se is
SSE as shown above is 12145.84
As per the definition of R^2 the interpretation is
#.The value of r2 is the fraction of the variation accounted for by the least squares regression line.
d) Difference = 3769.52*Weight1- 3769.52*Weight2
= 3769.52*0.28- 3769.52*0.18
=376.95
C) Interpret the summary values r2 and se associated with the fitted question. Attach units to...
(is/is not) (more/less) Square_Feet Price_($000) 1,166 262 3,079 608 1,565 281 1,066 223 2,067 328 2,386 361 905 187 2,929 431 1,365 284 2,908 565 2,944 412 1,309 289 1,828 305 1,629 313 1,884 324 2,267 438 1,134 233 2,593 509 1,115 258 1,749 325 The accompanying data table contains the listed prices (in thousands of dollars) and the number of square feet for 20 homes listed by a realtor in a certain city. Complete parts a through f below....
Engine_Size Horsepower 5.9 488 6.0 404 6.2 416 3.4 249 3.0 251 3.5 262 3.8 299 4.0 304 4.2 309 1.4 124 1.5 154 3.6 268 1.6 139 1.8 148 5.9 466 2.0 185 2.3 183 2.4 191 2.5 228 2.8 247 The accompanying data table includes the engine size (in liters) and horsepower (HP) of 20 types of cars sold last year. Complete parts (a) through (9) below. Click the icon to view the data table. (a) Create a...
Assets R&D_Expense 2,198.673 200.083 3,870.615 418.398 1,494.774 138.476 711.152 71.067 1,569.469 135.273 2,832.213 245.403 2,183.012 195.474 461.679 45.484 803.496 84.213 3,776.297 372.948 3,965.887 332.381 927.246 85.546 2,176.368 195.359 7,533.595 653.399 1,336.162 132.614 2,274.862 236.087 289.846 32.028 2,544.071 270.175 638.382 58.371 9,605.452 975.159 667.469 74.888 1,702.442 156.826 183.616 22.811 1,572.785 163.298 581.639 64.847 3,444.067 320.042 For 26 companies operating in several technology industries, the accompanying data gives the expenses on research and development (R&D) and the total assets of the companies....
(Just need help with part F) File_size_(MB) Time_(sec) 77 31.1 93 35.1 85 35.3 94 35.7 20 14.4 74 28.9 68 29.6 88 33.5 42 21.7 20 15.3 72 28.4 24 11.5 95 35.7 59 25.6 93 36.6 71 29.1 87 34.3 92 37.2 90 35.6 67 26.8 87 32.6 83 31.2 80 34.1 57 22.8 52 25.4 76 28.9 96 38.7 70 31.8 59 24.2 57 28.1 Before taking the plunge into videoconferencing, a company ran tests of its...
File_Size_(MB) Transfer_Time_(sec) 48 17.3 59 30.3 81 27.8 74 24.3 22 8.3 21 12.9 31 16.4 49 18.6 99 32.5 22 19.6 51 29.2 99 31.6 68 26.7 69 23.6 98 44.6 32 23.8 87 35.1 81 29.6 29 14.6 97 32.9 Before taking the plunge into videoconferencing, a company ran tests of its current internal computer network. The goal of the tests was to measure how rapidly data moved through the network given the current demand on the network....