雷恩一大 會員中心 TAG標簽
網站地圖 RSS
英國coursework代寫
雷恩一大

雷恩特专业祛痘怎么样:英國Fiance Coursework:explore whether past dividend yields and

時間:2019-08-05 09:41來源:未知 作者:anne 點擊:
在本課程中,我們的目標是探討過去的股息收益率和股票回報率是否能預測股票回報率。數據集都在討論中。 1)下載與您的作業對應的Excel文件。該文件名為Shiller DataCourseWork DataSet.xlsx。 2)請
在本課程中,我們的目標是探討過去的股息收益率和股票回報率是否能預測股票回報率。數據集都在討論中。
 
1)下載與您的作業對應的Excel文件。該文件名為“Shiller Data–CourseWork DataSet.xlsx”。
2)請您回答以下四個問題。填寫這份Word文檔并將其作為你的課程作業提交。保留本文檔的頁邊空白和每個問題下面給出的模板,并使用11磅。在寫答案時字體或更大。請記住,字跡不清或格式不正確的答案將要付出代價。
[20分]在您的Excel文件中,B列包含股票市場指數的月末價值,C列包含指數中所有股票的每月總股息支付,均以名義美元支付??莢路薟煌謔菁?,但結束月份在所有情況下都是2016年12月。In this coursework, our goal is to explore whether past dividend yields and past stock returns can predict stock returns. The data sets are all on Moodle, under Week 19.
1) Download the Excel file that corresponds to your assignment. The file has the name “Shiller data – coursework dataset.xlsx”. 
2) You are asked to answer the four questions below. Fill in this Word document and submit it as your coursework. Keep the margins of this documentand the templates given underneath each question as they are and use a 11 pt. font or larger when writing up your answers. Keep in mind that illegible or badly formatted answers will cost marks.  

COURSEWORK QUESTIONS課程作業問題
[20分]在您的Excel文件中,B列包含股票市場指數的月末價值,C列包含指數中所有股票的每月總股息支付,均以名義美元支付??莢路薟煌謔菁?,但結束月份在所有情況下都是2016年12月。
[20 marks]In your Excel file,column B contains the end-month value of a stock market index and column C contains the monthly aggregate dividend payment from all stocks in the index, both in nominal dollars. The starting month differs from data set to data set, but the ending month is December 2016 in all cases.  

確定整個時間段的rt、dt和rt,并在下框中的表格中生成其樣本統計數據(平均值、中位數、標準偏差、偏度、峰度)。然后,在同一個框中再次回答以下問題:
哪一個系列更具變化性,價格回報率還是股息收益率?你對價格回報率序列的偏態統計有何解釋?在這一時期投資股市指數是一個好的投資決策嗎?證明你的回答是正確的。Determine rt, dt and Rtfor the entire time period and produce their sample statistics (mean, median, standard deviation, skewness, kurtosis) in a table in the box below. Then, answer the following questions, again in the same box: 
Which series is more variable, the price return or the dividend yield? What is your interpretation of the skewness statistics for the price return series? Does investing in the stock market index in this period appear to be a good investment decision? Justify your answer. 
 

The standard deviation andvariance can describe the volatility of variable. The greater value of the variance, the higher volatility of the series. The standard deviation of the price return and the dividend yield are 0.042 and 0.016 respectively. The price return has the higher standard deviation and volatility. Thus, the series of the monthly price return is more variable. The skewness can measure the asymmetry of the probability distribution of series about mean value.  Ifskewness>0, there is positive skew. If skewness<0, there is negative skew. If the skewness close to zero, the distribution is symmetry. The skewness of price return is 0.481>0, the series of price return is positive skew. 
The mean value of the price return and the dividend yield are 0.005 and 0.0042, that is, the monthly total returnis  0.047. In addition, the standard deviation of the monthly total return is 0.045, which is relative smaller. Thus, the stock market index in this period appear to be gain profit but with low risks. Therefore, investing in the stock market index in this period appear to be a good investment decision. 

where  ε_tis an error term. Note that your independent variables are the total return and dividend yield from the previous month. Copy and paste your Excel regression output in the box provided below: 
 
Is the model able to explain index returns with some success? Comment using the r-square from the OLS output. Comment on this outcome in the context of market efficiency, i.e. would you expect stock returns to be predictable when one uses past data that is easily obtainable? 
 
Type your answer here.
The r-square from the regression model is 0.205, which is relatively low. Thus, the good of fitness is relative low. In other words, only 20.5% of the variation in our dependent variable is explained by the model. The remaining 79.5% is due to noise, i.e. the cumulative effect of factors we have not included in the model. Thus, the model is not able to explain index return with some success. Even though the good of fitness is relatively low, this model has two individually statistically insignificant coefficient estimates. Thus, the model has relatively market efficiency. 
 
Predict the total return for the index when the previous month’s total return is +0.03 and the previous month’s dividend yield is 0.005. 

3) [15 marks]Test thenull hypothesis that β_2=1using a two-tailed test. Show your calculation of the test statistic. Make sure that you state the null and alternative hypotheses, the degrees of freedom used and the critical value from the Student’s t-distribution. 

4) [35 marks] Wewill now examine if adding one more lag of returns and dividend yields to the model above will improve its explanatory power. Run the following model in Excel: 

Perform an F-test to see if we should pick the shorter model from Q2 or the longer model given in this question. Carefully state your null and alternative hypotheses, the numerator and denominator degrees of freedom you are using to determine the critical value from the F-table, and the 5% critical value from the F-distribution. Which model is better to use according to the result of your F-test? 

How could we proceed, along the lines of the modification to the model in Q2 that we made above in this question, in our search for better explanatory power? Briefly explain. 
 
Type your answer here.
The time series of the monthly dividend yield and the monthly total return maybe not stationary. In order to process in our search, we can translate the time series of both the monthly dividend yield and the monthly total return into logarithmic form, and then make regression model using the logarithmic form. 
 



推薦內容
  • 英國作業
  • 新西蘭作業
  • 愛爾蘭作業
  • 美國作業
  • 加拿大作業
  • 代寫英國essay
  • 代寫澳洲essay
  • 代寫美國essay
  • 代寫加拿大essay
  • MBA Essay
  • Essay格式范文
  • 澳洲代寫assignment
  • 代寫英國assignment
  • 新西蘭代寫assignment
  • Assignment格式
  • 如何寫assignment
  • 代寫英國termpaper
  • 代寫澳洲termpaper
  • 英國coursework代寫
  • PEST分析法
  • literature review
  • Research Proposal
  • 參考文獻格式
  • case study
  • presentation
  • report格式
  • Summary范文
  • common application
  • Personal Statement
  • Motivation Letter
  • Application Letter
  • recommendation letter