Hi Class,This should be sort of fun, see how much money you can make … or lose! Start by downloading the attached template.The video “Tech Hints QR 2-7” in the media resources section of the eBook covers the calculations you’ll be doing for this DQ. (Our template does look a little different, but it is essentially the same.)Here is a video I made to help: https://youtu.be/iSMKu1B1fVc Here are specific instructions for completing the DQ:In the initial investment section (A1:F4), select three different stocks to track. Select your stocks from the New York Stock Exchange listings directory at https://www.nyse.com/listings_directory/stock. Use the “Filter” text box to search for specific stocks; click on the stock Symbol in the list at the right to go to the stock quote page for the stock to see more details, including historical prices. Towards the bottom, you can find a chart that will let you input date ranges. You can input the same date for start and end to look up your specific day.Use a purchase date of 1 year ago, for each stock. So if it is Feb 18, 2020, then you look at the price Feb 18, 2019. Find each stock’s price on that date and enter it into the Price per Share field. The table does not contain data points for weekends. If your date is on a non-business day choose a date close to your date listed. Assume that the number of shares purchased is 100 for your first stock, 200 for your second stock, and 300 for your third stock and that the fees are $5, $10, and $15 (total fee) for your first, second, and third stocks. Enter an appropriate formula in the Initial Investment field, and calculate an initial investment total in cell F5.In cells A14:F16, continue your analysis for your first stock. Use the closing price 9 months ago, 6 months ago, 3 months ago, and the latest for the second through fifth date sections. Just get close to these dates, basically, we are looking at quarterly fluctuations. Look up the closing price per share on each of these dates and enter those in column D. Calculate a current value on each date in column E. Calculate the gain or loss to date (starting from the initial purchase date) in column F.Repeat the analysis from step 3 for your second and third stocks, using cells H14:M16 for the second stock and O14:T16 for your third stock.In column V, calculate (in cells V14:V16) the total gain or loss for all three stocks on each of the three dates.Hint: To get the stock value on a particular date from the stock quote page, scroll down to the stock chart or stock table below it.Hi Class,I made a video to help with the website. Check it out if you are having trouble navigating the website.https://youtu.be/Yt3aDSypgC0

CompetencyThis competency will allow you to demonstrate your ability and skill in applying game theory to real world scenarios.InstructionsAfter working for 18 months in your analyst position at G & B Consulting, you are now being considered for a project manager position that would put you in charge of several team members. As part of the interview process, you have been asked to make a presentation to highlight what you think are the most compelling reasons you should get the position.Part 1: The first item you want to highlight is your customer satisfaction record. Over the past 18 months of employment you have worked with 24 clients, and according to the customer satisfaction surveys all clients are asked to take after their contract is completed, 22 of them rated you with the highest level of satisfaction.However, your prior personal customer satisfaction record is not enough. It is very important to G & B Consulting that they maintain high ethical standards and continue to receive the highest rating from the Better Business Bureau. In order to maintain this rating, the company must maintain a consistent customer satisfaction rating of 85% or higher. Internal projections predict that G & B Consulting will serve 60 clients over the next year. If you become the project manager and use your prior record as an indicator, find the probability that there will be an 85% or higher customer satisfaction rating. Use this information to make a convincing argument that you are a good choice for the position.Part 2: The other item you wish to highlight comes from work done for a local manufacturer. They believe that a competitor is illegally using one of their patents in their own manufacturing process and are considering litigation. This competitor's product is directly cutting into the manufacturer's profit, so if they were able to prevent the competitor's product from being made they would be able to recoup those lost profits. On the other hand, the litigation process will likely prove to be long and costly, and the outcome is not guaranteed and would likely result in a countersuit brought by the competitor. Before continuing with costly legal counsel, the manufacturer hired G & B Consulting to help them determine their best strategy.This was potentially a very lucrative contract, and a high profile one too since the manufacturer is one of the biggest employers in the area. Therefore, several analysts at G & B Consulting, including you, were asked to tackle the problem independently to help ensure the best possible results. Before compiling a final report to give to the manufacturer, the results were presented to the project lead:The first solution brought up was given by one of your coworkers. Using the manufacturer's projections of profits solely, he was able to create the following payoff matrix where each entry is in millions of dollars annually: Competitor SueDon’t SueManufacturerSue(5, -5)(20, -20)Don’t Sue(-10, 10)(-15, 15)This coworker concludes that the dominant strategy for the manufacturer is to sue,and if the competitor assumed best play by the manufacturer, they would also sue.Based only on the payoff matrix, do you agree with the conclusion made by your coworker? Do you agree that this scenario should be represented as a zero-sum game? Why or why not?The second solution was brought by a different coworker. She also created a payoff matrix for the scenario but did some independent research to estimate the competitor's profits in each outcome and came up with the following payoff matrix, again, the values represent millions of dollars in annual profits. Competitor SueDon’t SueManufacturerSue(5,-5)(20, 10)Don’t Sue(10, 20)(15, 15)This coworker concludes that under these circumstances, the manufacturer should sue 50% of the time and not sue the other 50% of the time, and they should expect their competitor to do the same.Based solely on this payoff matrix your coworker provided, do you agree with her conclusion? Do you agree that the solution is realistic based on the scenario? Do you agree that all of the cells in the payoff matrix represent realistic possibilities?You present your own solution that is based on a non-simultaneous game where the manufacturer first has to decide whether or not they wish to pursue litigation. If they do so choose, then their competitor will also have to decide if the wish to file a counter-suit. You utilized the same payoff matrix that the second coworker provided that contains information about both companies' projected profits, but then you created a game tree that excludes any nonsensical scenarios. With this game tree, determine the optimum strategy.Compile the information from Part 1 and Part 2 into a PowerPoint presentation, and include recorded narration(include the information to be narrated in the powerpoint notes and I will record the narrated portion) within the PowerPoint. Be sure to include all relevant work, your response to all of the questions above, and your conclusions.

Please follow the uploaded document with all questions and instruction to follow with the corresponding data to answer the questions to the "Statistical investigation.The second part with "Everyday statistics" use the link in the word document to answer the questions for that sectionThe image is the data to be used for the 1st section of the assignment