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

  Prove that in any group of six actors

Using graph theory: say that two actors are co-stars if they have been in the same movie. Prove that in any group of six actors, we can either find a group of three such that all pairs in the group are co-stars, or a group of three so that no two..

  Create the data model segment for business rules

The FlyRight Aircraft Maintenance (FRAM) division of FlyRight Company (FRC) does all maintenance for FRC's aircraft. Create the data model segment which reflects the following business rules.

  How was it managed to support an innovative atmosphere

Describe a team project with which you are familiar where the objective was to find an innovative solution. What was the level of stress and how was it managed to support an innovative atmosphere?

  Non-isomorphic graphs with the degree sequence

1.Show that if two graphs have the same degree sequence then they have the same number of vertices and the same number of edges. Find two non-isomorphic graphs with the degree sequence (2, 2, 2, 1, 1)

  Set of ordered pairs

Write, as a set of ordered pairs, a function f that is a bijection from V1 to V2, satisfying the following condition: if x and y are elements in V1 such that {x,y} is in E1, then f(x) and f(y) are elements in V2 such that {f(x),f(y)} is in E2, and..

  What is the return type of this method

Is there a method in the String class that tests whether a string ends with a given suffix? If so, what is it called and what are its parameters and return type?

  What is the sample space of the experiment

What is the sample space of the experiment?

  Bellman-ford algorithm for finding shortest paths

Suppose that a directed graph G has the property that every shortest path from the starting vertex s to every other vertex has at most four edges. What would this fact imply about the running time of the Bellman-Ford algorithm for finding shortest..

  Delivering business value with it at hefty hardware

Read the mini-case, Delivering Business Value with IT at Hefty Hardware, at the end of Section 1 of your textbook, then complete a well-written paper responding to the two discussion questions at the end of the mini-case. Support your responses wi..

  How can they support the development of a security framework

What documents are available from the NIST Computer Resource Center, and how can they support the development of a security framework?

  Determine whether a string is in the language l

Write a pseudocode function that uses a stack to determine whether a string is in the language L, where a. L= {w : w contains equal numbers of A's and B"s} b. L = {w : is of the form A(n) B(n) for some n >/= 0}

  Integrated with the display and keyboard

What would a system unit that is integrated with the display and keyboard would be considered? Which of the following type of system unit is not considered to belong to the family of PCs?

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