Calculate the following term structures statistics

Reference no: EM131086926

Term Structure of Statistics

1. Calculate the following term structures statistics (Days 1 to 252) for the SX5E index. Provide graphs similar to the ones in this chapter.

Hint To make life easier, use the OFFSET function in Excel, illustrated in Figure 3-47. (This function returns an array, not a number in a single cell.)

2. Create a scatter plot of rolling 21-day returns versus (annualized) 21-day volatilities (see formulas that follow). That is, one compares a specific 21-day return to the volatility of that same 21-day period in question. Provide graphs similar to the ones in this chapter.

3. Calculate the autocorrelation of squared returns up to 300 lag days. Provide graphs similar to the ones in this chapter.

Use the CORREL() function in Excel along with the OFFSET() function.

Reference no: EM131086926

Questions Cloud

Find out the all taxes of shown query : Assume that COGS is always 70% of Sales, Interest Expense is always 10% of the previous years long term debt, Depreciation is always 20% of the previous years Net Fixed Assets, and taxes are always 40% of EBT.

Write a motion-control program for a three-axis system : write a motion-control program for a three-axis system to do the following:

What is the concentration of air : Assume you have an infinitely expandable balloon, such that the elasticity of the balloon material does not exert any additional pressure on the contents of the balloon.

Square of the radiusrand the heighth : The volumeVof a right circular cone varies jointly as the square of the radiusrand the heighth. Determine what happens toVwhenris six times as large.

Calculate the following term structures statistics : 1. Calculate the following term structures statistics (Days 1 to 252) for the SX5E index. Provide graphs similar to the ones in this chapter.

Calculate the accumulated interest : A principle of $5000 is invested at 7.5% compounded monthly for 7 years. a.) Calculate the accumulated interest at end of each year.

How cognitive strategies either assist and hinder problem : Explain how cognitive strategies (like algorithm and/or confirmation bias) can either assist and hinder problem solving. Include in your answer the definition of the strategy on which you choose to focus. Then apply the information by summarizin..

Find the length of the dead band : Find the length of the dead band.

What is the preferable presentation of accounts receivable : Which of the following is NOT considered cash for financial reporting purposes? What is the preferable presentation of accounts receivable from officers, employees, or affiliated companies on a balance sheet?

User Account

All Pages