Probability Distribution Instructions In Excel. create a probability distribution for this scenario. Label Column A as "X" and Column B as "POO." In Column A, list the numbers 0 to 17. In Column B. use BINOM.DIST.RANGE to calculate the probability for each x value. Highlight the probability cells. then right click and select Format Cells. Format the probability cells as "Number" and have Excel show 4 decimal places. Create a probability histogram using the probabilities you calculated. Format and label it properly. Be sure to use the "Select Data" button to change the x-axis so it correctly lists the x-values. Probability Distribution Questions 7. Copy your finished probability distribution (the table] and paste it below. {12 pts] ( Paste your table here.) 8. Copy your finished probability distribution histogram (the chart) and paste it below. {12 pts) ( Paste your histogram here.) 9. 10. 11. 12. 13. 14. 15. What is the shape of your histogram? {4 pts] How many of Dr. Flynn's patients do we expect to have PPMS? (4 Ptsl What is the standard deviation for the number of PPMS patients from Dr. Flynn's practice? {4 Ptsl What is the probability that at least 4 patients are found to have PPMS? {4 pts] What is the probability that fewer than 2 have PPMS? {4 pts] What is the probability that between 3 and 7 patients have PPMS? {4 pts] Dr. Flynn is considering referring her PPMS patients to a different practice that specializes in this form of MS. If enough of her patients have PPMS, though. she may bring in a consulting specialist. If 6 of her MS patients are found to have PPMS, would this be considered significantly high. and therefore merit hiring a specialist? Explain your answer mathematically. {6 pts]