Chapter 7 Lecture Examples
Chapter 7 Lecture Examples
Chapter 7 Lecture Examples
known ")
While there is no direct function in Excel to compute the confidence interval, there is a
function to compute the value of the error (𝑧_(1−𝛼/2) 𝜎/√𝑛) substracted from and a
sample mean 𝑥 ̅.
The error of a (1−𝛼)100% confidence interval for µ (𝜎^2 known) can be obtained using the fol
Excel function:= CONFIDENCE.NORM(𝜶; 𝜎; 𝒏)
Woolworths analysed the value of purchases made on credit cards by a random sample
credit card customers, the mean was found to be R170. It is known that the standard de
credit card purchases is R22.
1) Construct a 95% confidence for the mean value of credit card purchases by all their
customers.
Upper Limit =
=170+CONFIDENCE.NORM(0.05; 22; 25)
2) Construct a 99% confidence for the mean value of credit card purchases by all their
customers.
22; 25)
n= 25
hases by all their credit card 𝑥 ̅= 170
𝜎= 22
α= 0.01
22; 25)
Confidence Intervals for 𝜇 ("when" 𝜎^2 "
unknown ")
There is no direct function in Excel to compute the confidence interval, however th
Excel function to compute the value of the error (𝑡_(𝑛−1; 1−𝛼/2) 𝑆/√𝑛) that can then b
substracted from and added to the sample mean 𝑥 ̅.
2) From a random sample of 100 Cape Town car commuters, the mean time to comm
was found to be 35.8 minutes with a variance of 95. Construct a 90% confidence int
time taken by all car commuters in Cape Town to travel to work daily.
n= 18
imberley found that the mean value of their 𝑥 ̅= 78
. Find a 98% confidence interval for the s = 21
in Kimberley. 𝜶= 0.02
n= 100
, the mean time to commute to work daily 𝑥 ̅= 35.8
ct a 90% confidence interval for the mean 𝒔^𝟐= 95
𝜶= 0.1
ork daily.
RT(95); 100)
RT(95); 100)
RT(95); 100)