Create a x-y scatter plot of your data

Assignment Help Finance Basics

Reference no: EM13279233

Create a Microsoft Excel workbook, and download and store the end-of-month prices for your stock for at least the last 30 months, as well as any dividend information. Name this worksheet DATA. 1. Calculate returns. Using your price and dividend information, calculate the monthly returns on the stock on the worksheet DATA. HRE ARE THE PRICES: -Jan-13 11.32 28-Feb-13 11.23 31-Jan-12 7.13 28-Feb-12 7.97 31-Mar-12 9.57 2. Calculate the returns on the market. Select a market index and download the monthly returns for the same period of time that you used for the selected stock. If returns are not available, download the level of the index and any corresponding dividends, and calculate the market's monthly returns using that information. The market returns should also be placed on the worksheet DATA. 3. Plot your data. Create a X-Y scatter plot of your data, with the return on the stock as the vertical axis and the return on the market as the horizontal axis. Name this chart as SCATTER in your workbook and be sure to label the axes.

Reference no: EM13279233

Questions Cloud

Determine what is the sampled signal x equal to : (a) Find the Fourier transform X(Ω) of x(t). (b) Is x(t) band limited. If so, find its maximum frequency Ωmax. (c) Suppose that Ts = 2π. How does Ωs relate to the Nyquist frequency 2Ωmax. Explain.

Which of the following is not a benefit of the spline method : Which of the following is not a benefit of the spline method of estimating discount functions across a spectrum of maturities?

Can we measure progress in ethical maturity of our society : Have we, as a society, become more or less ethical than we were 10 – 20 or even 50 yrs ago? Is it the media awareness that has made us appear less ethical when we really are not? Can we measure progress in ethical maturity of our society?

Explain what is its solubility at 25 °c and 1470 torr : At 25 °C and 765 Torr, carbon dioxide has a solubility of 0.0342 M in water. What is its solubility at 25 °C and 1470 Torr

Create a x-y scatter plot of your data : Create a X-Y scatter plot of your data, with the return on the stock as the vertical axis and the return on the market as the horizontal axis. Name this chart as SCATTER in your workbook and be sure to label the axes.

What type of skills do guerrilla marketers need : Briefly explain the various defense strategies that the dominate firm in a particular market can use. What type of skills do guerrilla marketers need? Describe the four types of competition that can exist within an industry.

Explain what is the maximum work that can be obtained : What is the maximum work that can be obtained from a 340 L tank of compressed air at 4350 PSI

Prepare a monthly cash receipts schedule for the firm : Prepare a monthly cash receipts schedule for the firm for March through August.

Explain benzene and toluene has a total vapor pressure : A solution of 75.0 g of benzene (C6H6) and 75.0 g of toluene (C7H8) has a total vapor pressure of 80.9 mmHg at 303 K. Another solution of 100.0 g benzene and 50.0 g toluene has a total vapor pressure of 93.9 mmHg at this temperature.

User Account

All Pages