Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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/05

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

The Cyber Attack Survival Manual

Authors: Heather Vescent ,Nick Selby

1st Edition

1681886545, 978-1681886541

More Books

Students also viewed these Finance questions

Question

How was FASTSIGNS's growth financed?

Answered: 1 week ago