Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Numerical Algebra Matrix Theory Differential Algebraic Equations And Control Theory

Authors: Peter Benner, Matthias Bollhöfer, Daniel Kressner, Christian Mehl, Tatjana Stykel

1st Edition

3319152602, 9783319152608

More Books

Students also viewed these Mathematics questions

Question

give an example of a time you experienced a contrary outcome

Answered: 1 week ago

Question

2. Ask questions, listen rather than attempt to persuade.

Answered: 1 week ago