Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with the following excel assignment YEAR SPECIES METRIC TONS POUNOS(thousands) VALUE millions PRICE/LB 20135/lb Total Change Percent Change T The spreadsheet gives

image text in transcribedI need help with the following excel assignment

YEAR SPECIES METRIC TONS POUNOS(thousands) VALUE millions PRICE/LB 20135/lb Total Change Percent Change T The spreadsheet gives d ata on the catch in Maine of baby American eels, also known as glass eels for their translucent $0.40 3.82 $2.24 1.54 2.28 0.12 $0.16 14B 2 appearance, or elvers. Ee's do not reproduce in captivity thus baby eels must be caught and raised in aquaculture operations to satsfy demand in Asa. Source: http:/wwww.maine.gov/dmr/commercialfishing/historicaldata.htm CPl: httoJ/www.bls.gowicpivcpid1403.pdr 1995 ELVER 158.9 160 5 4.62 10.179 7 36 997 ELVER 1998 ELV 1999 ELV 2000 ELVER 2001 ELVER 2002 EL 2003 ELV 2004 ELVER 2005 EL 2006 EL 2007 ELVER 2008 ELVER 2009 EL 3.34 1.73 1.19 0,77 168.8 172 2 2.625 a.) Compute the Price/lb. 9.654 3.325 1.282 0.28 0.08 50.12 79.9 104.0 188.0 1.51 12 b) Use the CPI values to corvert the Pricelb into 2013S/lb. 2.48 3.16 6.957 3.714 6.9515 5.199 $0.43 $1.29 5149 0.52 0.58 $7.65 538.76 $32.93 $8.47 $1142 15 16 207.342 215.303 3.15 2.36 1.43 3.89 9.42 c.) Compse the annual total change in 20135/lb and the percent change. 19 2011 ELVER 2012 ELVER 8.585 20,764 224.939 229,594 d) Make a well-labeled line chart showing the % change over time. 4.4 2.39 23 2015 ELVER 5.2594 237.017 26 27 30 #5 Elvers Ready + 100%

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

Step: 3

blur-text-image

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

Managerial Accounting

Authors: Paul E. Dascher, Jerry R. Strawser, Robert H. Strawser, Ronald M. Copeland

8th Edition

0873937643, 978-0873937641

More Books

Students also viewed these Accounting questions