(Solved): Consider the following screenshot of an excel that finds 1000 samples and calculates the sample pro ...

Consider the following screenshot of an excel that finds 1000 samples and calculates the sample proportion of ves and the \( z \) tact ctat far aneh. What is the sample proportion and Z test stat for sample 4 for the \( Z \) test stat use the formula Z test stat \( =( \) phat \( -p 0) / \operatorname{sqrt}(p 0 *(1-p 0) / n) \), use \( p 0=0.8 \)