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

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

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