Let Z be a standard normal random variable. Estimate via simulation P(Z² < 2)
Q: What does the worst-case scenario simulation model tell you that Monte Carlo simulation does not?…
A: Worst case scenario – It deals with the worst-case scenario. When making a net present value…
Q: W. L. Brown, a direct marketer of women’s clothing,must determine how many telephone operators…
A: The aforementioned question is answered as below:
Q: The management of the Keribels Company wishes to apply the Miller-Orr model to manage its cash…
A: Given data, Transaction cost =$100 Cash flow variance=75000 I =0.05%
Q: A) Why is the conditional variance a good measure of uncertainty? B) Outline the GARCH model and…
A: The expectation of a random variable's squared deviation from its population mean or sample mean is…
Q: You have prepared a coin flipping simulation. In your simulation, a value of less than 0.5 is…
A: ANSWER : Given the value less then 0.5 is designated as " Heads " 0.180 Heads 0.571 Tails…
Q: Suppose you are an HR (human resources) manager at a big university, and you sense that the…
A: As an HR manager at a big university, it will create a great responsibility to cope up with the…
Q: he probability that a mobile phone is stolen in an electronic shop is 0.0008. If 8500 mobile phones…
A: Quality refers to the degree of excellence of something. Quality has some standard on the basis of…
Q: WHAT WLL HAPPEN IF THERE IS A CHANGE IS ONE OF THE OBJECTIVE FUNCTION COEFFICIENT? A. SLOPE OF THE…
A: Every change in the worth of a target work coefficient will lead to a changed optimal solution. When…
Q: The methods used to capture the effect of several sources of uncertainty will in practice often…
A: We will evaluate the statement and options The statement is that "the methods to capture the effect…
Q: My current income is $40,000. I believe that I owe$8,000 in taxes. For $500, I can hire a CPA to…
A:
Q: Suppose you are a financial analyst and your company runs many simulation models to estimate the…
A: Simulation modeling: A simulation model is a computerized model that would depict or imitate a…
Q: The methods used to capture the effect of several sources of uncertainty will in practice often…
A: Simulation helps in modelling random events that helps in evaluating the performance of various…
Q: In a nonlinear programming model, for any set of values of the decision variables, whether or not…
A: False
Q: We must invest all our money in two stocks: x and y.The variance of the annual return on one share…
A:
Q: You have prepared a coin flipping simulation. In your simulation, a value of less than 0.5 is…
A: In this question, we have to calculate the number of trials required for head and tail. Random…
Q: Explain the steps to be followed in Monte Carlo simulation
A: Monte Carlo simulation makes use of the concept of producing random numbers to generate values for…
Q: The central limit theorem implies which of the following: a. The averages of many random…
A: The central limit theorem implies that the distribution of sample averages follows a normal…
Q: A contractor submits a bid on a project for which more research and development work needs to be…
A: A standard deviation is a statistic that measures a dataset's dispersion from the mean. By…
Q: You own a coffee shop in a metro Toronto shopping mall. It is Friday evening and you are trying to…
A: We have to find the value of payoff for quality baked(Q)+demand(D) by using below formula
Q: Xo Present Xo1 Xo1 Year 1 Хоз X12 X13 $4,000 Year 2 X23 $14,000 Year 3 How many decision variables…
A: Here the decision variables will be for present to years and from years to years
Q: a. What is the optimal value of x?
A: A linear equation using to find the optimal value of a problem. Minimizing the C indicating the…
Q: Suppose you are going on a weekend trip to a city that is d miles away. Develop a model that…
A: 1.Model development Determine the inputs The variable d' = the distance to the city Account for the…
Q: Select the least accurate statement regarding simulation. In a simulation, correlation between two…
A: In insights, connection or reliance is any factual relationship, if causal, between two arbitrary…
Q: A metropolitan school system consists of three districts—north, south, and central. The north…
A: A metropolitan school has different district where students studies, They have given details of…
Q: Compcomm, Inc., is an international communications andinformation technology company that has seen…
A: The simulation model is following
Q: A forest consists of two types of trees: those that are 0–5 ft and those that are taller than 5 ft.…
A: Step 1: As each year 40% of all 0-5ft trees die and other 10% are sold. That means the probability…
Q: You have prepared a coin flipping simulation. In your simulation, a value of less than 0.5 is…
A: Given simulations random numbers : 0.021, 0.323, 0.200, 0.157, 0.278, 0.886, 0.699, 0.038, 0.315,…
Q: The output distribution form(s) of the input distribution(s) are generally fairly straightforward to…
A: A correlation matrix must always have 1s along its diagonal and figures between -1 and +1 elsewhere…
Q: We are considering investing in three stocks. The randomvariable Si represents the value one year…
A:
Q: Appliances Unlimited (AU) sells refrigerators. Anyrefrigerator that fails before it is three years…
A: Warranty refers to a facility that is provided to consumers in case of any malfunctioning product…
Q: The members of a private golf club have handicaps that are normally distributedwith mean 15 and…
A: Hence, the standard deviation of sample mean is 1.75.
Q: Why is the RISKCORRMAT function necessary?How does @RISK generate random inputs by default,that is,…
A: RISKCORMMAT is considered as an function that helps in correlating two or more variables in the…
Q: In the figure below, no probabilities are known for the occurrence of the nature states. For the…
A: Note: - Since we can answer only three subparts, we will answer the first three subparts here. If an…
Q: output variable of interest from a simulation model will be a............ Variable Independent…
A: Random Variable
Q: Suppose that Pizza King and Noble Greek stopadvertising but must determine the price they will…
A: Let us first find all the possible actions available to Pizza King in this case: 1) Pizza King sell…
Q: The management of the Keribels Company wishes to apply the Miller-Orr model to manage its cash…
A: Given data, Transaction cost =$100 Cash flow variance=75000 I =0.05%
Q: A version of simple exponential smoothing can beused to predict the outcome of sporting events. To…
A: The forecasting of the future value for a set of observations. Forecast the value of time series…
Q: You have prepared a coin flipping simulation. In your simulation, a value of less than 0.5 is…
A: Below is the solution:-
Q: 7. Investment Advisors, Inc., is a brokerage firm that manages stock portfolios for a number of…
A: Given, Max 3U+5H s.t 25U+50H <= 80000 0.5U+0.25D <= 700 U <= 1000 U,H >= 0
Q: Investment Advisors, Inc., is a brokerage firm that manages stock portfolios for a number of…
A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…
Q: The manager of a bakery knows that the number of chocolate cakes he can sell on any given day is a…
A:
Q: MacBurger has just opened a fast-food restaurant inBloomington. Currently, i0 customers frequent…
A: Currency Frequency of Mac Burger is i_{0} customers and (N-i_{0}) customers frequent another…
Q: A valid reason for using simulation model is: a. analyze relationship between the variables which…
A: Simulation modeling is nothing but the technique of developing and examining automated or digital…
Q: Suppose that for years East Campus' short-run Phillips Curve was such that each 1 percentage point…
A: given, East Campus' short-run Phillips Curve was such that each I percentage point increase in its…
Q: Home mortgage lenders often charge points on a loan in order to avoid exceeding a legal limit on…
A: Given data, The lender would loan $98 for each $100 borrowed The borrower receives $ 98 Loan…
Q: When preforming sensitivity analysis, it is possible for your objective function value to change…
A: \The opportunity/reduced cost of a given decision variable are often interpreted because the rate at…
Q: You have prepared a coin flipping simulation. In your simulation, a value of less than 0.5 is…
A: In a random experiment, the probability is an indicator of how likely an occurrence is to take…
Please solve and code in R if possible.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- If you want to replicate the results of a simulation model with Excel functions only, not @RISK, you can build a data table and let the column input cell be any blank cell. Explain why this works.Simulation can be used to illustrate a number of results from statistics that are difficult to understand with nonsimulation arguments. One is the famous central limit theorem, which says that if you sample enough values from any population distribution and then average these values, the resulting average will be approximately normally distributed. Confirm this by using @ RISK with the following population distributions (run a separate simulation for each): (a) discrete with possible values 1 and 2 and probabilities 0.2 and 0.8; (b) exponential with mean 1 (use the RISKEXPON function with the single argument 1); (c) triangular with minimum, most likely, and maximum values equal to 1,9, and 10. (Note that each of these distributions is very skewed.) Run each simulation with 10 values in each average, and run 1000 iterations to simulate 1000 averages. Create a histogram of the averages to see whether it is indeed bell-shaped. Then repeat, using 30 values in each average. Are the histograms based on 10 values qualitatively different from those, based on 30?The annual demand for Prizdol, a prescription drug manufactured and marketed by the NuFeel Company, is normally distributed with mean 50,000 and standard deviation 12,000. Assume that demand during each of the next 10 years is an independent random number from this distribution. NuFeel needs to determine how large a Prizdol plant to build to maximize its expected profit over the next 10 years. If the company builds a plant that can produce x units of Prizdol per year, it will cost 16 for each of these x units. NuFeel will produce only the amount demanded each year, and each unit of Prizdol produced will sell for 3.70. Each unit of Prizdol produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. a. Among the capacity levels of 30,000, 35,000, 40,000, 45,000, 50,000, 55,000, and 60,000 units per year, which level maximizes expected profit? Use simulation to answer this question. b. Using the capacity from your answer to part a, NuFeel can be 95% certain that actual profit for the 10-year period will be between what two values?
- When you use @RISKs correlation feature to generate correlated random numbers, how can you verify that they are correlated? Try the following. Use the RISKCORRMAT function to generate two normally distributed random numbers, each with mean 100 and standard deviation 10, and with correlation 0.7. To run a simulation, you need an output variable, so sum these two numbers and designate the sum as an output variable. Run the simulation with 1000 iterations and then click the Browse Results button to view the histogram of the output or either of the inputs. Then click the Scatterplot button below the histogram and choose another variable (an input or the output) for the scatterplot. Using this method, are the two inputs correlated as expected? Are the two inputs correlated with the output? If so, how?In Example 11.2, the gamma distribution was used to model the skewness to the right of the lifetime distribution. Experiment to see whether the triangular distribution could have been used instead. Let its minimum value be 0, and choose its most likely and maximum values so that this triangular distribution has approximately the same mean and standard deviation as the gamma distribution in the example. (Use @RISKs Define Distributions window and trial and error to do this.) Then run the simulation and comment on similarities or differences between your outputs and the outputs in the example.Although the normal distribution is a reasonable input distribution in many situations, it does have two potential drawbacks: (1) it allows negative values, even though they may be extremely improbable, and (2) it is a symmetric distribution. Many situations are modelled better with a distribution that allows only positive values and is skewed to the right. Two of these that have been used in many real applications are the gamma and lognormal distributions. @RISK enables you to generate observations from each of these distributions. The @RISK function for the gamma distribution is RISKGAMMA, and it takes two arguments, as in =RISKGAMMA(3,10). The first argument, which must be positive, determines the shape. The smaller it is, the more skewed the distribution is to the right; the larger it is, the more symmetric the distribution is. The second argument determines the scale, in the sense that the product of it and the first argument equals the mean of the distribution. (The mean in this example is 30.) Also, the product of the second argument and the square root of the first argument is the standard deviation of the distribution. (In this example, it is 3(10=17.32.) The @RISK function for the lognormal distribution is RISKLOGNORM. It has two arguments, as in =RISKLOGNORM(40,10). These arguments are the mean and standard deviation of the distribution. Rework Example 10.2 for the following demand distributions. Do the simulated outputs have any different qualitative properties with these skewed distributions than with the triangular distribution used in the example? a. Gamma distribution with parameters 2 and 85 b. Gamma distribution with parameters 5 and 35 c. Lognormal distribution with mean 170 and standard deviation 60
- Based on Babich (1992). Suppose that each week each of 300 families buys a gallon of orange juice from company A, B, or C. Let pA denote the probability that a gallon produced by company A is of unsatisfactory quality, and define pB and pC similarly for companies B and C. If the last gallon of juice purchased by a family is satisfactory, the next week they will purchase a gallon of juice from the same company. If the last gallon of juice purchased by a family is not satisfactory, the family will purchase a gallon from a competitor. Consider a week in which A families have purchased juice A, B families have purchased juice B, and C families have purchased juice C. Assume that families that switch brands during a period are allocated to the remaining brands in a manner that is proportional to the current market shares of the other brands. For example, if a customer switches from brand A, there is probability B/(B + C) that he will switch to brand B and probability C/(B + C) that he will switch to brand C. Suppose that the market is currently divided equally: 10,000 families for each of the three brands. a. After a year, what will the market share for each firm be? Assume pA = 0.10, pB = 0.15, and pC = 0.20. (Hint: You will need to use the RISKBINOMLAL function to see how many people switch from A and then use the RISKBENOMIAL function again to see how many switch from A to B and from A to C. However, if your model requires more RISKBINOMIAL functions than the number allowed in the academic version of @RISK, remember that you can instead use the BENOM.INV (or the old CRITBENOM) function to generate binomially distributed random numbers. This takes the form =BINOM.INV (ntrials, psuccess, RAND()).) b. Suppose a 1% increase in market share is worth 10,000 per week to company A. Company A believes that for a cost of 1 million per year it can cut the percentage of unsatisfactory juice cartons in half. Is this worthwhile? (Use the same values of pA, pB, and pC as in part a.)Assume a very good NBA team has a 70% chance of winning in each game it plays. During an 82-game season what is the average length of the teams longest winning streak? What is the probability that the team has a winning streak of at least 16 games? Use simulation to answer these questions, where each iteration of the simulation generates the outcomes of all 82 games.Suppose you have invested 25% of your portfolio in four different stocks. The mean and standard deviation of the annual return on each stock are shown in the file P11_46.xlsx. The correlations between the annual returns on the four stocks are also shown in this file. a. What is the probability that your portfolios annual return will exceed 30%? b. What is the probability that your portfolio will lose money during the year?
- The DC Cisco office is trying to predict the revenue it will generate next week. Ten deals may close next week. The probability of each deal closing and data on the possible size of each deal (in millions of dollars) are listed in the file P11_55.xlsx. Use simulation to estimate total revenue. Based on the simulation, the company can be 95% certain that its total revenue will be between what two numbers?Suppose you simulate a gambling situation where you place many bets. On each bet, the distribution of your net winnings (loss if negative) is highly skewed to the left because there are some possibilities of really large losses but not much upside potential. Your only simulation output is the average of the results of all the bets. If you run @RISK with many iterations and look at the resulting histogram of this output, what will it look like? Why?If you add several normally distributed random numbers, the result is normally distributed, where the mean of the sum is the sum of the individual means, and the variance of the sum is the sum of the individual variances. (Remember that variance is the square of standard deviation.) This is a difficult result to prove mathematically, but it is easy to demonstrate with simulation. To do so, run a simulation where you add three normally distributed random numbers, each with mean 100 and standard deviation 10. Your single output variable should be the sum of these three numbers. Verify with @RISK that the distribution of this output is approximately normal with mean 300 and variance 300 (hence, standard deviation 300=17.32).