6. In this exercise, we are going to examine the average return and volatility of the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
6. In this exercise, we are going to examine the average return and volatility of the NASDAQ Composite index. Go to the webpage https://finance.yahoo.com. Download historical prices for NASDAQ Composite index (search with ticker ^IXIC) at a monthly frequency. Use for the date range (Time Period') 1/1/1990 until 12/31/2021. Click apply and then download the data using the 'Download' link as shown in the picture below. Summary Chart Conversations Historical Data Options Components Time Period Dec 31, 1989-Dec 30, 2021 Show. Historical Prices Frequency: Monthly Apply Downinad a) Use the column labeled 'Adj Close' to compute holding period returns of the index. Compute the mean, standard deviation, skewness, kurtosis, maximum, and minimum. What do you observe? b) What is the minimum return of the index over the sample period? What is it associated with? c) Using the average monthly return and volatility that you computed above, what is the probability that you observe such a return according to a normal distribution (that is, assuming that monthly returns are normally distributed with mean and volatility as computed above)? What do you conclude? Hint: use the function NORM.DIST. 6. In this exercise, we are going to examine the average return and volatility of the NASDAQ Composite index. Go to the webpage https://finance.yahoo.com. Download historical prices for NASDAQ Composite index (search with ticker ^IXIC) at a monthly frequency. Use for the date range (Time Period') 1/1/1990 until 12/31/2021. Click apply and then download the data using the 'Download' link as shown in the picture below. Summary Chart Conversations Historical Data Options Components Time Period Dec 31, 1989-Dec 30, 2021 Show. Historical Prices Frequency: Monthly Apply Downinad a) Use the column labeled 'Adj Close' to compute holding period returns of the index. Compute the mean, standard deviation, skewness, kurtosis, maximum, and minimum. What do you observe? b) What is the minimum return of the index over the sample period? What is it associated with? c) Using the average monthly return and volatility that you computed above, what is the probability that you observe such a return according to a normal distribution (that is, assuming that monthly returns are normally distributed with mean and volatility as computed above)? What do you conclude? Hint: use the function NORM.DIST.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Python and most Python libraries are free to download or use, though many users use Python through a paid service. Paid services help IT organizations manage the risks associated with the use of...
-
a. Example 13-1: Batch Reactor with an Exothermic Reaction Wolfram 1. Adiabatic Case: Use Wolfram to see whether you can find a trajectory that is ready to ignite and whose trajectory looks like a...
-
Accurate Job Costing must be done on three levels. Which of the following is not one of these levels? Tracking and controlling costs during jobs Tracking gross profit each month Filing records on...
-
Compute the 2016 standard deduction for the following taxpayers. a. Margie is 15 and claimed as a dependent by her parents. She has $800 in dividend income and $1,400 in wages from a part-time job....
-
Mindspin Labs Inc. is a manufacturing firm that has experienced strong competition in its traditional business. Management is considering joining the trend to the service economy by eliminating its...
-
Defendant Monty J. Person began working for Garage Solutions, LLC, in March 2015. Three months into his employment, Person was sent by the owner of Garage Solutions, Mark Fontenot, to Rexburg, Idaho,...
-
Elizabeth Johnson, CPA, has completed the audit of notes payable and other liabilities for Valley River Electrical Services and now plans to audit contingent liabilities and commitments. Required a....
-
. Conduct research and review the pricing models for Amazon Web Services and Microsoft's Azure. . How are they similar and how are they different?
-
1. Consider a household with preferences given by (1) where p > 0 is the rate of time preference. The household has no initial wealth; i.e. a_1(1+r) = 0. Suppose further that the interest rate stays...
-
Discuss international performance management and compare it to domestic performance management. Use specific examples to illustrate similarities and differences. Name and discussthe three general...
-
Hi Shivkumar Raj, I received your resume for the Business Development executive role at XZY your background and experience are very intriguing! If you are still interested, I'd like to invite you to...
-
Compare and contrast cost-effectiveness analysis and cost-benefit analysis. How are they similar? How are they different? Do you think one is better than the other? Explain. Is there a moral...
-
What is the National Crime Victimization Survey (NCVS) and how does it differ from the Uniform Crime Reports (UCR) in types of data collected regarding violent crimes and general findings?
-
Legal Requirement for Risk Management What are the WHS legislative requirements of PCBUs/employers, with regards to risk management? Min 1 paragraph answer required.
-
Data quality can be assessed in terms of several issues, including accuracy, completeness, and consistency. For each of the above three issues, discuss how the assessment of data quality can depend...
-
Find the radius of convergence in two ways: (a) Directly by the CauchyHadamard formula in Sec. 15.2. (b) From a series of simpler terms by using Theorem 3 or Theorem 4.
-
Case 1 Adiabatic (i) Vary inlet flow rate of inert and observe the conversion and temperature profiles. Describe what you find. (ii) Find inlet temperature, T 0 , for which the reaction rate at V =...
-
Example 11-3: Adiabatic Liquid-Phase Isomerization of Normal Butane. Can you explain why the CSTR volume is smaller than the PFR volume? Example 11-3 Normal butane, C 4 H 10 , is to be isomerized to...
-
The following E-curve shown in Figure P18-18b was obtained from a tracer test: E-curve for a nonideal reactor. a. What is the mean residence time? b. What is the Pclet number for a closed-closed...
-
The plant managers of ABC Corporations five plants have met at a common location at 8:00 am every Monday morning for 20 years. The people serving as plant managers have changed several times during...
-
New Piper, an aircraft manufacturer, issued a Mandatory Service Bulletin grounding 76 new aircraft manufactured during the first 5 months of 2004. Thirty-nine of the airplanes were in customers...
-
Consider the logistic map discussed in the text. To gauge the density of bifurcations, one uses a measure of distance between fixed points as follows. Define \(d=x^{*}-(1 / 2)\) as the distance...
Study smarter with the SolutionInn App