Statistics for Managers Using Microsoft Excel, 3/e
Download
Report
Transcript Statistics for Managers Using Microsoft Excel, 3/e
Statistics for Managers
using Microsoft Excel
3rd Edition
Chapter 6
Confidence Interval Estimation
© 2002 Prentice-Hall, Inc.
Chap 6-1
Chapter Topics
Estimation process
Point estimates
Interval estimates
Confidence interval estimation for the mean
( known)
Determining sample size
Confidence interval estimation for the mean
( unknown)
Confidence interval estimation for the
proportion
© 2002 Prentice-Hall, Inc.
Chap 6-2
Chapter Topics
Applications of confidence interval estimation
in auditing
(continued)
Confidence interval estimation for population total
Confidence interval estimation for total difference
in the population
Estimation and sample size determination for
finite population
Confidence interval estimation and ethical
issues
© 2002 Prentice-Hall, Inc.
Chap 6-3
Estimation Process
Population
Random Sample
Mean, , is
unknown
Mean
X = 50
I am 95%
confident that
is between 40
& 60.
Sample
© 2002 Prentice-Hall, Inc.
Chap 6-4
Point Estimates
Estimate Population
Parameters …
Mean
Proportion
Variance
Difference
© 2002 Prentice-Hall, Inc.
p
with Sample
Statistics
X
PS
1 2
2
S
2
X1 X 2
Chap 6-5
Interval Estimates
Provides range of values
Take into consideration variation in sample
statistics from sample to sample
Based on observation from 1 sample
Give information about closeness to
unknown population parameters
Stated in terms of level of confidence
Never 100% sure
© 2002 Prentice-Hall, Inc.
Chap 6-6
Confidence Interval Estimates
Confidence
Intervals
Mean
Known
© 2002 Prentice-Hall, Inc.
Proportion
Unknown
Chap 6-7
Confidence Interval for
( Known)
Assumptions
Population standard deviation is known
Population is normally distributed
If population is not normal, use large
sample
Confidence interval estimate
X Z / 2
© 2002 Prentice-Hall, Inc.
n
X Z / 2
n
Chap 6-8
Elements of
Confidence Interval Estimation
Level of confidence
Precision (range)
Confidence in which the interval will contain
the unknown population parameter
Closeness to the unknown parameter
Cost
Cost required to obtain a sample of size n
© 2002 Prentice-Hall, Inc.
Chap 6-9
Level of Confidence
Denoted by 100 1 %
A relative frequency interpretation
In the long run, 100 1 % of all the confidence
intervals that can be constructed will contain the
unknown parameter
A specific interval will either contain or not
contain the parameter
No probability involved in a specific interval
© 2002 Prentice-Hall, Inc.
Chap 6-10
Interval and Level of Confidence
Sampling Distribution of the
_ Mean
Z / 2 X
Intervals
extend from
/2
X
1
X
X Z X
X
100 1 %
of intervals
constructed
contain ;
to
X Z X
© 2002 Prentice-Hall, Inc.
Z / 2 X
/2
100 % do
Confidence Intervals
not.
Chap 6-11
Factors Affecting
Interval Width (Precision)
Data variation
Measured by
Sample size
X
Intervals Extend from
X - Z
x
to X + Z
x
n
Level of confidence
100 1 %
© 1984-1994 T/Maker Co.
© 2002 Prentice-Hall, Inc.
Chap 6-12
Determining Sample Size (Cost)
Too Big:
Too small:
• Requires
too much
resources
• Won’t do
the job
© 2002 Prentice-Hall, Inc.
Chap 6-13
Determining Sample
Size for Mean
What sample size is needed to be 90% confident of
being correct within ± 5? A pilot study suggested that
the standard deviation is 45.
1.645 45
Z
n
2
2
Error
5
2
2
2
2
219.2 220
Round Up
© 2002 Prentice-Hall, Inc.
Chap 6-14
Determining Sample
Size for Mean in PHStat
PHStat | sample size | determination for the
mean …
Example in excel spreadsheet
© 2002 Prentice-Hall, Inc.
Chap 6-15
Confidence Interval for
( Unknown)
Assumptions
Population standard deviation is unknown
Population is normally distributed
If population is not normal, use large sample
Use Student’s t Distribution
Confidence Interval Estimate
© 2002 Prentice-Hall, Inc.
X t / 2,n 1
S
S
X t / 2,n1
n
n
Chap 6-16
Student’s t Distribution
Standard
Normal
Bell-Shaped
Symmetric
‘Fatter’
Tails
t (df = 13)
t (df = 5)
0
© 2002 Prentice-Hall, Inc.
Z
t
Chap 6-17
Degrees of Freedom (df )
Number of observations that are free to
vary after sample mean has been calculated
Example
degrees of freedom
Mean of 3 numbers is 2
X 1 1 (or any number)
= n -1
= 3 -1
=2
X 2 2 (or any number)
X 3 3 (cannot vary)
© 2002 Prentice-Hall, Inc.
Chap 6-18
Student’s t Table
Upper Tail Area
df
.25
.10
.05
Let: n = 3
df = n - 1 = 2
= .10
/2 =.05
1 1.000 3.078 6.314
2 0.817 1.886 2.920
/ 2 = .05
3 0.765 1.638 2.353
t Values
© 2002 Prentice-Hall, Inc.
0 2.920
t
Chap 6-19
Example
A random sample of n 25 has X 50 and S 8.
Set up a 95% confidence interval estimate for
S
S
X t / 2,n 1
X t / 2,n 1
n
n
8
8
50 2.0639
50 2.0639
25
25
46.69 53.30
© 2002 Prentice-Hall, Inc.
Chap 6-20
Confidence Interval for
( Unknown) in PHStat
PHStat | confidence interval | estimate for the
mean, sigma unknown
Example in excel spreadsheet
© 2002 Prentice-Hall, Inc.
Chap 6-21
Confidence Interval
Estimate for Proportion
Assumptions
Two categorical outcomes
Population follows binomial distribution
Normal approximation can be used if
np 5 and n 1 p 5
Confidence interval estimate
© 2002 Prentice-Hall, Inc.
pS Z / 2
pS 1 pS
n
p p S Z / 2
pS 1 pS
n
Chap 6-22
Example
A random sample of 400 Voters showed 32
preferred Candidate A. Set up a 95% confidence
interval estimate for p.
ps Z /
ps 1 ps
p ps Z /
n
ps 1 ps
n
.08 1 .08
.08 1 .08
.08 1.96
p .08 1.96
400
400
.053 p .107
© 2002 Prentice-Hall, Inc.
Chap 6-23
Confidence Interval Estimate for
Proportion in PHStat
PHStat | confidence interval | estimate for the
proportion …
Example in excel spreadsheet
© 2002 Prentice-Hall, Inc.
Chap 6-24
Determining Sample Size
for Proportion
Out of a population of 1,000, we randomly
selected 100 of which 30 were defective. What
sample size is needed to be within ± 5% with
90% confidence?
Z p 1 p 1.645 0.3 0.7
n
2
2
Error
0.05
227.3 228
2
© 2002 Prentice-Hall, Inc.
2
Round Up
Chap 6-25
Determining Sample Size for
Proportion in PHStat
PHStat | sample size | determination for the
proportion …
Example in excel spreadsheet
© 2002 Prentice-Hall, Inc.
Chap 6-26
Applications in Auditing
Six advantages of statistical sampling in
auditing
Sample result is objective and defensible
Based on demonstrable statistical principles
Provides sample size estimation in advance on an
objective basis
Provides an estimate of the sampling error
© 2002 Prentice-Hall, Inc.
Chap 6-27
Applications in Auditing
Can provide more accurate conclusions on the
population than the actual investigation of the
population
Samples can be combined and evaluated by
different auditors
Examination of the population can be time
consuming and subject to more nonsampling error
Samples are based on scientific approach
Samples can be treated as if they have been done
by a single auditor
Objective evaluation of the results is possible
© 2002 Prentice-Hall, Inc.
Based on known sampling error
Chap 6-28
Confidence Interval for
Population Total Amount
Point estimate
NX
Confidence interval estimate
© 2002 Prentice-Hall, Inc.
NX N t / 2,n1
S
n
N n
N 1
Chap 6-29
Confidence Interval for
Population Total: Example
An auditor is faced with a
population of 1000 vouchers
and wishes to estimate the
total value of the population
of vouchers. A sample of 50
vouchers is selected with
average voucher amount of
$1076.39, standard deviation
of $273.62. Set up the 95%
confidence interval estimate
of the total amount for the
population of vouchers.
© 2002 Prentice-Hall, Inc.
Chap 6-30
Example Solution
N 1000
n 50
NX N t / 2,n 1
S
n
X $1076.39
S $273.62
N n
N 1
273.62 1000 50
1000 1076.39 1000 2.0096
1000 1
100
1, 076,390 75,830.85
The 95% confidence interval for the population total
amount of the vouchers is between 1,000,559.15, and
1,152,220.85
© 2002 Prentice-Hall, Inc.
Chap 6-31
Example Solution in PHStat
PHStat | confidence intervals | estimate for
the population total
Excel spreadsheet for the voucher example
© 2002 Prentice-Hall, Inc.
Chap 6-32
Confidence Interval for Total
Difference in the Population
Point estimate
n
Where D
difference
ND
D
i 1
i
is the sample average
n
Confidence interval estimate
SD
ND N t / 2,n1
n
n
Where
© 2002 Prentice-Hall, Inc.
SD
N n
N 1
D D
i 1
2
i
n 1
Chap 6-33
Estimation for Finite Population
Samples are selected without replacement
Confidence interval for the mean ( unknown)
X t / 2,n1
S
n
N n
N 1
Confidence interval for proportion
© 2002 Prentice-Hall, Inc.
pS Z / 2
pS 1 pS
n
N n
N 1
Chap 6-34
Sample Size Determination
for Finite Population
Samples are selected without replacement
When estimating the mean
Z / 2
n0
2
e
2
2
When estimating the proportion
Z / 2 p 1 p
n0
2
e
2
© 2002 Prentice-Hall, Inc.
Chap 6-35
Ethical Issues
Confidence interval (reflects sampling error)
should always be reported along with the
point estimate
The level of confidence should always be
reported
The sample size should be reported
An interpretation of the confidence interval
estimate should also be provided
© 2002 Prentice-Hall, Inc.
Chap 6-36
Chapter Summary
Illustrated estimation process
Discussed point estimates
Addressed interval estimates
Discussed confidence interval estimation for the
mean ( known)
Addressed determining sample size
Discussed confidence interval estimation for the
mean ( unknown)
Discussed confidence interval estimation for the
proportion
© 2002 Prentice-Hall, Inc.
Chap 6-37
Chapter Summary
Addressed applications of confidence interval
estimation in auditing
(continued)
Confidence interval estimation for population total
Confidence interval estimation for total difference
in the population
Addressed estimation and sample size
determination for finite population
Addressed confidence interval estimation and
ethical issues
© 2002 Prentice-Hall, Inc.
Chap 6-38