Subject Code & Title : ACFI7027 Quantitative Methods For Finance
Assignment Type : Assessment 1
Objectives :- The assignment tests your understanding of the first six weeks of the course, with a focus on using statistics on finance. You are required to analyse data and, most importantly, explain clearly what you have done.
Required :- There are two tasks to complete. For both you are required to clearly explain the method you are using for a person who is familiar with mean and standard deviation, but does not have any statistical knowledge beyond that. No references are needed.
ACFI7027 Quantitative Methods For Finance Assessment 1 Mid-term Practical Data Analysis – UK.

Learning outcomes assessed :

2.Understand the main ways of using descriptive statistics to summarise financial information and the fundamental principles of statistical inference and hypothesis testing and their relevance to financial enquiry
4.Critically evaluate mathematical and statistical results, drawing conclusions from them and presenting quantitative data in the appropriate manner
5.Perform computer-aided data analysis using Excel

Task 1 :-
1.Download weekly price data from 1 January 2018 to 30 June 2021 for a stock of your choice that is traded on the London Stock Exchange.
2.Calculate the return for each trading week and the average weekly return for the year.
3.Use this data to test whether the average weekly return over the period was significantly different from +0.1%.
4.Using Word, or a similar word-processing app, create a 1-2 page explanation of what you have done, incorporating any helpful data or graphics from your analysis. You will not submit an Excel or Gretl file, so the word-processed file
is the only one you will submit.

Task 2 :-
In the past there has been evidence of a ‘January effect’ in stock returns – that returns in January are significantly different from returns in other months. This task requires you to investigate this for your chosen stock.