Hello: I am working on some homework problems for decision modeling. Here is the question: The...

Hello:

I am working on some homework problems for decision modeling. Here is the question: The weekly deman for a slow moving product has the following probability mass function:

Demand, x Probability f(x)

0 0.2

1 0.4

2 0.3

3 0.1

4 or more 0

Use VLOOKUP to generate 25 random variates from this distribution. I know i have to use RAND and VLOOKUP I just cannot get it to give me 25 random numbers. Thank you for any help you can give me.

Solutions

Expert Solution

orchestra answered 11 months ago

Next > < Previous

Related Solutions

Hello, I am struggling to understand some of my accounting homework. Question 01 ) Tulsa Company...

Hello, I am struggling to understand some of my accounting homework. Question 01 ) Tulsa Company is considering investing in new bottling equipment and has two options: Option A has a lower initial cost but would require a significant expenditure to rebuild the machine after four years; Option B has higher maintenance costs, but also has a higher salvage value at the end of its useful life. Tulsa’s cost of capital is 11 percent. The following estimates of the cash...

I am stumped on these problems and homework question, please could I get the answers to...

I am stumped on these problems and homework question, please could I get the answers to the questions below from an expert. Thank you 5). Suppose that two population proportions are being compared to test weather there is any difference between them. Assume that the test statistic has been calculated to be z= 2.21. Find the p-value for this situation? a). p-value = 0.4864 b). p-value = 0.0272 c). p-value = 0.9728 d). p-value = 0.0136. 8). If you are...

Hello, I am having trouble with my Advanced Accounting Ch 18 homework. Accounting for nonprofts. Here...

Hello, I am having trouble with my Advanced Accounting Ch 18 homework. Accounting for nonprofts. Here are a few questions: At the beginning of the year, Nutrition Now, a health and welfare not-for-profit entity, had the following equity balances: Net assets without donor restriction $400,000 Net assets with donor restriction $290,000 1. Unrestricted contributions (pledges) of $250,000, to be collected in cash in thirty days, before the end of the year, are received. 2. Salaries of $27,000 are paid with...

I am trying to work a statistics problem for decision modeling class. The main question is:...

I am trying to work a statistics problem for decision modeling class. The main question is: Consider the experiment of drawing two cards without replacement from a deck consisting of only the ace through 10 of a single suit (for example, only hearts). Q - Define the event Ai to be the set of outcomes for which the sum of the values of the cards is i (with an ace = 1). List the outcomes associated with Ai for i=...

Hello, I am working on an assignment but I am unsure of how to solve it....

Hello, I am working on an assignment but I am unsure of how to solve it. Please help me. The assignment details are below. Consider this scenario: Your friend starts a website, nothingbutflags.com, which is not making money. Your friend asks you to help generate more traffic. You ask your friend how much traffic the website had last month? And your friend replies and says only 500 visits. You also ask how many flags did you sell? Your friend replies...

Hello, I am working on an assignment but I am unsure of how to solve it....

Hi, I am doing up my homework on mathematics and here are some questions. I want...

Hi, I am doing up my homework on mathematics and here are some questions. I want to cross-reference my answers thank you. Decide if the statements below are True or False. Please include some rough workings for me to understand: (1) Mr. Tan borrowed $500,000 from Bank XYZ at 5% annual interest to be repaid monthly over 20 years. The amount that he pays back to XYZ each month is between $3000 to $3500. (2) Continuing from (1): after 15...

Here is a project I am currently working on and I could use some feedback on...

Here is a project I am currently working on and I could use some feedback on how to get started. I calculated the general probabilities for the first two columns of each spreadsheet (successes / total outcomes). I don't want to move forward until I know I'm on the right track but I'm concerned that I've oversimplified the question being asked. I'm also using Excel and am having a hard time finding an appropriate formula for conditional probability. My book...

Hello, I am comparing homework. Thanks, Question 5 Which of the following is TRUE concerning operating...

Hello, I am comparing homework. Thanks, Question 5 Which of the following is TRUE concerning operating income calculated under variable costing as compared to absorption costing? Select one: A. Operating income is lower under variable costing when production exceeds sales. B. Operating income is higher under variable costing when production exceeds sales. C. operating income is higher under variable costing when production exceeds sales only if there is a production-volume variance. D. Operating income is lower under variable costing when...

Hi I am working on my chemistry homework about acids and bases and I am confused...

Hi I am working on my chemistry homework about acids and bases and I am confused on this question from a lab. We used grape juice and cranberry juice and we had to put HCl and NaOH in the test tube full of juice. 1. Referring back to procedure 1 of the experiment, which of the two juices is more useful as a general pH indicator and why? I think it is grape juice but I just don't know what...

Subjects