https://www.edx.org/course/data-analysis-take-it-max-delftx-ex101x
Instructor: Prof. Felienne Hermans, PhD.
Assignment 1.6. Webstream. (unfortunately Sparkline's graphs are not rendered in this Google Docs web embedding..)
Note: if you don't see a spreadsheet table below, then big chances your connection/browser has problem accessing docs.google.com.
This is assignment on webstream, to get data from the web inside MS Excel. (Tool | From Web).
- The data is real-time exchange rate of USD - Yen in the last 6 months.
- http://exchange-rates.org/history/JPY/USD/T
- First 4 columns are original data.
- Seventh column (Graph) has sparklines graphs (does not appear in this web embed) to illustrate the dynamic of the rate, and stats.
- Fifth column gives data analysis whether the exchange rate value is "Up" or "Down" compared to the previous day's value.
- Sixth column gives the delta (difference) between the rate value and previous day's value.
- Note: the date when this assignment is done: 31 August 2015.
- Charts: count of up/down gives illustration of percentage of the rate fluctuation.
- Histogram of rate presents illustration of how many each value occurs.
- Delta vs date gives graphical illustration of the fluctuation of the daily difference of the exchange rate.
