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.
Sampling Distribution
Your Name
Subject and Section
Professor’s Name
November 15, 2021
Question 1. Calculate the sample proportion for each sample size.
sample size, n
Number Correctly Scanned
Sample Proportion, p̂
25
24
0.96
50
49
0.98
100
95
0.95
200
193
0.965
QUESTION 2 - Single Proportion Sampling error for each Sample Size
The formula for the determination of SP Sampling Error (SE) is the following:
=SQRT(('p̂'*(1-'p̂'))/'n') CITATION Stand \l 1033 (StatTrek.com, n.d.)
sample size, n
Number Correctly Scanned
Sample Proportion (p̂)
SP Sampling Error (SE)
25
24
0.96
0.03919
50
49
0.98
0.01980
100
95
👀 Other Visitors are Viewing These APA Essay Samples:
-
Impact of Peer Navigation on CCNY Students' Analysis
1 page/≈275 words | No Sources | APA | Mathematics & Economics | Math Problem |
-
Numerical Value of the Sums
2 pages/≈550 words | 2 Sources | APA | Mathematics & Economics | Math Problem |
-
Probability Report Worksheet
2 pages/≈550 words | 3 Sources | APA | Mathematics & Economics | Math Problem |