Calculate the standard deviation of daily returns

Assignment Help Finance Basics

Reference no: EM133251827

Question - Pull down the daily ending prices for S&P 500 from Yahoo Finance for the past month.

Plot the adjusted close price on a scatter plot and save it down as a new worksheet.

Determine the daily return (rate of change) in the adjusted close price of the dataset.

Use the data analysis tool pack and make a histogram of the returns.

Calculate the standard deviation of daily returns.

Determine the day of the week for each daily return.

Make a pivot chart, to identify the average return for each day of the week.

Reference no: EM133251827

Questions Cloud

What is the discounted payback period : Brayani Kids Ltd. an airline caterer, is purchasing refrigerated trucks at a total cost of $3.25 million. What is the discounted payback period

What ethical dilemmas are presented in film arbitrage : What ethical issues are presented in the film Arbitrage? What ethical dilemmas are presented in the film Arbitrage?

What is the amount of the last dividend paid : Dividends are paid annually and increase at a constant rate equal to 5 percent per year. What's the amount of the last dividend paid

Explain why evacuation planning is important : Explain why evacuation planning is important,

Calculate the standard deviation of daily returns : Plot the adjusted close price on a scatter plot and save it down as a new worksheet. Calculate the standard deviation of daily returns

Mission success within infantry battalion : Creative thinking, problem solving, decision making and assessments to develop unit members for mission success within an Infantry Battalion?

Determine the amount of her salary that is subject : Monica Dutton earns $175,000 as a guest speaker for various organizations. Determine the amount of her salary that is subject to the Social Security tax

What will the value of the bond l be : What will the value of the Bond L be if the going interest rate is 5%, 7%, and 12%? Assume that only one more interest payment is to be made on Bond S

What is the sustainable growth rate : At the beginning of the year, the company had a book value of debt of $37,000 and a book value of equity of $54,000. What is the sustainable growth rate

User Account

All Pages