The Monthly Returns for the Hang Seng - Report Writing Economics Assignment Help

Assignment Task:

INSTRUCTIONS

Please up-load one (and one only) either word or pdf file with both your name and student number clearly printed on the first page. Use a file name that gives your identity. For the excel sections it is ok to take screen shots to show some of your workings then cut and paste into your document. For the maths sections, if you prefer, you can hand write then scan and add to your document. 

The data to be used for all, except Question 5, is in the Excel file ECON 1095 Data Sem 2 2020 where you will find monthly international share price indices from 1990 to 2020. Please go to the Reserve Bank of Australia’s website (the source of this data) and update for July and August 2020.

QUESTION 1

Although recent events in Hong Kong have created uncertainty, often such things can also provide opportunities for investors. As a first step, an investor considering the Hong Kong share market, examines the long term continuous returns for the Hang Seng. Use Excel’s Data Analysis/Descriptive Statistics to find the Hang Seng monthly returns from start of 1991 until August or September 2020.

1. Calculate the 95% confidence interval for the monthly returns for the Hang Seng over this period.

2. As the investor is concerned about the possibility of negative returns, test to see whether the average monthly returns for the Hang Seng are less than or equal to zero. Making reference to this hypothesis test, briefly discuss whether the investor should be worried about the possibility of negative returns if they invest in the Hong Kong share market. Discuss type 1 and type 2 error and how they may relate to this hypothesis test.

3. Test to see whether the monthly returns on the Hang Seng over this period are normally distributed using the Jarque-Bera test. This should be done in Excel, by calculating the Jarque-Bera statistic using the formulas from the notes and Data Analysis/Descriptive Statistics. Using the results of this test, comment on the accuracy of the probabilities calculated in parts (a) and (b) of this question.

4. The Hang Seng monthly returns over the sample period are negatively skewed. Explain why this is the case and the implications for investment decisions.

5. Using the continuous returns on the Hang Seng, determine whether the rises and falls are independent using a runs test. What are the implications of your findings?

QUESTION 2

Next the investor would like to look at the long-term relationship between the Hang Seng and the United State S&P 500 (US). Using the same time-period as in QUESTION 1:

1. Examine the connection between the Hang Seng and US using a series of graphs. Please do a few graphs, both as levels and returns and as XY and line (time series) graphs. Does it look as though the Hang Seng and US are dependent or independent? Feel free to re-use graphs you produced in Assignment

2. Calculate correlation coefficients between the Hang Seng and US (data analysis, correlation). Again, do this both for the levels and returns. Please interpret the coefficients and offer a brief explanation for their values.

QUESTION 3

Use regression to look at the relationship between returns on the Hang Seng and US over the same period used in the previous questions. That is, estimate Hang Sengt = β0 + β1USt. This is to be done using the three approaches in the regression example on Canvas (sample regression example.xlsx).  All three approaches should yield the same answer. That is:

1. Use the solver to find the values of β0 and β1 that minimize ei2.

2. Ensure that the values of β0 and β1 satisfy the normal equations.

3. Use Excel’s regression function to confirm the results in parts (a) and (b).

4. Next, evaluate these results by:

• Interpreting the coefficient of determination and the F-statistic.

• Conduct a t-test on the slope coefficient.

• Examine and graph the residuals, then comment.

• Briefly explain the implications of these findings.

QUESTION 4

It is possible that returns on other share markets could also be important drivers of the Hang Seng – to investigate:

1. Use excel and the monthly continuous returns data on all the international share price indices for the same period to obtain the correlation coefficient matrix (10 x 10). Briefly comment on any interesting results.

2. Use Excel’s regression function to estimate the multiple regression with the returns on the Hang Seng as the dependent variable and the returns on the other nine international share price indices as independent variables.

3. Evaluate these results by:

• Interpreting the coefficient of determination and the F-statistic.

• Use the t-statistics and the slope coefficients to explain which share price indices are significantly related to the Hang Seng.

• Briefly explain the implications of these findings

This Economics Assignment has been solved by our Economics Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.