Project Part (a): Using the daily gold price data found on “Gold Historical Prices.xlsx” and the code from ISB_R_Session4.R which cleans the data, you have to transform the data from daily to yearly...

• There are3 deliverablesfor part A –

1. R Code (.R file)


2. Report or Text file (Word or PDF format). Kindly remember toadd R Code as text in the appendix
   


3. Cleaned .csv file (output of R Code)

Project Part (a): Using the daily gold price data found on “Gold Historical Prices.xlsx” and the code from ISB_R_Session4.R which cleans the data, you have to transform the data from daily to yearly starting in 2000-2018. Disregard previous years. For the yearly data that you have to make, use the yearly average and also report 95% confidence intervals for this yearly average. Make a .csv file with columns the year, the average price for this year, the lower limit of the confidence interval and the higher limit of the confidence interval. Identify the year(s) in which the change, up or down, of the price of gold was higher or lower than expected. Are there any social event(s) (political, etc.) that can explain (provide causality) for these unexpected changes? The deliverables of the project will be (a) R code making the csv file. It is important that the csv file is clean without NAs. (b) text explaining (provide causality) which yearly changes up or down of the gold price history you consider unexpected (i.e. difficult to predict by looking at the data of previous years).