Can you show me how to do this question? I can't fit the full data sheet onto here as it is too long but can you show me the working out of how to do this question on Excel, thank you!

Overnight Interest Rates	% per annum
	GBP (365 day count)	USD (360 day count)
01/01/2016	0,44563	0,2745
04/01/2016	0,47813	0,3658
05/01/2016	0,4775	0,365
06/01/2016	0,4775	0,3661
07/01/2016	0,4775	0,3651
08/01/2016	0,4775	0,3662
11/01/2016	0,4775	0,3661
12/01/2016	0,4775	0,3661
13/01/2016	0,47813	0,3663
14/01/2016	0,47875	0,3661
15/01/2016	0,48	0,3661
18/01/2016	0,48125
19/01/2016	0,48125	0,366
20/01/2016	0,48063	0,3655
21/01/2016	0,48063	0,3658
22/01/2016	0,48125	0,3659
25/01/2016	0,48063	0,366
26/01/2016	0,48063	0,3657
27/01/2016	0,48063	0,3659
28/01/2016	0,48063	0,3684
29/01/2016	0,47813	0,3674

Daily USD/GBP Spot and Forward Rates
1GBP=USD
	Spot	Forwards
		ON	1 Week
	GBP=	GBPONV=	GBPSWV=
	Bid Price	Bid Price	Bid Price
01/01/2016	1,4743	1,477952	1,474311
04/01/2016	1,4715	1,472285	1,472318
05/01/2016	1,4671	1,466784	1,466799
06/01/2016	1,4626	1,462791	1,462795
07/01/2016	1,4615	1,461897	1,461893
08/01/2016	1,4517	1,452493	1,45249
11/01/2016	1,4538	1,453695	1,453696
12/01/2016	1,4443	1,443894	1,443897
13/01/2016	1,4406	1,443191	1,443202
14/01/2016	1,4413	1,440493	1,440501
15/01/2016	1,4254	1,425696	1,425698
18/01/2016	1,4241	1,423581	1,423602
19/01/2016	1,4155	1,416992	1,417005
20/01/2016	1,419	1,417393	1,417405
21/01/2016	1,4217	1,422698	1,422695
22/01/2016	1,4263	1,426997	1,426992
25/01/2016	1,4247	1,425103	1,425093
26/01/2016	1,435	1,434894	1,434897
27/01/2016	1,4229	1,424388	1,424395
28/01/2016	1,4357	1,435293	1,435302
29/01/2016	1,4245	1,424484	1,424495

On Thursday, June 23,2016 , electorate in the United Kingdom and Gibraltar voted in the referendum on whether to Remain or Leave the European Union. Voting started at 0700BST and finished at 2200BST. The final result was announced at 0720BST, June 24, 2016. We will take a look at the exchange rate movements during this period. Sheet "Part IIIA" includes daily data in 2016 (Jan 1 Dec 30) covering the spot, overnight (ON) and one-week forward rates for GBP-USD pair. Sheet "Part IIB" includes the daily LIBOR rates for GBP and USD in per annum terms (the day count per year for GBP and USD are 365 and 360 days respectively) 2. 1. Find the rate of change of the spot rate St:et+1=St+1/St. Plot the time-series of et+1. Report the mean, standard deviation, max and min of e. Find out the dates for the max, min. (15 marks) On Thursday, June 23,2016 , electorate in the United Kingdom and Gibraltar voted in the referendum on whether to Remain or Leave the European Union. Voting started at 0700BST and finished at 2200BST. The final result was announced at 0720BST, June 24, 2016. We will take a look at the exchange rate movements during this period. Sheet "Part IIIA" includes daily data in 2016 (Jan 1 Dec 30) covering the spot, overnight (ON) and one-week forward rates for GBP-USD pair. Sheet "Part IIB" includes the daily LIBOR rates for GBP and USD in per annum terms (the day count per year for GBP and USD are 365 and 360 days respectively) 2. 1. Find the rate of change of the spot rate St:et+1=St+1/St. Plot the time-series of et+1. Report the mean, standard deviation, max and min of e. Find out the dates for the max, min. (15 marks)