Statistics in excel Thank you for your help In this exercise, you will simulate

Question

Statistics in excel

Thank you for your help

In this exercise, you will simulate the distribution of the estimator you used in the previous assignment. Here is the problem in case you forgot (don't do the coin toss manually again, you will use a computer this time Pick a coin. Define Xn to be equal to one if the outcome of tossing the coin is "heads" and zero if the outcome is "tails". The subscript n indexes the order of the experiments: n 1 means the first time you toss the coin n 2 means the second time you tossed the coin, and so on. For example, X3 0 is a shorthand for the sentence "when you tossed the coin the third time the outcome was tails Toss the coin and record the outcome. 1 Call it X1. Toss the coin again and record the outcome. Call it X2 Toss the coin again and record the outcome. Call it X3 Continue the experiment in the same fashion until you toss the coin 20 times. Put your results in a table with two columns. The first column you have An and the second column you have the value that Xn took in your sample See the table below as an example Experiment (n) Outcome Xn Heads 1 Tails 0 Tails 0 Tails 0 Heads 1 Tails 0 Heads 1 Heads 1 Heads 1 10 Heads 1 PIX 6/10

Explanation / Answer

Copy and paste the following link into adress bar https://goo.gl/ew96Po and enter.

Go to File > Download as > Microsoft Excel.

All calculations are done in google spreedsheet. Question 2 is on next sheet.

• Shape of the distribution for question 1 is more wider than the question 2. Spread of estimates is more for question 1 (i.e. from 0.1 to 1) and less for question 2 ( i.e. from 0.4 to 0.7). As the sample size increases, we get more precise estimate.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---