Sampling Project - Applied Statistical Methods I | STAT 381, Study Guides, Projects, Research of Data Analysis & Statistical Methods

Material Type: Project; Class: Applied Statistical Methods I; Subject: Statistics; University: University of Illinois - Chicago; Term: Fall 2006;

Typology: Study Guides, Projects, Research

Pre 2010

Uploaded on 07/23/2009

koofers-user-x96
koofers-user-x96 🇺🇸

10 documents

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
STAT 381 Sampling Project Due time: 12/01/06
(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
mispayment
μ
= $0.962 and has proportion p = 0.1975 of nonzero mispayment values.
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
1. Calculate the sample mean
x
= __________, the sample standard deviation s = __________
and the proportion = __________ of sample values that are nonzero. (You can use the
=AVERAGE() and =STDEV() functions in Excel, or use the other software to compute the
mean and standard deviation.)
p
2. Calculate the nominal 95% confidence intervals for mean
μ
and proportion p, in each case,
check to see if your interval covers the parameter value. Use t-multiplier for mean
μ
and z-
multiplier for proportion p. Recall that the population values are
μ
= $0.962 and p = 0.1975.
a. Your nominal 95% CI for
μ
is : ___________________________
Does your CI cover
μ
? ________ (Yes / No)
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.
pf2

Partial preview of the text

Download Sampling Project - Applied Statistical Methods I | STAT 381 and more Study Guides, Projects, Research Data Analysis & Statistical Methods in PDF only on Docsity!

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

mispayment μ = $0.962 and has proportion p = 0.1975 of nonzero mispayment values.

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

  1. Calculate the sample mean x = __________, the sample standard deviation s = __________ and the proportion = __________ of sample values that are nonzero. (You can use the =AVERAGE() and =STDEV() functions in Excel, or use the other software to compute the mean and standard deviation.)

p

2. Calculate the nominal 95% confidence intervals for mean μ and proportion p, in each case,

check to see if your interval covers the parameter value. Use t-multiplier for mean μ and z-

multiplier for proportion p. Recall that the population values are μ = $0.962 and p = 0.1975.

a. Your nominal 95% CI for μ is : ___________________________

Does your CI cover μ? ________ (Yes / No)

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