

Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Material Type: Project; Class: Applied Statistical Methods I; Subject: Statistics; University: University of Illinois - Chicago; Term: Fall 2006;
Typology: Study Guides, Projects, Research
1 / 2
This page cannot be seen from the preview
Don't miss anything!


STAT 381 Sampling Project Due time: 12/01/ (15 points) NAME: _______________________________ PID: ____________________
The population of N=800 mispayments is in Column A of the spreadsheet project.xls , which is available on the course web site under Project. If you obtain the spreadsheet from the course web site, save it on your local hard drive (for example, in Internet Explorer you can right click on the link and then choose “Save target as”) and then open it with Excel. The population has mean
Read the attached file (second page) to draw a sample of size 30 from the population.
Observation # 1 2 3 4 5 6 7 8 9 10 Row # Value Observation # 11 12 13 14 15 16 17 18 19 20 Row # Value Observation # 21 22 23 24 25 26 27 28 29 30 Row # Value
p
∧
b. If there are about 600 students doing this project this semester, how many of these students do you expect to answer “Yes” to “Does your CI cover μ”? ____________
c. Your nominal 95% CI for proportion p is : ____________________________.
Does your CI cover p? __________
Note: Submit the first page (answer sheet) only.
How to get random number by using the random table?
Step1: Pick out 30 random numbers from the random table (Table C.10, page 454) in any order you like. For example: the last column (31880, 73043, 61171,), the previous four rows (98083,33185,80951,79752, …), or the inverse diagonal elements ( 73167,06410,53783, …). Make sure you have your own sampling plan. Everyone is supposed to get different random numbers by different sampling plan.
Step2: The population size=800, choose the first three number as the random row number of the Population. For example ( 318 80, 730 43, 611 71,) → ( 318 , 730 , 611 ,) Ignore any number greater than 800.
Step3: Get sample values from the data table by using the real row # in Step2.
Random Number from random table: 318 80 , 730 43, 611 71 … ⇓ ⇓ ⇓ By step 2 get location (row) numbers: 318 , 730, 611 , … ⇓ ⇓ Using Data Table find the values: 0.00, 0.00, …
The other methods to get random number instead of using random table.
a) Every calculator has function to generate a random number between 0 and 1. Then times 800 you'll get random row #.
b) You also can use the function “=FLOOR(RAND()*800+1,1)” in Excel to get random number for row #.
c) Any statistics software has functions taking random values.
Use Excel to take a random sample from the population.
To take a random sample and place the result in Cell B2, and you have the first random number = 616, you would type =INDEX($A$1:$A$800, 616) in Cell B2. (Note: Don’t miss the equal sign“=”.) Then the 616th^ observation in the data table is drawn, and the observed value = 4.03. Put “616” as the first row number and the value “4.03” as the first observed value. Replace 616 with the row numbers based on random numbers you obtained, you can list all 30 values in your random sample.
2