{"id":430152,"date":"2018-06-14T20:40:21","date_gmt":"2018-06-14T20:40:21","guid":{"rendered":"https:\/\/essaypaper.org\/?p=25118"},"modified":"2018-10-24T09:02:10","modified_gmt":"2018-10-24T09:02:10","slug":"quantitative-analysis-finance-calculate-question","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/quantitative-analysis-finance-calculate-question\/","title":{"rendered":"quantitative analysis\/finance\/calculate question"},"content":{"rendered":"

My Excels HW requirement:<\/p>\n

 <\/p>\n

    \n
  1. What is the first letter of your first name?<\/li>\n<\/ol>\n

    (Y)<\/p>\n

      \n
    1. What is the first letter of your last name?<\/li>\n<\/ol>\n

      (X)<\/p>\n

        \n
      1. Choose two companies listed on the S&P500 that begin with the same letter from 1. and 2.(If you cannot find one use the second letter.)<\/li>\n
      2. Find the year starting price and ending price for years 2013, 2014, 2015, and 2016 for both companies<\/li>\n
      3. Calculate the return for each year as a percent.<\/li>\n
      4. Calculate the geometric mean of the returns for 2013-2016 for both companies<\/li>\n
      5. Calculate the variance and standard deviation for 2013-2016 for both companies.<\/li>\n
      6. Calculate the coefficient of variation for 2013-2016 for both companies.<\/li>\n
      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?<\/li>\n
      8. Download the 4 years of daily stock prices from yahoo finance for the two companies from question 3. Use the adjusted closing price.<\/li>\n
      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)<\/li>\n
      10. Test the following: What is the probability the return for any<\/li>\n<\/ol>\n

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

         <\/p>\n","protected":false},"excerpt":{"rendered":"

        My Excels HW requirement:   What is the first letter of your first name? (Y) What is the first letter of your last name? (X) Choose two companies listed on the S&P500 that begin with the same letter from 1. Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-430152","post","type-post","status-publish","format-standard","hentry","category-essay-paper-writing"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/430152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=430152"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/430152\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=430152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=430152"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=430152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}