Calculating Sample Proportion, Single-Proportion Sampling Error, and Probability

Sampling Distribution
Notes for Writer: Please use Excel Spreadsheet for this assignment.
Instructions: Please use Excel an Excel Spreadsheet for this assignment.
A computer scanner can read a bar code on a package correctly 97% of the time. One company monitors the accuracy of the scanner by randomly sampling packages and verifying that each package has been correctly scanned. Random samples of size n = 25, 50, 100, and 200 have recently been taken with the following results:
Sample Size, n Number Correctly Scanned
25 24
50 49
100 95
200 193
To complete this activity, use Excel to:
1. Calculate the sample proportion for each sample size.
2. Calculate the single-proportion sampling error for each sample size.
3. Calculate the probability of finding 198 correctly scanned packages, for a sample of size n=200.
Submit your work Excel file.