Question: Generate 200 estimates for each sample size: 1. Highlight the cell range A2:C2 on Estimates sheet and fill down to the cell range A2:C201 Prepare

Generate 200 estimates for each sample size: 1. Highlight the cell range A2:C2 on "Estimates" sheet and fill down to the cell range A2:C201 Prepare to make a histogram by defining the bins: 2. In cell E1, type "Bins" in bold 3. In cell E2, type "59.0" 4. In cell E3, type "59.5" 5. Highlight the cell range E2:E3, then fill down to the cell range E2:E30 Make a histogram for the estimates based on samples of size 4: 1. Select Data > Data Analysis > Histogram, then click OK 2. Under Input, set the input range to A:A and the bin range to E1:E30 3. Check the box for Labels 4. Under Output options, set the output range to G1 5. Check the box for Chart Output 6. Click OK 7. Enlarge the histogram by dragging a corner 8. Right-click on one of the histogram bars, then select Format Data Series... 9. Set the gap width to 10% 10. Title the histogram "Estimates (n = 4)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!