In: Statistics and Probability
Use formula U=a+(b-a)*RAND( ) to obtain a sample of 25 outcomes for a game of Battleship as described in Problem 34 (The time required to play a game of Battleship is uniformly distributed between 15 and 60 minutes). Find the average and standard deviation for these 25 outcomes.
MS Excel is used
a=15, b=60
Hence U= a+(b-a)*RAND() becomes 15+45*RAND()
In excel direct functions like = AVERAGE (number1,[number2..) and=STDEV(number1,[number2]..) are used to find average and standard deviation..