Question

1-Jan2010	ND
4-Jan-2010	92.5500
3-Jan-2011	81.5600
2-Jan-2012	ND
3-jan-2012	76.6700
1-Jan-2013	ND
2-Jan-2013	87.1000
1-Jan-2014	ND
2-Jan-2014	104.8400
1-Jan-2015	ND
2-Jan-2015	120.2000
1-Jan-2016	ND
4-Jan-2016	119.3000
2-Jan-2017	ND
3-Jan-2017	117.6800
1-Jan-2018	ND
2-Jan-2018	112.1800
1-Jan-2019	ND
2-Jan-2019	109.2200
1-Jan-2020	ND
2-Jan-2020	108.4300

Look at the data for the Japanese yen from 2000 to the present. Assume that you were in Tokyo for New Year’s Eve from January 1, 2010 to January 1 this year and bought a bento (box lunch) for 1000 yen each year. Convert this amount to dollars for the first day in January that data is available for each of the years you were in Tokyo.

1. Create a chart that plots the dollar price of the bento box overtime on each of the days in January you used.
2. Has the dollar appreciated or depreciated against the yen during this time period?
3. What the least amount in dollars that your box lunch cost ($ amount and date)?
4. What the most amount in dollars that your box lunch cost ($ amount and date)? please Make sure you calculate the US$ price of the bento box for every January between 2010 and the present. please no handwriting

Answer 1

Data provided:

Exchange rate of USD in JPY from 2010 to 2020 as recorded in first day in January for which exchange rate is available.

Cost of bento box purchased each year= 1000 JPY

Solution:

The cost of bento box in USD as per conversion rates provided would be:

The same information charted on a line graph with Year column as X-axis and Price of Bento column in USD as Y-axis would be:

Over the given period of time, USD has appreciated against JPY as on 4-Jan 2010, 1000 yen yielded 10.8050 dollars and on 2-Jan 2020, 1000 yen yields 9.2225 dollars.

Least amount in dollars, the bento box costs is $ 8.3195

Most amount in dollars, the bento box costs is $ 13.0429