Quiz #2
 Data Set: The data you will analyze in this
quiz are the number of people served per doctor and the average female
lifespan in the 40 most populated countries in the world.
This data exists in Excel
Data or Text format.
Analysis: Using
Excel, perform the most appropriate statistical
analysis required to answer the following questions. Print out a copy of
the analysis you do and answer the questions in writing on the
printout that relates to the question.
- What is the mean, median and mode
for the number of people per doctor data in the 40 most populated
countries in the world?
- Can you predict with a high degree
of confidence the lifespan of females in the countries based
on the number of people per doctor? Explain how you
arrived at your conclusion based on the results of the
statistics you performed on the data.
- Generate a histogram of the people
per doctor data. Is the data normally distributed? Explain
how you arrived at your conclusion based on the results of
all of the analysis you performed on the data.
Answer keys are in the
section of DIG Stats
Original
work on this document was done by Central Virginia Governor's School
student Goss Nuzzo-Jones (Class of '01).
Copyright © 2001
Central Virginia
Governor's School for Science and Technology Lynchburg, VA
|