Work with the data file "hwk02_data.xls" for this homework.And this excel is uploaded in my google drive for you to download:

https://drive.google.com/file/d/1M6wLOS6fzFXDZC02LU0lbX-MoL-c3PON/view?usp=sharing

All of the data needed is posted in google drive. Pls don't ask questions liek "incomplete question" or "missing data", thank you very much.

1. Assume the Hang Seng Index returns follow an i.i.d. normal distribution. Given the index data in Excel file"homework2_data.xls", construct 95% and 99% confidence intervals for the population mean of the Hang Seng Index returns.

Explain what distribution you should use to construct the confidence interval (Student-t or normal distribution)? Explain how tointerpret the confidence intervals.

2. Following the assumptions in Q1, construct a hypothesis testing to evaluate whether the variance of HSI returns is less than 1%per month. Choose 10% level of significance.

Part II: Work with the data file "hwk02_data.xIs" for this homework. 1. Assume the Hang Seng Index returns follow an i.i.d. normal distribution. Given the index data in Excel file "homework?_data.xis", construct 95% and 99% confidence intervals for the population mean of the Hang Seng Index returns. Explain what distribution you should use to construct the confidence interval (Student-t or normal distribution)? Explain how to interpret the confidence intervals. 2. Following the assumptions in Q1, construct a hypothesis testing to evaluate whether the variance of HSI returns is less than 1% per month. Choose 10% level of significance