Using, for example, the command “=IF(RAND()<0,4;1;0)” in Excel, simulate 40 different realizations with n = 60...

Using, for example, the command “=IF(RAND()<0,4;1;0)” in Excel, simulate 40 different realizations with n = 60 and the true supporting rate to be 40%. In order to “freeze” the output generated by Excel, select the cells with all 0s and 1s values that have been randomly generated using the above mentioned command, copy them and paste them (using the paste special option) as values back on top of the cells. Then in each of the 40 different simulated “datasets” calculate Y, i.e. total number of 1s (voters). Finally create a histogram of your 40 values of Y .Calculate the mean,median,standart deviation and the mode....construct as well the frequency and discuss your findings.

Expert Solution

Discussion: It can be seen that the distribution of the number of 1's that is simulated is not perfectly normal because the mean, median, and mode are not equal but they are close to each other hence we can say that the distribution of 1's is approaching normal distribution. The standard deviation is 4.14 that means on an average all the number of 1's are 4.14 far from the mean.

Argument: We should increase the number of samples of the same size(60) because a sample of size 40 is small, this will help us to identify a better frequency distribution of the number of 1's.

orchestra answered 2 years ago

Using, for example, the command “=IF(RAND()<0,4;1;0)” in Excel, simulate 40 different realizations with n = 60...

Using, for example, the command “=IF(RAND()<0,4;1;0)” in Excel, simulate 40 different realizations with n = 60 and the true supporting rate to be 40%. In order to “freeze” the output generated by Excel, select the cells with all 0s and 1s values that have been randomly generated using the above mentioned command, copy them and paste them (using the paste special option) as values back on top of the cells. Then in each of the 40 different simulated “datasets” calculate...

3. Only using the runif function with default settings, generate: (a) n = 1e4 iid realizations...

3. Only using the runif function with default settings, generate: (a) n = 1e4 iid realizations from a Bernoulli distribution with probability of success parameter, θ = 0.7. (b) n = 1e4 iid realizations from a Binomial distribution with probability of success parameter, θ = 0.7 and number of trials= 20. (c) n = 1e4 iid realizations from an Exponential distribution with mean µ = 7 (hint: if X ~ Exp(µ) then Var(X) = µ2 ). For each case comment...

a. A mixture of 60 mol % n-proplycyclohexane and 40 mol % n-propylbenzene is distilled through...

a. A mixture of 60 mol % n-proplycyclohexane and 40 mol % n-propylbenzene is distilled through a simple distillation apparatus; assume that no fractionation occurs during the distillation. The boiling temperature is found to be 157 °C (760 torr) as the first small amount of distillate is collected. The standard vapor pressures of n-propylcyclohexane and n-propylbenzene are known to be 769 torr and 725 torr, respectively, at 157.3 °C. Calculate the percentage of each of the two components in the...

• Develop an "Echo" command that returns the parameters on different lines. Example: For input "$...

• Develop an "Echo" command that returns the parameters on different lines. Example: For input "$ Java Echo Hello world!" The answer will be: "Hello world ! ” using java programming language

A distillation column receives a feed that is 40 mole % n-pentane and 60 mole %...

A distillation column receives a feed that is 40 mole % n-pentane and 60 mole % n-hexane. The feed is saturated liquid at 2,500 lbmol/hr. The column is at 1 atm. A distillate that is 97 mole % n-pentane is desired. A total condenser is used. The reflux is a saturated liquid. The external reflux ratio is L0/D = 3. The bottoms from the partial reboiler is 2 mole % n-pentane. Determine the intersection (xq, yq) of the q-line with...

100 moles/min of a mixture of 40 mol% n-pentane and 60 mol% n-heptane are fed through...

100 moles/min of a mixture of 40 mol% n-pentane and 60 mol% n-heptane are fed through a valve into a flash tank. The flash tank operates at 600 mmHg. A T-xy diagram is provided on the next page. (a) Determine the bubble point and dew point of the feed mixture at 600 mmHg. (b) If the flash tank is operating at 60 0C determine; a. the compositions of the streams leaving the flash tank b. the flow rate in liters/min...

You will be finding probabilities using excel. Use the Excel instructions for Binomial Distribution (=BINOMDIST(x, n,...

You will be finding probabilities using excel. Use the Excel instructions for Binomial Distribution (=BINOMDIST(x, n, p, true or false)) False is equivalent to binompdf. True is equivalent to binomcdf. Show in excel! a.) P(x ≤ 6), n = 20, p = .8 b.) P(x < 4), n = 20, p = .15 c.) P(x ≥ 14), n = 30, p = .35 d.) State which part is unusual.

Using the data set below: Score Frequency 20-30 5 30-40 8 40-50 13 50-60 12 60-70...

Using the data set below: Score Frequency 20-30 5 30-40 8 40-50 13 50-60 12 60-70 5 Draw a Histogram Draw a polygon After listening to YouTube “histogram and polygon,” explain how histogram is different and similar to polygon.

Exercise 1: The example exercise is to work through a loan amortization example using Excel. Open...

Exercise 1: The example exercise is to work through a loan amortization example using Excel. Open Activity 3-Workbook. Go to Exercise 1 worksheet. The example loan conditions are (enter these values under Loan Terms): Loan amount borrowed (principal or pv) $100,000 Loan interest (rate) is 7.5% Loan term (number of payments or nper) is 9 years Annual payments of principal and interest Calculate the annual loan payment in cell C7 using the PMT function in...

Firm A purchases $150,000 in inventory using 40% cash and 60% Accounts Payable. Which of the...

Firm A purchases $150,000 in inventory using 40% cash and 60% Accounts Payable. Which of the following statements is false? Firm A's shareholder equity was unaffected Firm A's current assets decreased by $60,000 Firm A's inventory increased by $150,000 Firm A's liabilities increased by $90,000 2. A client purchases $200,000 worth of goods and pays 25% cash. Which of the following statements is true? Current assets increase by $200,000 Liabilities increase by $150,000 Shareholder’s equity increases by $50,000 Account receivable...

Question

Using, for example, the command “=IF(RAND()<0,4;1;0)” in Excel, simulate 40 different realizations with n = 60...

Solutions

Expert Solution

Related Solutions

Using, for example, the command “=IF(RAND()<0,4;1;0)” in Excel, simulate 40 different realizations with n = 60...

3. Only using the runif function with default settings, generate: (a) n = 1e4 iid realizations...

a. A mixture of 60 mol % n-proplycyclohexane and 40 mol % n-propylbenzene is distilled through...

• Develop an "Echo" command that returns the parameters on different lines. Example: For input "$...

A distillation column receives a feed that is 40 mole % n-pentane and 60 mole %...

100 moles/min of a mixture of 40 mol% n-pentane and 60 mol% n-heptane are fed through...

You will be finding probabilities using excel. Use the Excel instructions for Binomial Distribution (=BINOMDIST(x, n,...

Using the data set below: Score Frequency 20-30 5 30-40 8 40-50 13 50-60 12 60-70...

Exercise 1: The example exercise is to work through a loan amortization example using Excel. Open...

Firm A purchases $150,000 in inventory using 40% cash and 60% Accounts Payable. Which of the...