School of Policy, Planning, and Development
PPD 404
Name: ____
Aaron Dan
Instructor: Mark Velez
Email: [email protected]
Email:
[email protected]
Second Excel Assignment
Using the Excel spreadsheet
Nations.xls
, write formulas to produce the following
statistics and answer the questions below. Attach a copy of page 4 in your spreadsheet.
1.
Confidence Limits
In cells AE3 through AE7, enter the following:
Mean=
SD=
Confidence Interval=
LCL=
UCL=
In cell AF3, enter the formula for the mean (average) number of phones per 1,000
population (
PHONES
), and in cell AF4 enter he formula for the standard deviation for
number of phones per 1,000 people. The formulas are:
=average(array)
=stdev(array)
where array is the range of cells containing values for the variables
PHONES
.
Enter the formula for the confidence interval in cell AF5. For a 95 percent confidence
interval, use .05 for the value of alpha. Remember, the number of countries (N) is 24. The
formula is:
=confidence(.05, r3:r26, 24)
Then in cells AF6 and AF7, enter your own formulas for the lower confidence level
(LCL) and the upper confidence level (UCL) by first subtracting the value of the
confidence interval from the value of the mean then by adding the value of the
confidence interval to the mean.
1a.
What is the value of the lower confidence limit (LCL)?
_____263.981
1b.
What is the value of the upper confidence limit (UCL)?
_____469.619
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview.
Sign up
to
access the rest of the document.
 Fall '07
 Velez
 Statistics, Prediction interval, UCL, correlation coefficient df

Click to edit the document details