Answered step by step
Verified Expert Solution
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
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 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
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