Blog

Question F15 – Use Excel File F15 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 will lose money in one year. Please complete and upload this partial template: F_2023_Excel F15.xlsx 

A grocery store sells fresh produce, and its daily demand follows a Poisson distribution with a mean of 40 units per day. The ordering lead time follows a triangular distribution with a minimum of 1 day, most likely of 2 days and a maximum of 4 days, meaning that lead times are uncertain. Reminder: lead time is the time between ordering and order arrival.  The store follows an inventory policy where it reorders 200 units when inventory drops below 100 units. Simulate the inventory system over a 60-day period to estimate the probability of a stockout (having zero inventory before a replenishment arrives). You need to create a template yourself for this problem. Rename it under your name before submitting it.

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

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 

Return on Investment (ROI) and Return on Assets (ROA) are examples of measures of an organization’s performance from an internal business perspective.

Students’ end-of-semester evaluations of the teaching performance of their professor should be viewed as measures of their professor’s typical rather than maximum performance.

A suggestion to improve the quality of self-appraisals of job performance is to use absolute as opposed to comparative measurement systems.

The work (or job) analytic technique typically used to develop BARS involves subject-matter experts rating the frequency and criticality of various work tasks.

Procedural knowledge is:

Briefly explain the difference between anomaly and signature-based IDS/IPSes.