Elementary Statistics (12th Edition)

Published by Pearson
ISBN 10: 0321836960
ISBN 13: 978-0-32183-696-0

Chapter 8 - Hypothesis Testing - 8-2 Basics of Hypothesis Testing - Beyond the Basics - Page 399: 37



Work Step by Step

While the problem could be solved algebraically, the best way to solve this problem is using Microsoft Excel. In order to do this, assign a random number (such as 500) to any cell, and consider this to be cell $n$. As the book recommends, we find the value of $\hat{p}$. To do this, we first must find the standard deviation: $σ=\sqrt{\frac{(0.5)(0.5)}{n}}$ We also know $\hat{p}=zσ+μ$ And $z=\frac{\hat{p}−p}{\sqrt{\frac{-p^2+p}{n}}}$ Doing this, we plug in the known values into the equations, and we plug each equation into excel. Now, we use the Goal Seek command, which can be found by going to Data and then to "What-if-Analysis." Doing this, we find that the value of $n$ so that there is a probability of $80$ percent (found using the necessary value of z from table A-2) is $617$.
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.