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 |

Tutor | Rating |
---|---|

pallavi Chat Now! |
out of 1971 reviews More.. |

amosmm Chat Now! |
out of 766 reviews More.. |

PhyzKyd Chat Now! |
out of 1164 reviews More.. |

rajdeep77 Chat Now! |
out of 721 reviews More.. |

sctys Chat Now! |
out of 1600 reviews More.. |

sharadgreen Chat Now! |
out of 770 reviews More.. |

topnotcher Chat Now! |
out of 766 reviews More.. |

XXXIAO Chat Now! |
out of 680 reviews More.. |