statistics of life expectancy of men and a table of summary statistics of life expectancy of women in each state and the District of Columbia
1. Using the Question 1 sheet in the Excel workbook, construct a table of summary statistics of life
expectancy of men in each state and the District of Columbia. This would include the mean,
median, mode, and standard deviation. Create a histogram and describe the shape of the data.
2. Using the Question 2 sheet in the Excel workbook, construct a table of summary statistics of life
expectancy of men and a table of summary statistics of life expectancy of women in each state
and the District of Columbia. Create a scatterplot of the relationship between men and women.
Describe the relationship.
3. You are responding to an outbreak of the dreaded T Virus in Raccoon City. It is assumed that
0.1% of the population is currently infected. You have an eye reaction to test for infection which
is 95% accurate and has a false positive rate of 1%. What is the probability that a person with a
positive test result is actually infected?
During the quarantine the virus spreads quickly among the city so that now 10% of the city is
infected. You continue to only let people through that have a negative result. What is the
probability that a person will test negative and actually be infected with the virus?
4. You have a vaccine for the T Virus. It has very strict temperature controls. If it falls below 32
degrees the water will freeze ruining that batch. If the temperature is above 40 degrees the
virus can mutate to an airborne form infecting nearby individuals. Currently The Umbrella
Corporation uses a refrigeration system set for 35 degrees with a standard deviation of 3
degrees. What is the probability that the vaccine will fall below 32 degrees? What is the
probability that the vaccine will rise above 40 degrees?
The cost to dispose of a frozen vaccine is $1000. The cost to secure an area with S.T.A.R.S.
personnel after the virus goes airborne is $50,000. What is the expected cost of transporting the
vaccine? There is a new transportation system that can be set at 35 degrees but has a standard
deviation of 2 degrees. What is the expected loss with that system? How many transportations
would be necessary to justify the cost of $150,000?
5. Using the Question 5 sheet in the Excel workbook, summarize the data. Using a bin size of 1
create a histogram of the data. Explain if this seems to be drawn from a Poisson distribution.
How many do you expect in 15 minutes? How many customers do you expect in an hour?
Using the same data, determine the average time between customers. What is the probability
that you will have at least one customer in the next 5 minutes? What is the probability that you
will not have any customers in the next 15 minutes?
PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂