Question: accroding to the question, I cannot pate the whole table from 1991 to 2021,so can you use the table from 1991 to 1993 to solve

 accroding to the question, I cannot pate the whole table from

accroding to the question, I cannot pate the whole table from 1991 to 2021,so can you use the table from 1991 to 1993 to solve the questions? I will use your answer to solve the whole question, thx please upload your formula when you use the excel.

Date Share price indices: China Taiwan: Weighted
Jan-1991 4023.72
Feb-1991 5033.3701
Mar-1991 5139.9399
Apr-1991 5921.29
May-1991 5610.7202
Jun-1991 5900.7002
Jul-1991 5178.0601
Aug-1991 4542.9302
Sep-1991 4867.1299
Oct-1991 4389.8599
Nov-1991 4391.6099
Dec-1991 4540.5498
Jan-1992 5391.6299
Feb-1992 5031.6899
Mar-1992 4800.9399
Apr-1992 4496.1899
May-1992 4519.27
Jun-1992 4523.8101
Jul-1992 4108.52
Aug-1992 3946.3501
Sep-1992 3524.21
Oct-1992 3631.73
Nov-1992 3675.01
Dec-1992 3377.0601
Jan-1993 3251.23
Feb-1993 4049.5
Mar-1993 4825.29
Apr-1993 4563.52
May-1993 4267.8999
Jun-1993 3995.51
Jul-1993 3994.2
Aug-1993 3892.04
Sep-1993 3832.6899
Oct-1993 4086.1699
Nov-1993 4353.8999
Dec-1993 6070.5601

please answee this question using this table, because the data are huge, so use the part of data to do. and I will follow your step to answer the whole question. thx

QUESTION 3 Although Taiwan market had experienced large extend of uncertainty, often such things can also provide opportunities for investors. As a first step, an investor considering the Taiwan share market, examines the long-term continuous returns for the Taiwan Weighted. Use Excel's Data Analysis/Descriptive Statistics to find the Taiwan Weighted monthly returns from start of 1991 until Jun 2021. (a) Calculate the 95% confidence interval for the monthly returns for the Taiwan Weighted over this period. (b) As the investor is concerned about the possibility of negative returns, test to see whether the average monthly returns for the Taiwan Weighted 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 Taiwan share market. Discuss type 1 and type 2 error and how they may relate to this hypothesis test. (c) Calculate and comment the skewness of the Taiwan Weighted monthly returns over the sample period. Explain why this is the case and the implications for investment decisions. (d) Using the continuous returns on the Taiwan Weighted, determine whether the rises and falls are independent using a runs test. What are the implications of your findings? (12 marks) QUESTION 3 Although Taiwan market had experienced large extend of uncertainty, often such things can also provide opportunities for investors. As a first step, an investor considering the Taiwan share market, examines the long-term continuous returns for the Taiwan Weighted. Use Excel's Data Analysis/Descriptive Statistics to find the Taiwan Weighted monthly returns from start of 1991 until Jun 2021. (a) Calculate the 95% confidence interval for the monthly returns for the Taiwan Weighted over this period. (b) As the investor is concerned about the possibility of negative returns, test to see whether the average monthly returns for the Taiwan Weighted 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 Taiwan share market. Discuss type 1 and type 2 error and how they may relate to this hypothesis test. (c) Calculate and comment the skewness of the Taiwan Weighted monthly returns over the sample period. Explain why this is the case and the implications for investment decisions. (d) Using the continuous returns on the Taiwan Weighted, determine whether the rises and falls are independent using a runs test. What are the implications of your findings? (12 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!