This essay has been submitted by a student. This is not an example of the work written by professional essay writers.
Uncategorized

My Excels HW requirement:

Pssst… we can write an original essay just for you.

Any subject. Any type of essay. We’ll even meet a 3-hour deadline.

GET YOUR PRICE

writers online

My Excels HW requirement:

 

  1. What is first letter of your first name?

(Y)

  1. What is the first letter of your last name?

(X)

  1. Choose two companies listedon the S&P500 that begin with the same letter from 1. and 2.(If you cannot find one use the second letter.)
  2. Find the year starting price and ending price for years 2013, 2014, 2015, and 2016 for both companies
  3. Calculate the return for each year as a percent.
  4. Calculate the geometric mean of the returns for 2013-2016 for both companies
  5. Calculate the variance and standard deviationfor 2013-2016 for both companies.
  6. Calculate the coefficient of variation for 2013-2016 for both companies.
  7. Suppose stocks 1 and 2 are uncorrelated. If a portfolio is created that contains 25% of stock 1 and 75% of stock 2, what is the geometric mean of the portfolio? What is the variance and standard deviation of the portfolio?
  8. Download the 4 years of daily stock prices from yahoo finance for the two companies from question 3. Use the adjusted closing price.
  9. Test the following: What is the probability the return for any given day will be positive? (For each year 2013, 2014, 2015, 2016-you will need four hypothesis tests)
  10. Test the following: What is the probability the return for any

given day between the two stocks will be different? (For each year 2013, 2014, 2015, 2016-you will need four hypothesis tests)

 

  Remember! This is just a sample.

Save time and get your custom paper from our expert writers

 Get started in just 3 minutes
 Sit back relax and leave the writing to us
 Sources and citations are provided
 100% Plagiarism free
error: Content is protected !!
×
Hi, my name is Jenn 👋

In case you can’t find a sample example, our professional writers are ready to help you with writing your own paper. All you need to do is fill out a short form and submit an order

Check Out the Form
Need Help?
Dont be shy to ask