Question

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 and discuss your findings.

Answer 1

SOLUTION:

Initially data was generated according to the given formula in excel .Unable to paste those random generated data due to Answering character limit,Below is the Y values for each simulation.

Simulation number	Y
1	25
2	21
3	26
4	22
5	25
6	24
7	30
8	26
9	31
10	23
11	24
12	31
13	20
14	28
15	20
16	25
17	31
18	24
19	21
20	24
21	29
22	23
23	28
24	30
25	26
26	22
27	26
28	22
29	23
30	20
31	25
32	24
33	21
34	25
35	21
36	25
37	28
38	25
39	22
40	23

From the graph data is uniformly distributed and out of 40 ,25 simulations have support more than 40.