Excel File attached
With the discrete sampling option, select one hundred samples of size 30 from the population of waits. (It is necessary to assign a probability of 1/832 to each of the 832 waits before drawing the samples. This probability should appear in Column C). Be sure to generate a random seed using =RAND().
Calculate the mean, standard deviation, and standard error of each of the one hundred samples.
Generate a frequency distribution of the means of the one hundred samples, based on one standard deviation units around the mean of all sample means.
Display the resulting frequency distribution in a column graph and give some interpretation as to whether the distribution looks approximately normal or not.
12 years ago 5
Answer(1)
Purchase the answer to view it
NOT RATED
- excel_asignment.xls
Bids(1)
other Questions(10)
- ENG 125 Week 2 DQ 1
- managerial acounting
- f(x)=(3\x+2)+1 find the inverse of each function
- CaN you complete for $5
- For Henry Only..to be completed in 5 hours
- Which president earned a spot on the dime by leading the country during World War Two?
- Essay on Peter Singer's America's Shame
- Explain the differences between temporary disability and permanent disability claims. What are some theories that are used in handling permanent and partial disability cases?
- Chapter Ten Problems
- GBM 380 Week 5 COMPLETE