Question: Weekly copier paper demand Demand Probability 10 0.05 11 0.10 12 0.14 13 0.16 14 0.21 15 0.13 16 0.11 17 0.04 18 0.03 19

Weekly copier paper demand

Demand Probability

10 0.05

11 0.10

12 0.14

13 0.16

14 0.21

15 0.13

16 0.11

17 0.04

18 0.03

19 0.02

20 0.01

The probability distribution of a weekly demand for copier (in hundreds of reams) used in a corporation's duplicating center, as shown in file P04_27.xlsx.

a) Use simulation to generate 500 values of this random variable

b) Find the mean and standard deviation of the simulated values

Please help with work out and actual steps to do simulation. I was not sure what to put in the "Row input cell" and "Column input cell" of the Data Table.

Thanks.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

A quality inspector picks a sample of 15 items at random from a manufacturing process known to produce 10% defective items. Let X be the number of defective items found in the random sample of 15...

The probability distribution of X, the number of customers in line (including the one being served, if any) at a checkout counter in a department store, is given by P(X = 0) = 0.25, P(X = 1) = 0.25,...

CoursHeroTranscribedText: Question 1 The daily volume of a brokerage company follows a normal distribution. The director wants to estimate the daily volume negotiated. a) What size should have a...

2015 Rank 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 COMPANY NAME City Wal-Mart Stores Bentonville Exxon Mobil Irving Chevron San Ramon Berkshire Hathaway...

Spy is the proxy. There are three securities (AAPL, MSFT, and AMZN). Use regression approach. Please show formulas/steps. What is the Sharpe Ratio for the Regression Based Allocation Portfolio?...

Spy is the proxy. There are three securities (AAPL, MSFT, and AMZN). Use regression approach. Please show formulas/steps. What is the St. Dev. for the Equally Weighted Portfolio? 7.17% 7.42% 8.05%...

What is the suggested allocation for AMZN stock? 2.4002 0.00432 1.05203 0.1170 Spy is the proxy. There are three securities (AAPL, MSFT, and AMZN). Use regression approach. Please show excel...

What is the Intercept / Var( e ) ratio for AAPL? 0.01934 1.20826 0.00562 3.4404 0.1677 \ PLEASE SHOW FORMULAS/STEPS Only using 3 securities for this regression approach (AAPL, MSFT and AMZN). SPY is...

Last name: Enter your LETTER answers HERE 1B 2B 3A 4C 5C 6D 7C 8C 9D 10 B 11 B 12 A 13 B 14 D 15 A 16 C 17 B 18 C 19 A 20 B 21 B 22 C 23 A 24 25 26 27 28 29 30 1 First name: Note: When done, using...

Number of Observations in Subgroup DI 2 3 4 5 6 7 8 9 10 11 12 A2 1.88 1.02 0.73 0.58 0.48 0.42 0.37 0.34 0.31 0.29 0.27 0.25 0.24 0.22 0.21 0.20 0.19 0.19 0.18 B2 0.88 0.86 0.84 0.82 0.80 0.77 0.75...

Compound A (C7H13Br) is a tertiary bromide. On treatment with sodium ethoxide in ethanol, A is converted into B (C7H12). Ozonolysis of B gives C as the only product. Deduce the structures of A and B....

Rewrite each expression in the form bn in which n is a rational exponent. a. 6(a b. 10(b8 c. 1/(c d. (5(d)7

This project is about preparing a This project is about preparing a pro forma income statement for a newly opened private bookstore. This bookstore expects sales of $ 1 , 5 0 0 , 0 0 0 in the first...

In Figure a climber leans out against a vertical ice wall that has negligible friction. Distance a is 0.914 m and distance L is 2.10 m. His center of mass is distance d = 0.940 m from the feet-ground...

Let X, Y, Z be Boolean random variables. Label the eight entries in the joint distribution P (X. Y, Z) as a through h. Express the statement that X and Y are conditionally independent given Z as a...

A pistoncylinder device initially contains 0.6 kg of steam with a volume of 0.1 m3. The mass of the piston is such that it maintains a constant pressure of 800 kPa. The cylinder is connected through...

If the diameter X of axles has the density f(x) = k if 119.9

Could the DCF method be applied if the growth rate was not constant? How? MINI CASE During the last few years, Harry Davis Industries has been too constrained by the high cost of capital to make many...

Determine if the overhead allocated to the product relates to a single plantwide overhead rate method, multiple production department factory overhead rate method, or activity-based costing...

15.17 The paper referenced in the previous exercise also gave the following underscoring pattern for men: Treatment: 2 1 3 4 Mean number of pretzels consumed: 6.61 5.96 3.38 2.70 a. Write a few...

15.18 The paper referenced in Exercise 15.5 described an experiment to determine if restrictive age labeling on video games increased the attractiveness of the game for boys age 12 to 13. In that...

15.1 Give as much information as you can about the P-value for an upper-tailed F test in each of the following situations: a. df1 5 4, df2 5 15, F 5 5.37 b. df1 5 4, df2 5 15, F 5 1.90 c. df1 5 4,...