Statistics: Informed Decisions Using Data (4th Edition)

Published by Pearson
ISBN 10: 0321757270
ISBN 13: 978-0-32175-727-2

Chapter 7 - Section 7.1 - Assess Your Understanding - Vocabulary and Skill Building - Page 367: 17e

Answer

$proportion=0.215$ (other answers are also possible) This result is close to the result obtained in part (b).

Work Step by Step

In EXCEL, select A1, type "=RAND()" and press Enter. Select A1 and drag down the formula "=RAND()" from A1 to A200. In B1 enter "=COUNTIF(A1:A200;"< 0.2")" The number of randomly generated numbers between 0 and 0.2 will be displayed. In my case, there are 43 numbers between 0 and 0.2. So: $proportion=\frac{43}{200}=0.215$
Update this answer!

You can help us out by revising, improving and updating this answer.

Update this answer

After you claim an answer you’ll have 24 hours to send in a draft. An editor will review the submission and either publish your submission or provide feedback.