please solve each part of this question using excel

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|