Dry Peas 2000-2006

This assignment is due by 11.59PM on Tuesday, November 9, 2021, and it MUST be TYPED. PLEASE ATTACH YOUR ANSWER AS A PDF FILE. THANK YOU. The tables below contain acres harvested and production data for four crops grown in the United States from 1973-2020. You were each assigned seven (7) years to study. 1. 2. 3. Search for your last name in the table above and record the acres harvested and production data for the years you were assigned. Use Excel to plot a graph showing changes in production levels for your study period Compute the average and marginal physical products (APP and MPP) for your study period. You can use Excel to compute APP. Report your answers in thousands; that is, multiply the quotients by 1,000 because production levels are in millions and acres are in thousands and millions divided by thousands equal thousands. NOTE: Acre harvested is the variable input in your production function. Use Excell to plot the APP and MPP curves on one graph Acres harvested on the horizontal axis. With the fourth year (the middle year) in your dataset as the Base Year, compute the output indices. Report your answers as percentages. Explain three of the output indices you calculated. 4. 5. 6. Acres Harvested (1,000 acres) Year Melons Potatoes Sweet Potatoes Dry Beans 1993 1,523 1,618 1321 80 1994 1,566 1,831 1,385 83 1995 1,527 1.896 1,376 83 1996 1,559 1,751 1,426 84 1997 1,541 1,759 1,354 82 1998 1,545 1.918 1,387 84 1999 1,580 1,881 1,332 83 2000 1.751 1,617 1.348 95 2001 1,740 1,250 1,221 94 20021,664 1,739 1,266 82 2003 653 1,347 1250 93 2004 739 1,212 1,166 93 2005 772 1,527 1,086 88 2006 710 1,532 1.120 87 2007 662 1,479 1,122 97 2008 670 1,445 1.047 97 2009 656 1,464 1,044 97 2010 1.486 1.843 1.008 117 2011 2,796 1,079 1,450 130 20122,884 1,139 1,340 127 2013 2,796 1,061 1334 113 2014 2,784 1,065 1,284 135 2015 2.750 1,071 1.266 153 2016 2,895 1,038 1,253 163 20172,572 1,045 1,249 159 2018 2.485 1,015 1.226 144 2019 2,357 942 1,264 147 2020 2.326 914 1.170 157 Dry Peas Lentils 157 143 133 178 209 163 212 140 289 183 317 159 255 175 180 214 200 197 299 215 344 237 532 329 790 439 907 407 821 295 855 261 852 406 729 634 711 411 622 450 797 347 900 259 1084 475 1,331 905 1,052 1,022 808 718 1,052 431 973 514 5.5 Production (million cwt) Year Melons Dry Beans Potatoes Sweet Potatoes 1993330.8 21.9 430.3 11.0 1994 3543 29.0 469.4 13.4 1995 334.4 30.7 445.1 12.8 1996343.0 27.9 499.3 13.2 1997 370.9 29.4 467.1 13.3 1998 350.0 30.4 475.7 12.4 1999 379.0 33.1 478.1 12.2 2000 383.1 26.5 513.5 13.8 2001376.1 19.6 437.7 14.5 2002375.1 30.3 458.2 12.8 2003 442.1 22.5 458.2 15.9 2004 463.9 17.7 455.8 16.1 2005 433.7 26.6 423.8 15.7 2006 436.7 24.2 440.7 16.4 2007 433.8 25.6 444.9 18.1 2008 421.1 25.6 415.1 18.4 2009 415.7 25.4 432.6 19.5 2010 419.2 31.8 404.3 23.8 2011 375.4 17.7 430 27 2012 381.2 28.6 465 26.5 2013 369.1 21 438.7 24.7 2014 369.1 26.1 448.7 29.5 2015 359.8 27.5 448.6 31 2016 399.6 23.3 450.3 31.5 2017 396.9 28.9 450.9 35.6 2018 371.3 25 450 27.4 2019 343 20.8 424 32 2020 348.3 33 414.2 30.7 Dry Peas Lentils 4.3 2.0 3.1 1.9 5.9 2.2 3.3 13 6.5 2.4 6.7 1.9 2.4 4.2 3.0 4.5 2.9 5.5 2.6 6.0 2.4 12.6 4.2 15.0 5.2 14.1 3.2 16.9 3.7 13.0 2.4 18.2 5.8 15.0 8.7 15.6 4.7 11 5.3 15.6 5 17.2 3.4 18.3 5.3 17.8 7.8 14.2 7.5 15.9 8.4 22.3 5.4 21.7 7.4 UNA POO civo NON This assignment is due by 11.59PM on Tuesday, November 9, 2021, and it MUST be TYPED. PLEASE ATTACH YOUR ANSWER AS A PDF FILE. THANK YOU. The tables below contain acres harvested and production data for four crops grown in the United States from 1973-2020. You were each assigned seven (7) years to study. 1. 2. 3. Search for your last name in the table above and record the acres harvested and production data for the years you were assigned. Use Excel to plot a graph showing changes in production levels for your study period Compute the average and marginal physical products (APP and MPP) for your study period. You can use Excel to compute APP. Report your answers in thousands; that is, multiply the quotients by 1,000 because production levels are in millions and acres are in thousands and millions divided by thousands equal thousands. NOTE: Acre harvested is the variable input in your production function. Use Excell to plot the APP and MPP curves on one graph Acres harvested on the horizontal axis. With the fourth year (the middle year) in your dataset as the Base Year, compute the output indices. Report your answers as percentages. Explain three of the output indices you calculated. 4. 5. 6. Acres Harvested (1,000 acres) Year Melons Potatoes Sweet Potatoes Dry Beans 1993 1,523 1,618 1321 80 1994 1,566 1,831 1,385 83 1995 1,527 1.896 1,376 83 1996 1,559 1,751 1,426 84 1997 1,541 1,759 1,354 82 1998 1,545 1.918 1,387 84 1999 1,580 1,881 1,332 83 2000 1.751 1,617 1.348 95 2001 1,740 1,250 1,221 94 20021,664 1,739 1,266 82 2003 653 1,347 1250 93 2004 739 1,212 1,166 93 2005 772 1,527 1,086 88 2006 710 1,532 1.120 87 2007 662 1,479 1,122 97 2008 670 1,445 1.047 97 2009 656 1,464 1,044 97 2010 1.486 1.843 1.008 117 2011 2,796 1,079 1,450 130 20122,884 1,139 1,340 127 2013 2,796 1,061 1334 113 2014 2,784 1,065 1,284 135 2015 2.750 1,071 1.266 153 2016 2,895 1,038 1,253 163 20172,572 1,045 1,249 159 2018 2.485 1,015 1.226 144 2019 2,357 942 1,264 147 2020 2.326 914 1.170 157 Dry Peas Lentils 157 143 133 178 209 163 212 140 289 183 317 159 255 175 180 214 200 197 299 215 344 237 532 329 790 439 907 407 821 295 855 261 852 406 729 634 711 411 622 450 797 347 900 259 1084 475 1,331 905 1,052 1,022 808 718 1,052 431 973 514 5.5 Production (million cwt) Year Melons Dry Beans Potatoes Sweet Potatoes 1993330.8 21.9 430.3 11.0 1994 3543 29.0 469.4 13.4 1995 334.4 30.7 445.1 12.8 1996343.0 27.9 499.3 13.2 1997 370.9 29.4 467.1 13.3 1998 350.0 30.4 475.7 12.4 1999 379.0 33.1 478.1 12.2 2000 383.1 26.5 513.5 13.8 2001376.1 19.6 437.7 14.5 2002375.1 30.3 458.2 12.8 2003 442.1 22.5 458.2 15.9 2004 463.9 17.7 455.8 16.1 2005 433.7 26.6 423.8 15.7 2006 436.7 24.2 440.7 16.4 2007 433.8 25.6 444.9 18.1 2008 421.1 25.6 415.1 18.4 2009 415.7 25.4 432.6 19.5 2010 419.2 31.8 404.3 23.8 2011 375.4 17.7 430 27 2012 381.2 28.6 465 26.5 2013 369.1 21 438.7 24.7 2014 369.1 26.1 448.7 29.5 2015 359.8 27.5 448.6 31 2016 399.6 23.3 450.3 31.5 2017 396.9 28.9 450.9 35.6 2018 371.3 25 450 27.4 2019 343 20.8 424 32 2020 348.3 33 414.2 30.7 Dry Peas Lentils 4.3 2.0 3.1 1.9 5.9 2.2 3.3 13 6.5 2.4 6.7 1.9 2.4 4.2 3.0 4.5 2.9 5.5 2.6 6.0 2.4 12.6 4.2 15.0 5.2 14.1 3.2 16.9 3.7 13.0 2.4 18.2 5.8 15.0 8.7 15.6 4.7 11 5.3 15.6 5 17.2 3.4 18.3 5.3 17.8 7.8 14.2 7.5 15.9 8.4 22.3 5.4 21.7 7.4 UNA POO civo NON