Question

solve using excel with the setup example

4) The following data set gives the average heights and weights for American women aged 30- 39 (source: The World Almanac and Book of Facts, 1975). Total observations 15. Heights, Xi (in) 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 115 117 120 Weights, yi (lb) 123 126 129 132 135 139 142 146 150 154 159 164

setup example

Answer 1

B C H (y- 115 117 120 123 126 129 132 D E F G у к (yhead- yhead-ybarybar)^2 y-ybarybar)^2 yhead-y 6670 13225 112.583 -24.147 583.0776 -21.73 472.1929 -2.417 6903 13689 116.033 -20.697 428.3658 -19.73 389.2729 -0.967 7200 14400 119.483 -17.247 297.459 -16.73 279.8929 -0.517 750315129 122.933 -13.797 190.3572 -13.73 188.5129 -0.067 7812 15876 126.383 -10.347 107.0604 -10.73 115.1329 0.383 8127 16641 129.833 -6.897 47.56861 -7.73 59.7529 0.833 8448 17424 133.283 -3.447 11.88181 -4.73 22.3729 1.283 8775 18225 136.733 0.0039E-06 -1.73 2.9929 1.733 9174 19321140.183 3.453 11.923211 2.27 5.1529 1.183 9514 20164 143.633 6.903 47.65141 5.27 27.7729 1.633 9928 21316 147.083 10.353 107.1846 9.27 85.9329 1.083 10350 22500 150.533 13.803 190.5228| 13.27 176.0929 0.533 107801 23716 153.983 17.253 297.666 17.27 298.2529 -0.017 11289 25281 157.433 20.703 428.6142 22.27 495.9529 1180826896 160.883 24.153 583.3674 27.27 743.6529 -3.117 3332.71 3362.934 3364 3481 3600 3721 3844 3969 4096 4225 4356 4489 4624 4761 4900 5041 5184 135 139 142 146 150 154 159 164 2051 975 y=3.45x- 1987.517 20 n=15 21 ybar=136.73

Weight (y) y = 3.45% - 87.517 R2 = 0.991 10 20 30 40 50 60 70 80

у Y = ax + b Y = 3.4522 -87.517 | EY = 2051 a = 3.415 In=15 Ybar = b = -87.517 1 Ybar = 7 = 2051 {for calculating Yhead) I Ybar ( 7 ) = 13673) 2001 R² = {(i gj? Ely; -912 R? - 0.991 (coelf- of determination)