Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You will find a template for daily adjusted closing price for AMD corporations stock from 12/31/2004 to 12/31/2014. a. Compute the daily stock returns and
You will find a template for daily adjusted closing price for AMD corporations stock from 12/31/2004 to 12/31/2014. a. Compute the daily stock returns and graph them (as we did in class). b. Use the Excel function Frequency to build a frequency distribution of the stock returns between - 9% and 9% (1% incremental) and graph this distribution (as we did in class). Please write down the formula.
AMD-DAILY STOCK PRICES, 31DEC2004- 31Dec201 Closing stock Daily Date price return 31/Dec/04 22.02 Jan/05 21.41 4/Jan/05 20.21 5/Jan/05 19.75 6lJan/05 19.72 Jan/05 19.92 10/Jan/05 20.13 11/Jan/05 14.86 12/Jan/05 15.02 13/Jan/05 15.16 14/Jan/0515.16 15.5 15.5 20Ja/05 15.64 21/Jan/05 15.49 24/Jan/05 15.16 25/Jan/05 5.75 26/Jan/05 15.98 27/ Jan/05 16.12 28/Jan/05 15.71 15.8 /Feb/05 16.27 2/Feb/05 16.66 16.67 18/Jan/05 19/Jan/05 31/Jan/05 3/Feb/05 AMD-DAILY STOCK PRICES, 31DEC2004- 31Dec201 Closing stock Daily Date price return 31/Dec/04 22.02 Jan/05 21.41 4/Jan/05 20.21 5/Jan/05 19.75 6lJan/05 19.72 Jan/05 19.92 10/Jan/05 20.13 11/Jan/05 14.86 12/Jan/05 15.02 13/Jan/05 15.16 14/Jan/0515.16 15.5 15.5 20Ja/05 15.64 21/Jan/05 15.49 24/Jan/05 15.16 25/Jan/05 5.75 26/Jan/05 15.98 27/ Jan/05 16.12 28/Jan/05 15.71 15.8 /Feb/05 16.27 2/Feb/05 16.66 16.67 18/Jan/05 19/Jan/05 31/Jan/05 3/Feb/05Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started