Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a box and whisker plot of implicit costs per $1 total revenue. What are the maximum and minimum values of this value? What is
Create a box and whisker plot of implicit costs per $1 total revenue. What are the maximum and minimum values of this value? What is the interquartile range? (Hint: select the data and go to Insert->See All Charts. Consider adding values to your chart.) Minimum = Maximum Value = Interquartile Range =
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) | Explicit Costs |
1 | 500.41 | 0 | 206.88 | 4 | 0 | 885 | 1724 | 9.119936 | 1100.59 | 0 | |
2 | 579.44 | 0 | 224.16 | 6 | 0 | 632 | 1868 | 0.239309 | 31.29 | 803.6 | |
3 | 69.34 | 0 | 373.8 | 62 | 0 | 100 | 3115 | 4.470973 | 974.9 | 443.14 | |
4 | 670.77 | 0 | 1197.96 | 25 | 0 | 789 | 9983 | 2.942435 | 2056.2 | 1868.73 | |
5 | 364.34 | 0 | 4625.64 | 82 | 0 | 938 | 38547 | 22.018249 | 59411.62 | 4989.98 | |
6 | 72.67 | 0 | 168.84 | 29 | 0 | 97 | 1407 | 4.920597 | 484.63 | 241.51 | |
7 | 328.31 | 0 | 256.08 | 4 | 0 | 992 | 2134 | 7.814499 | 1167.33 | 584.39 | |
8 | 372.85 | 0 | 221.52 | 6 | 0 | 564 | 1846 | 6.463397 | 835.2 | 594.37 | |
9 | 0 | 2.89 | 7.98 | 0 | 65 | 6.18 | 133 | 14.890977 | 138.64 | 10.87 | |
10 | 0 | 2.61 | 483.42 | 0 | 6771 | 3.57 | 8057 | 11.185653 | 6308.6 | 486.03 | |
11 | 177.56 | 0 | 1155 | 30 | 0 | 640 | 9625 | 12.729232 | 8576.32 | 1332.56 | |
12 | 0 | 3.5 | 1041.36 | 0 | 15778 | 3.3 | 17356 | 3.742177 | 4546.45 | 1044.86 | |
13 | 596.11 | 0 | 235.44 | 6 | 0 | 697 | 1962 | 1.87974 | 258.16 | 831.55 | |
14 | 586.14 | 0 | 1251 | 31 | 0 | 674 | 10425 | 0.810625 | 591.55 | 1837.14 | |
15 | 0 | 4.83 | 55.08 | 0 | 444 | 6.2 | 918 | 4.616972 | 296.69 | 59.91 | |
16 | 299.6 | 0 | 156.24 | 3 | 0 | 973 | 1302 | 16.218664 | 1478.17 | 455.84 | |
17 | 0 | 3.38 | 108.66 | 0 | 1141 | 4.76 | 1811 | 16.910508 | 2143.74 | 112.04 | |
18 | 3.73 | 0 | 777.72 | 2441 | 0 | 5.31 | 6481 | 5.468252 | 2480.78 | 781.45 | |
19 | 375.2 | 0 | 2712.6 | 58 | 0 | 780 | 22605 | 9.140271 | 14463.11 | 3087.8 | |
20 | 424.28 | 0 | 54.84 | 2 | 0 | 511 | 457 | 4.721532 | 151.04 | 479.12 | |
21 | 19.02 | 0 | 73.2 | 17 | 0 | 71 | 610 | 19.850377 | 847.61 | 92.22 | |
22 | 284.37 | 0 | 125.76 | 3 | 0 | 746 | 1048 | 8.702271 | 638.4 | 410.13 | |
23 | 0 | 2.91 | 67.32 | 0 | 1093 | 3.08 | 1122 | 1.850954 | 145.37 | 70.23 | |
24 | 0 | 4.05 | 92.4 | 0 | 733 | 6.3 | 1540 | 9.674864 | 1042.95 | 96.45 | |
25 | 0 | 2.68 | 717.78 | 0 | 9779 | 3.67 | 11963 | 11.013941 | 9223.18 | 720.46 | |
26 | 5.75 | 0 | 139.32 | 380 | 0 | 6.1 | 1161 | 0.693678 | 56.38 | 145.07 | |
27 | 0 | 4.65 | 170.46 | 0 | 1837 | 4.64 | 2841 | 0.977592 | 194.41 | 175.11 | |
28 | 0 | 2.16 | 102.06 | 0 | 1379 | 3.7 | 1701 | 9.05254 | 1077.89 | 104.22 | |
29 | 288.87 | 0 | 147 | 3 | 0 | 842 | 1225 | 14.79942 | 1269.05 | 435.87 | |
30 | 0 | 3.04 | 45.24 | 0 | 413 | 5.48 | 754 | 26.131048 | 1379.2 | 48.28 | |
31 | 519.07 | 0 | 2656.44 | 53 | 0 | 826 | 22137 | 6.18266 | 9580.59 | 3175.51 | |
32 | 0 | 4.49 | 71.7 | 0 | 941 | 3.81 | 1195 | 11.686033 | 977.54 | 76.19 | |
33 | 0 | 2.42 | 383.94 | 0 | 3014 | 6.37 | 6399 | 24.741842 | 11082.61 | 386.36 | |
34 | 55.03 | 0 | 729.24 | 126 | 0 | 96 | 6077 | 5.595748 | 2380.38 | 784.27 | |
35 | 672.97 | 0 | 11986.08 | 258 | 0 | 774 | 99884 | 1.157156 | 8090.69 | 12659.05 | |
36 | 531.04 | 0 | 205.32 | 6 | 0 | 620 | 1711 | 1.457621 | 174.58 | 736.36 | |
37 | 0 | 3.19 | 35.82 | 0 | 580 | 3.09 | 597 | 3.344673 | 139.77 | 39.01 | |
38 | 394.05 | 0 | 149.28 | 3 | 0 | 820 | 1244 | 18.296109 | 1593.23 | 543.33 | |
39 | 166.04 | 0 | 902.28 | 24 | 0 | 640 | 7519 | 10.12395 | 5328.54 | 1068.32 | |
40 | 600.53 | 0 | 211.44 | 3 | 0 | 998 | 1762 | 7.449563 | 918.83 | 811.97 | |
41 | 204.89 | 0 | 1472.28 | 36 | 0 | 672 | 12269 | 17.26285 | 14825.85 | 1677.17 | |
42 | 683.59 | 0 | 920.88 | 25 | 0 | 611 | 7674 | 3.533534 | 1898.14 | 1604.47 | |
43 | 299.61 | 0 | 4662.12 | 88 | 0 | 876 | 38851 | 8.914322 | 24243.12 | 4961.73 | |
44 | 0 | 5.04 | 3118.38 | 0 | 32551 | 4.79 | 51973 | 4.366871 | 15887.16 | 3123.42 | |
45 | 27.04 | 0 | 9705.6 | 2378 | 0 | 68 | 80880 | 8.886149 | 50309.82 | 9732.64 | |
46 | 150.17 | 0 | 43.44 | 1 | 0 | 655 | 362 | 16.357044 | 414.49 | 193.61 | |
47 | 0 | 4.95 | 271.5 | 0 | 2754 | 4.93 | 4525 | 1.282678 | 406.29 | 276.45 | |
48 | 0 | 3.96 | 10.68 | 0 | 109 | 4.9 | 178 | 9.225674 | 114.95 | 14.64 | |
49 | 0 | 2.3 | 4505.76 | 0 | 44878 | 5.02 | 75096 | 20.377932 | 107121.08 | 4508.06 | |
50 | 4.04 | 0 | 48.48 | 153 | 0 | 5.27 | 404 | 2.255842 | 63.8 | 52.52 | |
51 | 39.47 | 0 | 5087.16 | 874 | 0 | 97 | 42393 | 17.761262 | 52706.72 | 5126.63 | |
52 | 483.01 | 0 | 3166.56 | 65 | 0 | 804 | 26388 | 11.989788 | 22147.06 | 3649.57 | |
53 | 409.33 | 0 | 2611.92 | 79 | 0 | 553 | 21766 | 3.979846 | 6063.77 | 3021.25 | |
54 | 128.31 | 0 | 102.6 | 3 | 0 | 518 | 855 | 10.608187 | 634.9 | 230.91 | |
55 | 655.15 | 0 | 3704.04 | 80 | 0 | 770 | 30867 | 2.742335 | 5925.34 | 4359.19 | |
56 | 272.31 | 0 | 233.64 | 7 | 0 | 546 | 1947 | 17.394664 | 2370.72 | 505.95 | |
57 | 1055.75 | 0 | 170.16 | 3 | 0 | 997 | 1418 | 5.015677 | 497.86 | 1225.91 | |
58 | 0 | 4.21 | 71.58 | 0 | 530 | 6.75 | 1193 | 13.844895 | 1156.19 | 75.79 | |
59 | 83.67 | 0 | 338.04 | 54 | 0 | 104 | 2817 | 4.999716 | 985.89 | 421.71 | |
60 | 521.18 | 0 | 1468.32 | 26 | 0 | 925 | 12236 | 5.158781 | 4418.6 | 1989.5 | |
61 | 0 | 1.48 | 86.46 | 0 | 994 | 4.35 | 1441 | 37.006037 | 3732.8 | 87.94 | |
62 | 609.02 | 0 | 1878.48 | 32 | 0 | 969 | 15654 | 9.20658 | 10088.39 | 2487.5 | |
63 | 54.48 | 0 | 5569.56 | 1497 | 0 | 62 | 46413 | 1.427903 | 4639.13 | 5624.04 | |
64 | 98.37 | 0 | 38.76 | 5 | 0 | 119 | 323 | 1.403189 | 31.73 | 137.13 | |
65 | 0 | 1.24 | 91.2 | 0 | 1104 | 4.13 | 1520 | 20.818829 | 2215.12 | 92.44 | |
66 | 2.74 | 0 | 147.48 | 323 | 0 | 7.61 | 1229 | 20.015557 | 1721.94 | 150.22 | |
67 | 748.51 | 0 | 67.92 | 2 | 0 | 651 | 566 | 9.467261 | 375.09 | 816.43 | |
68 | 693.65 | 0 | 197.52 | 3 | 0 | 995 | 1646 | 5.475298 | 630.86 | 891.17 | |
69 | 71.88 | 0 | 2205.6 | 548 | 0 | 67 | 18380 | 3.545967 | 4562.24 | 2277.48 | |
70 | 0 | 3.81 | 610.38 | 0 | 5847 | 5.22 | 10173 | 9.350174 | 6658.35 | 614.19 | |
71 | 0 | 2.63 | 109.86 | 0 | 854 | 6.43 | 1831 | 30.310087 | 3884.84 | 112.49 | |
72 | 801.83 | 0 | 215.04 | 5 | 0 | 711 | 1792 | 6.915977 | 867.54 | 1016.87 | |
73 | 1111.81 | 0 | 166.92 | 3 | 0 | 959 | 1391 | 5.754824 | 560.35 | 1278.73 | |
74 | 0 | 4.2 | 773.88 | 0 | 7632 | 5.07 | 12898 | 8.670266 | 7828.04 | 778.08 | |
75 | 788.91 | 0 | 105.24 | 2 | 0 | 702 | 877 | 5.173238 | 317.58 | 894.15 | |
76 | 293.5 | 0 | 982.32 | 27 | 0 | 589 | 8186 | 17.553303 | 10058.39 | 1275.82 | |
77 | 0 | 4.34 | 34.32 | 0 | 289 | 5.94 | 572 | 7.857762 | 314.63 | 38.66 | |
78 | 326.03 | 0 | 188.04 | 5 | 0 | 619 | 1567 | 6.726956 | 737.88 | 514.07 | |
79 | 0 | 3.26 | 50.64 | 0 | 619 | 4.09 | 844 | 5.184822 | 306.32 | 53.9 | |
80 | 98.35 | 0 | 13.2 | 3 | 0 | 91 | 110 | 5.206727 | 40.09 | 111.55 | |
81 | 52.25 | 0 | 152.76 | 31 | 0 | 83 | 1273 | 4.44839 | 396.4 | 205.01 | |
82 | 275.58 | 0 | 220.32 | 6 | 0 | 645 | 1836 | 16.009858 | 2057.59 | 495.9 | |
83 | 485.01 | 0 | 737.04 | 18 | 0 | 673 | 6142 | 6.300348 | 2708.77 | 1222.05 | |
84 | 1.63 | 0 | 418.56 | 1301 | 0 | 5.36 | 3488 | 20.746846 | 5065.55 | 420.19 | |
85 | 493.09 | 0 | 843.96 | 19 | 0 | 731 | 7033 | 9.643346 | 4747.52 | 1337.05 | |
86 | 25.66 | 0 | 850.08 | 189 | 0 | 75 | 7084 | 12.330339 | 6114.37 | 875.74 | |
87 | 62.12 | 0 | 168 | 33 | 0 | 85 | 1400 | 5.005471 | 490.54 | 230.12 | |
88 | 363.98 | 0 | 153.36 | 5 | 0 | 551 | 1278 | 11.301408 | 1011.02 | 517.34 | |
89 | 0 | 6.82 | 246.12 | 0 | 2075 | 5.93 | 4102 | 10.429115 | 2994.62 | 252.94 | |
90 | 0 | 3.67 | 452.76 | 0 | 4208 | 5.38 | 7546 | 13.178631 | 6961.22 | 456.43 | |
91 | 226.3 | 0 | 558.84 | 17 | 0 | 544 | 4657 | 20.194761 | 6583.29 | 785.14 | |
92 | 8.38 | 0 | 526.56 | 1114 | 0 | 7.88 | 4388 | 2.808933 | 862.79 | 534.94 | |
93 | 274.29 | 0 | 989.4 | 28 | 0 | 582 | 8245 | 8.182696 | 4722.64 | 1263.69 | |
94 | 338.4 | 0 | 1431.48 | 36 | 0 | 654 | 11929 | 15.475537 | 12922.54 | 1769.88 | |
95 | 371.23 | 0 | 179.28 | 4 | 0 | 881 | 1494 | 18.222691 | 1905.73 | 550.51 | |
96 | 372.23 | 0 | 205.2 | 5 | 0 | 716 | 1710 | 6.352731 | 760.42 | 577.43 | |
97 | 0 | 3.36 | 84.24 | 0 | 818 | 5.15 | 1404 | 20.187457 | 1984.02 | 87.6 | |
98 | 32.4 | 0 | 4759.08 | 702 | 0 | 113 | 39659 | 16.597003 | 46075.44 | 4791.48 | |
99 | 715.86 | 0 | 76.92 | 2 | 0 | 693 | 641 | 1.770608 | 79.45 | 792.78 | |
100 | 0 | 3.53 | 5214.36 | 0 | 51730 | 5.04 | 86906 | 8.238137 | 50116.05 | 5217.89 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started