please solve each part of this question using excel Simulate a six-sided dice for 100 trials a.

please solve each part of this question using excel

Transcribed Image Text:

Simulate a six-sided dice for 100 trials a. Count the number of 1's,2's,3's,4's,5's and 6's and plot as a histogram, does this make sense b. Calculate the relative frequencies per trial for X = 1, X = 2, ..., X = 6 %3D i.e. count the number of 1's out of the number of trials. For example, there may have been three 1's generated out of the first 30, then we have 3 * 100 = 10% C. Plot the relative frequencies d. What do these tend towards, is this expected behaviour and what can you compare it with? e. Change the dice to be unfair with probabilities, note these probabilities sum to 1. • P(X = 1) = 0.1 • P(X = 2) = 0.2 P(X = 3) = 0.1 P(X = 4) = 0.2 P(X = 5) = 0.3 • P(X = 6) = 0.1 %3D %3D %3| Simulate a six-sided dice for 100 trials a. Count the number of 1's,2's,3's,4's,5's and 6's and plot as a histogram, does this make sense b. Calculate the relative frequencies per trial for X = 1, X = 2, ..., X = 6 %3D i.e. count the number of 1's out of the number of trials. For example, there may have been three 1's generated out of the first 30, then we have 3 * 100 = 10% C. Plot the relative frequencies d. What do these tend towards, is this expected behaviour and what can you compare it with? e. Change the dice to be unfair with probabilities, note these probabilities sum to 1. • P(X = 1) = 0.1 • P(X = 2) = 0.2 P(X = 3) = 0.1 P(X = 4) = 0.2 P(X = 5) = 0.3 • P(X = 6) = 0.1 %3D %3D %3|

Answer rating: 100% (QA)

a Name in A1 cell as Result Then in A2 cell type RANDBETWEEN16 and get the value Than select the A2 cell and drag in until A101 cell Thus 100 random n... View the full answer