Question: Repeat Problem 23, but now make the second input variable triangularly distributed with parameters 50, 100, and 500. This time, verify not only that the

Repeat Problem 23, but now make the second input variable triangularly distributed with parameters 50, 100, and 500. This time, verify not only that the correlation between the two inputs is approximately 0.7, but also that the shapes of the two input distributions are approximately what they should be: normal for the first and triangular for the second. Do this by creating histograms in Excel. The point is that you can use @RISK’s RISKCORRMAT function to correlate random numbers from different distributions.

Step by Step Solution

★★★★★

3.48 Rating (165 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

415-M-S-S-M (204).xlsx

300 KBs Excel File

Students Have Also Explored These Related Statistics Questions!

Create a power point presentation that you can use to pitch your plan to executives of the KFC Company. Consider the principles of marketing you learned throughout the course when proposing your...

Use @RISK to draw a triangular distribution with parameters 300, 500, and 900. Then answer the following questions. a. What are the mean and standard deviation of this distribution? b. What are the...

Use @RISK to draw a triangular distribution with parameters 200, 300, and 600. Then superimpose a normal distribution on this drawing, choosing the mean and standard deviation to match those from the...

Repeat Problem 23, but now make the second input variable triangularly distributed with parameters 50, 100, and

Exercises Chapter 2 2.1 Marginal and conditional probability: The social mobility data from Section 2.5 gives a joint probability distribution on (Y1 , Y2 )= (father's occupation, son's occupation)....

,.. I need your input here please Amanda's utility function is Leontief and given by Wa(Xarya) = min(xa. yal while Brenda's utility is linear and given by us(xb. )b) = XD + VD Their endowments are wa...

Probability and Statistics - Problem Set c Keith M. Chugg October 2, 2015 1 Preliminaries, Combinatorics, Set Probability 1.1. A number of bats are in a cave. 2 bats can see out of their left eye. 3...

1. A player throws a fair die and simultaneously flips a fair coin. If the coin lands heads, then she wins twice, and if tails, then one-half of the value that appears on the die. Determine her...

Set Student Name: 1. Describe the relationship between two variables that have a correlation coefficient value: a. Near -1 b. Near 0 c. Near 1 2. Data was collected where a weightlifter was asked to...

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

EX1: (ABC) Corporation was organized on January 2, 2018 with 300000 share, par value per share 3 OMR, and 15000 share preferred share with 25 par value. On 5/1/2015 (X) CO. issued 25000 shares at RO...

The following data are production cost data from PT "BOMBOMCAR" at the end of 2019 o Production in 2019 10,000,000 units o 70% of 2019 production was sold and the rest is still in the warehouse at...

Demand for raw materials is a (A) direct demand (B) positive externality (C) fixed cost (D) derived demand (E) negative externality

7. When does a premium on bonds payable occur?

The Blooming Flower Co. has earnings of $2.14 per share. The benchmark PE for the company from a comparables analysis is 18. What stock price would you consider appropriate? What if the benchmark PE...

Universal Laser, Inc., just paid a dividend of $2.73 on its stock. The growth rate in dividends is expected to be a constant 4 percent per year indefinitely. Investors require a return of 15 percent...

Metallica Bearings, Inc., is a young start-up company. No dividends will be paid on the stock over the next 11 years, because the firm needs to plow back its earnings to fuel growth. The company will...

of XYZ Corporation is faced with two mutually exclusive investment opportunities. The cost of capital is 12 percent. The cash flows for the two projects are: Project A Project B Year Cash Flow Cash...

Shannon Industries is considering a project that has the following cash flows : Year CF 0 -6240 1 1980 2 3750 3 ? 4 1000 The project has a payback of 2.25 years. The firms cost of capital is 9.3...

Consider the following information about three stocks: a-1. If your portfolio is invested 40 percent each in A and B and 20 percent in C, what is the portfolio expected return? (Do not round...