Homework problem for econ and statistics
Data
| Firm ID | Cost of Animal Feed (per animal per year) | Cost of Plant Supplies (per bushel produced per year) | Cost of Labor (annually) | Livestock sold (annually) | Crop Production (bu annually) | Livestock price | Crop price | Acres | Land price per acre | Annuitized value of land (annual) |
| 96 | 372.23 | 0 | 205.2 | 5 | 0 | 716 | NA | 1710 | 6.352731 | 760.42 |
| 57 | 1055.75 | 0 | 170.16 | 3 | 0 | 997 | NA | 1418 | 5.015677 | 497.86 |
| 54 | 128.31 | 0 | 102.6 | 3 | 0 | 518 | NA | 855 | 10.608187 | 634.9 |
| 38 | 394.05 | 0 | 149.28 | 3 | 0 | 820 | NA | 1244 | 18.296109 | 1593.23 |
| 19 | 375.2 | 0 | 2712.6 | 58 | 0 | 780 | NA | 22605 | 9.140271 | 14463.11 |
| 62 | 609.02 | 0 | 1878.48 | 32 | 0 | 969 | NA | 15654 | 9.20658 | 10088.39 |
| 7 | 328.31 | 0 | 256.08 | 4 | 0 | 992 | NA | 2134 | 7.814499 | 1167.33 |
| 72 | 801.83 | 0 | 215.04 | 5 | 0 | 711 | NA | 1792 | 6.915977 | 867.54 |
| 55 | 655.15 | 0 | 3704.04 | 80 | 0 | 770 | NA | 30867 | 2.742335 | 5925.34 |
| 52 | 483.01 | 0 | 3166.56 | 65 | 0 | 804 | NA | 26388 | 11.989788 | 22147.06 |
| 99 | 715.86 | 0 | 76.92 | 2 | 0 | 693 | NA | 641 | 1.770608 | 79.45 |
| 88 | 363.98 | 0 | 153.36 | 5 | 0 | 551 | NA | 1278 | 11.301408 | 1011.02 |
| 42 | 683.59 | 0 | 920.88 | 25 | 0 | 611 | NA | 7674 | 3.533534 | 1898.14 |
| 82 | 275.58 | 0 | 220.32 | 6 | 0 | 645 | NA | 1836 | 16.009858 | 2057.59 |
| 40 | 600.53 | 0 | 211.44 | 3 | 0 | 998 | NA | 1762 | 7.449563 | 918.83 |
| 67 | 748.51 | 0 | 67.92 | 2 | 0 | 651 | NA | 566 | 9.467261 | 375.09 |
| 5 | 364.34 | 0 | 4625.64 | 82 | 0 | 938 | NA | 38547 | 22.018249 | 59411.62 |
| 39 | 166.04 | 0 | 902.28 | 24 | 0 | 640 | NA | 7519 | 10.12395 | 5328.54 |
| 36 | 531.04 | 0 | 205.32 | 6 | 0 | 620 | NA | 1711 | 1.457621 | 174.58 |
| 35 | 672.97 | 0 | 11986.08 | 258 | 0 | 774 | NA | 99884 | 1.157156 | 8090.69 |
| 43 | 299.61 | 0 | 4662.12 | 88 | 0 | 876 | NA | 38851 | 8.914322 | 24243.12 |
| 95 | 371.23 | 0 | 179.28 | 4 | 0 | 881 | NA | 1494 | 18.222691 | 1905.73 |
| 22 | 284.37 | 0 | 125.76 | 3 | 0 | 746 | NA | 1048 | 8.702271 | 638.4 |
| 4 | 670.77 | 0 | 1197.96 | 25 | 0 | 789 | NA | 9983 | 2.942435 | 2056.2 |
| 14 | 586.14 | 0 | 1251 | 31 | 0 | 674 | NA | 10425 | 0.810625 | 591.55 |
| 76 | 293.5 | 0 | 982.32 | 27 | 0 | 589 | NA | 8186 | 17.553303 | 10058.39 |
| 56 | 272.31 | 0 | 233.64 | 7 | 0 | 546 | NA | 1947 | 17.394664 | 2370.72 |
| 8 | 372.85 | 0 | 221.52 | 6 | 0 | 564 | NA | 1846 | 6.463397 | 835.2 |
| 83 | 485.01 | 0 | 737.04 | 18 | 0 | 673 | NA | 6142 | 6.300348 | 2708.77 |
| 91 | 226.3 | 0 | 558.84 | 17 | 0 | 544 | NA | 4657 | 20.194761 | 6583.29 |
| 85 | 493.09 | 0 | 843.96 | 19 | 0 | 731 | NA | 7033 | 9.643346 | 4747.52 |
| 94 | 338.4 | 0 | 1431.48 | 36 | 0 | 654 | NA | 11929 | 15.475537 | 12922.54 |
| 75 | 788.91 | 0 | 105.24 | 2 | 0 | 702 | NA | 877 | 5.173238 | 317.58 |
| 1 | 500.41 | 0 | 206.88 | 4 | 0 | 885 | NA | 1724 | 9.119936 | 1100.59 |
| 73 | 1111.81 | 0 | 166.92 | 3 | 0 | 959 | NA | 1391 | 5.754824 | 560.35 |
| 20 | 424.28 | 0 | 54.84 | 2 | 0 | 511 | NA | 457 | 4.721532 | 151.04 |
| 41 | 204.89 | 0 | 1472.28 | 36 | 0 | 672 | NA | 12269 | 17.26285 | 14825.85 |
| 93 | 274.29 | 0 | 989.4 | 28 | 0 | 582 | NA | 8245 | 8.182696 | 4722.64 |
| 11 | 177.56 | 0 | 1155 | 30 | 0 | 640 | NA | 9625 | 12.729232 | 8576.32 |
| 13 | 596.11 | 0 | 235.44 | 6 | 0 | 697 | NA | 1962 | 1.87974 | 258.16 |
| 60 | 521.18 | 0 | 1468.32 | 26 | 0 | 925 | NA | 12236 | 5.158781 | 4418.6 |
| 29 | 288.87 | 0 | 147 | 3 | 0 | 842 | NA | 1225 | 14.79942 | 1269.05 |
| 2 | 579.44 | 0 | 224.16 | 6 | 0 | 632 | NA | 1868 | 0.239309 | 31.29 |
| 31 | 519.07 | 0 | 2656.44 | 53 | 0 | 826 | NA | 22137 | 6.18266 | 9580.59 |
| 78 | 326.03 | 0 | 188.04 | 5 | 0 | 619 | NA | 1567 | 6.726956 | 737.88 |
| 53 | 409.33 | 0 | 2611.92 | 79 | 0 | 553 | NA | 21766 | 3.979846 | 6063.77 |
| 68 | 693.65 | 0 | 197.52 | 3 | 0 | 995 | NA | 1646 | 5.475298 | 630.86 |
| 46 | 150.17 | 0 | 43.44 | 1 | 0 | 655 | NA | 362 | 16.357044 | 414.49 |
| 16 | 299.6 | 0 | 156.24 | 3 | 0 | 973 | NA | 1302 | 16.218664 | 1478.17 |
| 69 | 71.88 | 0 | 2205.6 | 548 | 0 | 67 | NA | 18380 | 3.545967 | 4562.24 |
| 3 | 69.34 | 0 | 373.8 | 62 | 0 | 100 | NA | 3115 | 4.470973 | 974.9 |
| 59 | 83.67 | 0 | 338.04 | 54 | 0 | 104 | NA | 2817 | 4.999716 | 985.89 |
| 6 | 72.67 | 0 | 168.84 | 29 | 0 | 97 | NA | 1407 | 4.920597 | 484.63 |
| 21 | 19.02 | 0 | 73.2 | 17 | 0 | 71 | NA | 610 | 19.850377 | 847.61 |
| 64 | 98.37 | 0 | 38.76 | 5 | 0 | 119 | NA | 323 | 1.403189 | 31.73 |
| 45 | 27.04 | 0 | 9705.6 | 2378 | 0 | 68 | NA | 80880 | 8.886149 | 50309.82 |
| 34 | 55.03 | 0 | 729.24 | 126 | 0 | 96 | NA | 6077 | 5.595748 | 2380.38 |
| 81 | 52.25 | 0 | 152.76 | 31 | 0 | 83 | NA | 1273 | 4.44839 | 396.4 |
| 87 | 62.12 | 0 | 168 | 33 | 0 | 85 | NA | 1400 | 5.005471 | 490.54 |
| 98 | 32.4 | 0 | 4759.08 | 702 | 0 | 113 | NA | 39659 | 16.597003 | 46075.44 |
| 86 | 25.66 | 0 | 850.08 | 189 | 0 | 75 | NA | 7084 | 12.330339 | 6114.37 |
| 63 | 54.48 | 0 | 5569.56 | 1497 | 0 | 62 | NA | 46413 | 1.427903 | 4639.13 |
| 51 | 39.47 | 0 | 5087.16 | 874 | 0 | 97 | NA | 42393 | 17.761262 | 52706.72 |
| 80 | 98.35 | 0 | 13.2 | 3 | 0 | 91 | NA | 110 | 5.206727 | 40.09 |
| 84 | 1.63 | 0 | 418.56 | 1301 | 0 | 5.36 | NA | 3488 | 20.746846 | 5065.55 |
| 66 | 2.74 | 0 | 147.48 | 323 | 0 | 7.61 | NA | 1229 | 20.015557 | 1721.94 |
| 26 | 5.75 | 0 | 139.32 | 380 | 0 | 6.1 | NA | 1161 | 0.693678 | 56.38 |
| 50 | 4.04 | 0 | 48.48 | 153 | 0 | 5.27 | NA | 404 | 2.255842 | 63.8 |
| 92 | 8.38 | 0 | 526.56 | 1114 | 0 | 7.88 | NA | 4388 | 2.808933 | 862.79 |
| 18 | 3.73 | 0 | 777.72 | 2441 | 0 | 5.31 | NA | 6481 | 5.468252 | 2480.78 |
| 9 | 0 | 2.89 | 7.98 | 0 | 65 | NA | 6.18 | 133 | 14.890977 | 138.64 |
| 48 | 0 | 3.96 | 10.68 | 0 | 109 | NA | 4.9 | 178 | 9.225674 | 114.95 |
| 77 | 0 | 4.34 | 34.32 | 0 | 289 | NA | 5.94 | 572 | 7.857762 | 314.63 |
| 30 | 0 | 3.04 | 45.24 | 0 | 413 | NA | 5.48 | 754 | 26.131048 | 1379.2 |
| 15 | 0 | 4.83 | 55.08 | 0 | 444 | NA | 6.2 | 918 | 4.616972 | 296.69 |
| 58 | 0 | 4.21 | 71.58 | 0 | 530 | NA | 6.75 | 1193 | 13.844895 | 1156.19 |
| 37 | 0 | 3.19 | 35.82 | 0 | 580 | NA | 3.09 | 597 | 3.344673 | 139.77 |
| 79 | 0 | 3.26 | 50.64 | 0 | 619 | NA | 4.09 | 844 | 5.184822 | 306.32 |
| 24 | 0 | 4.05 | 92.4 | 0 | 733 | NA | 6.3 | 1540 | 9.674864 | 1042.95 |
| 97 | 0 | 3.36 | 84.24 | 0 | 818 | NA | 5.15 | 1404 | 20.187457 | 1984.02 |
| 71 | 0 | 2.63 | 109.86 | 0 | 854 | NA | 6.43 | 1831 | 30.310087 | 3884.84 |
| 32 | 0 | 4.49 | 71.7 | 0 | 941 | NA | 3.81 | 1195 | 11.686033 | 977.54 |
| 61 | 0 | 1.48 | 86.46 | 0 | 994 | NA | 4.35 | 1441 | 37.006037 | 3732.8 |
| 23 | 0 | 2.91 | 67.32 | 0 | 1093 | NA | 3.08 | 1122 | 1.850954 | 145.37 |
| 65 | 0 | 1.24 | 91.2 | 0 | 1104 | NA | 4.13 | 1520 | 20.818829 | 2215.12 |
| 17 | 0 | 3.38 | 108.66 | 0 | 1141 | NA | 4.76 | 1811 | 16.910508 | 2143.74 |
| 28 | 0 | 2.16 | 102.06 | 0 | 1379 | NA | 3.7 | 1701 | 9.05254 | 1077.89 |
| 27 | 0 | 4.65 | 170.46 | 0 | 1837 | NA | 4.64 | 2841 | 0.977592 | 194.41 |
| 89 | 0 | 6.82 | 246.12 | 0 | 2075 | NA | 5.93 | 4102 | 10.429115 | 2994.62 |
| 47 | 0 | 4.95 | 271.5 | 0 | 2754 | NA | 4.93 | 4525 | 1.282678 | 406.29 |
| 33 | 0 | 2.42 | 383.94 | 0 | 3014 | NA | 6.37 | 6399 | 24.741842 | 11082.61 |
| 90 | 0 | 3.67 | 452.76 | 0 | 4208 | NA | 5.38 | 7546 | 13.178631 | 6961.22 |
| 70 | 0 | 3.81 | 610.38 | 0 | 5847 | NA | 5.22 | 10173 | 9.350174 | 6658.35 |
| 10 | 0 | 2.61 | 483.42 | 0 | 6771 | NA | 3.57 | 8057 | 11.185653 | 6308.6 |
| 74 | 0 | 4.2 | 773.88 | 0 | 7632 | NA | 5.07 | 12898 | 8.670266 | 7828.04 |
| 25 | 0 | 2.68 | 717.78 | 0 | 9779 | NA | 3.67 | 11963 | 11.013941 | 9223.18 |
| 12 | 0 | 3.5 | 1041.36 | 0 | 15778 | NA | 3.3 | 17356 | 3.742177 | 4546.45 |
| 44 | 0 | 5.04 | 3118.38 | 0 | 32551 | NA | 4.79 | 51973 | 4.366871 | 15887.16 |
| 49 | 0 | 2.3 | 4505.76 | 0 | 44878 | NA | 5.02 | 75096 | 20.377932 | 107121.08 |
| 100 | 0 | 3.53 | 5214.36 | 0 | 51730 | NA | 5.04 | 86906 | 8.238137 | 50116.05 |