(a) Use the RAND function in Excel© to generate 100 values from a U(0,1) distribution. Calculate the average and compare it to 0.5, the expected value for a random sample between 0 and 1. (b) For the RAND function sample, cluster the results into cells of 0.1 width, that is, 0.0 to 0.1, 0.1 to 0.2, etc., where the upper-limit value is excluded from each cell. Determine the probability for each grouping from the results. Does your sample come close to having approximately 10% in each cell?
What will be an ideal response?
(a) When the RAND( ) function was used for 100 values in column A of a spreadsheet,
the function = AVERAGE(A1:A100) resulted in 0.50750658; very close to 0.5.
(b) For the RAND results, count the number of values in each cell to determine how
close it is to 10.
You might also like to view...
What is hollow core block?
What will be an ideal response?
The gas preflow and postflow times depend on which of the following?
A. Travel speed B. Torch angle C. Filler rod angle D. Nozzle size
A time base setting of 1ms/div will show a total time of ________ on the scope display
A) 10 ms B) 100 ms C) 1 ms D) None of these
When troubleshooting a residential heating system, the technician reads 24 volts at the gas valve on a call for heat, but the gas valve does not energize. What would be the most likely problem?
A. defective gas valve B. defective thermostat C. defective transformer D. blown low-voltage fuse