Question

Need some help with this excel spreadshee, question and graph will be poster below.

Answer 1

The underelying experiment is running fifty times a Benoulli process of unknown mean fifty times and counting the number of positive outcomes. This experiment is conducted 500 times, with the results recorded each time in column A. (You can find the generation in the spreadsheet if you wish.) In column C are bins by multiples of 5, for the possible values that the experiment can yield. In column D you are to record the frequencies with which these bin values occur in the data. In column E you are to record the relative frequencies with which these values occur. In cell H2 you are to compute the mean of the data, and then use this mean in column F to give the theoretical probabilities that a Binomial process with the computed mean will take on the values from column C. (That is, you are to complete the cells of the shaded region.)

Answer 2

more precisely how i'm support to use the binormal distribution in the theory for the spreadsheet.