Project #16793 - STATS EXCEL

Please answer the following questions by using excel along with the formula used in solving the problem. Include the excel function you used (which details your command) in your answer YOU CAN PROVIDE SCREENSHOTS SHOWING YOUR INPUTS FOR THE FUNCTION ARGUMENTS. Put all the answers in one document.

1.    As of 2010, 53% of all NYPD police officers were non-white. If we randomly select three NYPD officers, answer the following using excel and print out your answers along with the excel functions you have used.

This is a binomial distribution

a. The probability that all the officers are white.

b. The probability that at least two of the three officers were white.

2.    Two NYPD officers from Pct. 46 are selected to talk to Fordham students about avoiding crime. There are 6 officers who have volunteered for the event. Of these 6, 3 are Fordham alumni.  Answer the following using excel and print out your answers along with the excel functions you have used.

“At most” means cumulative probability – Hyper geometric

a. What is the probability that both officers selected are Fordham alumni?

b. What is the probability that at most 1 is Fordham alum?

3.    The robbery rate for Bronx residents is 4.17 incidents per 1000 residents as of 2012 (Source: http://www.neighborhoodscout.com)

This is a Poisson Distribution

a. Based on the above statistics for the 4000 Fordham university students who live on campus in the Bronx, what is the probability that 2 of them will be robbery victims next year?

 Subject Mathematics Due By (Pacific Time) 11/14/2013 12:00 am
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews