Analyze data relating to returns and standard deviations

Assignment Help Basic Computer Science
Reference no: EM131432640

This activity will help you gather and analyze data relating to returns and standard deviations. Use Yahoo! Finance or another site to get monthly pricing for the S&P 500 ETF (SPY), Coca-Cola, and Netflix for the past five years. Then, calculate the following using Excel and the provided instructions:

  • Monthly returns for each stock
  • Average monthly return for each stock
  • Annualized returns based on the monthly average return for each stock
  • Standard deviation of monthly returns for each stock
  • Annualized standard deviation based on standard deviation of monthly returns

Compare the differences in returns and standard deviations in the three sets of data, and discuss their investment implications using a cell within the spreadsheet document.To complete this assignment, review theModule Two Activity Guidelines and Rubricdocument.

Reference no: EM131432640

Questions Cloud

What tools will you use to measure success for a change : Explain to your stakeholders what tools will you use to measure success for a change within your organization? Propose to the stakeholders that if the change is successful you will celebrate accomplishments during an identified educational reform ..
How value-at-risk affect investing for a manufacturing firm : How does Value-at-Risk affect investing for a manufacturing firm? How might a manufacturing business be affected by credit scoring?
Demand for oil more elastic : 1) Why might restaurant charge very high prices for wine and bottled water and yet quite reasonable prices for food? 2) Give some examples of things that could make the demand for oil more elastic. What specific policies could the government take t..
Is there any evidence to suggest the given : Is there any evidence to suggest that the mean time to finish this triathlon was more than 2.5 hours? Assume the underlying distribution is normal and use a 5 0.01.
Analyze data relating to returns and standard deviations : This activity will help you gather and analyze data relating to returns and standard deviations. Use Yahoo! Finance or another site to get monthly pricing for the S&P 500 ETF (SPY), Coca-Cola, and Netflix for the past five years. Then, calculate t..
Discuss about the medium or technology for communication : The message of any medium or technology is the change of scale or pace or pattern that it introduces into human affairs. The railway did not introduce movement or transpotatio or wheel or road into human society, but it accelerated and enlarged th..
What you read and application at the company or organization : Were there differences between what you read and the application at the company or organization? How do you explain the differences? Were there subtle differences or significant differences?
Issue of binge drinking on university campuses : you will compare two articles on the issue of binge drinking on university campuses: "Stop Babysitting College Students" by Froma Harrop and "Binge Drinking must be Stopped" by Henry Wechsler.
Attracting the right talent for the ceo position : What role does the compensation package play in attracting the right talent for the CEO position?

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Biggest advantage of implementing threads

What is the biggest advantage of implementing threads in user space? What is the biggest disadvantage?

  Method of direct proof to prove that statement

Suppose a and b are integers. If a | b, then a | (3b3 - b2 +5b). Use the method of direct proof to prove that statement.

  Create an array of 1,000 integers sorted

Create an array of 1,000 integers sorted in reverse numerical order. Write a program that runs each sorting algorithm with this array, timing each algorithm, and compare the times.

  Examine graph which compares segment sequence numbers

Why does Segment Sequence Number remain unchanged (indicated by the horizontal line in graphs) with every drop in congestion window?

  Determines if the value is prime

Write a program that gets a starting value from the user and then prints the Syracuse sequence for that starting value.

  Learning about operating systems

How do you mount a .dmg file on a Mac OS X? What are the four components of the Unix file system. For what legal and illegal purposes can you use steganography?

  Implement floyd''s algorithm

The costs on all possible routes will be less than infinity. You should be able to enter graphs of arbitrary complexity into main().

  Poor network documentation

What are some of the best practices that are used to optimize networks and what might be some of the pitfalls that can arise from poor network documentation?

  Create a projected profits worksheet using the template

Create a projected profits worksheet using the template available in D2L under the content tab entitled Excel Assignment 1 Template. In cell B15, calculate Total Income. Format as currency with 2 decimal places.

  How do you use pattern matching with inequalities

how do you use pattern matching with inequalities supposed i wanted to say that if 3>4 then "abc" how would i do that with pattern matching in ocaml

  Basic business skills play a role in your professional life

How will basic business skills play a role in your professional life?

  Role of network servers and clients

Suppose you had a client who never used a network. Explain, in everyday terms, the role of network servers and clients.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd