Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

c) Using the statistics found in (a) and (b), draw a scatter plot, where X variables are the standard deviation, and Y variables are the

image text in transcribed

c) Using the statistics found in (a) and (b), draw a scatter plot, where X variables are the standard deviation, and Y variables are the average return.

(d) Do you see a clear relationship between average return and standard deviation? How would you interpret this result?

4. DeItal CaLse In this quostion, we examine whether storks' average return is related to their wolatility. In particular, we use historical prices of the following storks (Inside the parenthesis are stock symbols). Gencral Milks, Ins. (GIS) JP3 Morgan Chane &. Co. (J'M) Intel Corporation (INTCO) You may obtain historical prices from Yahoo Finance ias folkws: - 'Type in earh storks symbol and click "Historical Datan". - loor the time period, enter the "start date" as danuary 1, 2016 and the "end date" as Devember 31 , 20121. - Cherese the monthly frequency. - After hitting Apply clivs "Download Data". - Open the downosulod data in Exced. Delete all the columns excrept the date and the adjustusi clowe (Among different price quxites, we use "iadjustesi ciloese prise" to exumpute returns). in month t and Pt1 in month t1, the rate of return is ItPt1Pt31. (a) Cilculate the awerige returns on these three stocks and report in the following table. (b) Calculate the standard deviation of these thres stodes and report in the following table 4. DeItal CaLse In this quostion, we examine whether storks' average return is related to their wolatility. In particular, we use historical prices of the following storks (Inside the parenthesis are stock symbols). Gencral Milks, Ins. (GIS) JP3 Morgan Chane &. Co. (J'M) Intel Corporation (INTCO) You may obtain historical prices from Yahoo Finance ias folkws: - 'Type in earh storks symbol and click "Historical Datan". - loor the time period, enter the "start date" as danuary 1, 2016 and the "end date" as Devember 31 , 20121. - Cherese the monthly frequency. - After hitting Apply clivs "Download Data". - Open the downosulod data in Exced. Delete all the columns excrept the date and the adjustusi clowe (Among different price quxites, we use "iadjustesi ciloese prise" to exumpute returns). in month t and Pt1 in month t1, the rate of return is ItPt1Pt31. (a) Cilculate the awerige returns on these three stocks and report in the following table. (b) Calculate the standard deviation of these thres stodes and report in the following table

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foundations Of Finance

Authors: Arthur J. Keown, John H. Martin, J. William Petty

9th Edition

978-0134083285, 134083288, 978-0134084015

More Books

Students also viewed these Finance questions