Calculate the descriptive statistics of the US Effective Federal Funds Rates. Based on the results you obtained, discuss the information about the mean, standard deviation, skewness, kurtosis, median and first and third quartiles of the time series.
Quantitative Method and Economics
Coursework Assignment
The coursework requires you to use the methods you have learnt to analyse the data in the
Excel file coursework data.csv. The data set contains information on the Crude oil prices, Dow Jones Industrial Average, US CCI (Consumer Confidence Index) and US Effective Federal Funds Rate, during the period between January 2009 and December 2018.
(1) Use the information that can be obtained from the time series plot and acf plot of the data to discuss the stationarity of each time series in the data set. Please also include the graphs you obtained as part of your answer to the question.
(2) Calculate the descriptive statistics of the US Effective Federal Funds Rates. Based on the results you obtained, discuss the information about the mean, standard deviation, skewness, kurtosis, median and first and third quartiles of the time series. Please also include a table containing the results you obtained as part of your answer to the question.
(3) Use all time series given in the data set and the relevant results you obtained in the above two questions to estimate a linear regression model and show the details of your analysis.
Please include the following in your answer to this question: your research question, a brief explanation of why you can use a linear regression model to answer your research question, a table containing the estimation results you obtained, and the detailed work of your analysis
