Question F14 – Use Excel File F14 for your answer. Suppose D…

Question F14 – Use Excel File F14 for your answer. Suppose Dr. N invests 25% of his hard-earned cash in four stocks, Apple, Microsoft, Tesla, and Costco. The following table shows the mean and standard deviation of each stock’s annual return.   Distributions of Returns   Mean Standard Deviation Apple 16% 21% Microsoft 12% 13% Tesla 25% 38% Costco 18% 20%   The correlations between the annual returns on the four stocks are as follows.   Correlation Matrix   Apple Microsoft Tesla Costco Apple 1 0.75 – 0.7 0.2 Microsoft 0.75 1 -0.2 0.5 Tesla -0.7 -0.2 1 0.65 Costco 0.2 0.5 0.65 1   ​You can assume that he has invested equal amounts in each of these stocks. Also it is safe to assume lognormal distribution for each of the stock returns. Use the above simulation model to estimate the probability that Dr. N’s portfolio’s annual return will exceed 22%. Please complete and upload this partial template:  F_2023_Excel F14.xlsx 

Question F7 – Use Excel File F7 for your answer. Johns Hopki…

Question F7 – Use Excel File F7 for your answer. Johns Hopkins University has three parking lots on its Homewood campus, LOT A, LOT B, and LOT C. The following table shows the capacity of each lot Lot Capacity Total number of faculty and staff parking pass holders LOT A 250 310 LOT B 300 345 LOT C 350 400 The number of people showing up in each lot is independent of the others. On a typical day, the probability of a LOT A parking permit holder showing up is 85%, a LOT B parking permit holder showing up is 87%, and a LOT C parking permit holder showing up is 89%. What is the probability that on a typical day, at least one parking permit holder will be unable to find a parking space in LOT C? You need to build a simulation model to answer this question. Please complete and upload this partial template:  F_2023_Excel F7.xlsx 

Question F6 Johns Hopkins University has three parking lots…

Question F6 Johns Hopkins University has three parking lots on its Homewood campus, LOT A, LOT B, and LOT C. The following table shows each lot’s capacity and the number of parking pass holders.  Lot Capacity Total number of faculty and staff parking pass holders LOT A 250 310 LOT B 300 345 LOT C 350 400 The number of people showing up in each lot is independent of the others. On a typical day, the probability of a LOT A parking permit holder showing up is 85%, a LOT B parking permit holder showing up is 87%, and a LOT C parking permit holder showing up is 89%. Using what kind of distribution (with what parameter values) can you model the number of parking permit holders showing up in LOT A?

Question F13 – Use Excel File F13 for your answer. Suppose D…

Question F13 – Use Excel File F13 for your answer. Suppose Dr. N invests 25% of his hard-earned cash in four stocks, Apple, Microsoft, Tesla, and Costco. The following table shows the mean and standard deviation of each stock’s annual return.   Distributions of Returns   Mean Standard Deviation Apple 16% 21% Microsoft 12% 13% Tesla 25% 38% Costco 18% 20%   The correlations between the annual returns on the four stocks are as follows.     Correlation Matrix   Apple Microsoft Tesla Costco Apple 1 0.75 – 0.7 0.2 Microsoft 0.75 1 -0.2 0.5 Tesla -0.7 -0.2 1 0.65 Costco 0.2 0.5 0.65 1   You can assume that he has invested equal amounts in each of these stocks. Also it is safe to assume lognormal distribution for each stock return. Build a simulation that outputs this portfolio’s return. Please complete and upload this partial template: F_2023_Excel F13.xlsx

A manufacturing company produces a specialized component tha…

A manufacturing company produces a specialized component that has a defect rate of 3% per unit. However, before the defective unit reaches the customer, it passes through three independent quality control (QC) checkpoints: Checkpoint 1 detects 75% of defects. Checkpoint 2 detects 70% of the defects that remain after Checkpoint 1. Checkpoint 3 detects 50% of the defects that remain after Checkpoint 2.   If a customer receives a component, what is the probability that it is defective? Model the system using simulation. You need to create a template yourself for this problem. Rename it under your name before submitting it.