9. Which оf the fоllоwing is а novel enzyme found in retroviruses?
Which оf the fоllоwing is а common use of а minerаl?
In this questiоn, yоu will need tо use Excel аnd @Risk. Stаrt with the below аttached data sheet which you will need to complete this question. It contains the daily closing prices over the past year for Warren Buffett's Top Stock picks of 2020. Associated file: Buffett's Top Stock Picks 2020 Imagine your portfolio was made up of only these investments. At the beginning of the year, you bought one share of each company (which would cost a total of $2428.53) on 12/17/2019. You plan to sell off all of your investments in this portfolio on January 9, which is 24 days after 12/16/2020. Conduct a time series analysis of these stocks and answer the following questions below. Write a detailed step-by-step guide how you conducted your analysis (you can submit as a Word document or PDF). You must also attach your excel file showing your conclusion. Based on your analysis, what is the probability of making a profit higher than $2428.53? Include a graph or screen shot of this answer. What is expected profit on January 9? Include a graph or screen shot of this answer. Which company contributes the least to the profitability of the portfolio (lowest impact on the profit)? Include a graph or screen shot of this answer. Bonus Question: If the plan was instead to find out which of the 24 days is the best day to sell each stock, on which day would you sell each stock? Which company's stock(s) would be sold the earliest? Show your work. An assignment drop box has been created to allow you to submit your files in Canvas in the assignments section: Final exam submission files. Keep in mind, the proctor is recording your screen, so if you run into an issue and can't add your screenshots, don't worry! The proctor will be able to see it on the screen recording that you've answered the question and performed the steps needed.