Question: Probability Distribution Instructions In Excel, create a probability distribution for this scenario Label Column A as % and Column B as p(X] In Column
Probability Distribution Instructions In Excel, create a probability distribution for this scenario Label Column A as "%" and Column B as "p(X] " In Column A, list the numbers 0 to 17. In Column B, use BINOM. DIST. RANGE to calculate the probability for each * value. Highlight the probability cells, then right click and select Format Cells, Format the probability cells as "Numb have Excel show 4 decimal places. Create a probability histogram using the probabilities you calculated. Format and label it properly we sure to "Select Data" button to change the x-axis so it correctly lists the *-values Probability Distribution Questions 6. Copy your finished probability distribution (the table) and paste it below. (Poste your table here ) 7. Copy your finished probability distribution histogram (the chart) and paste Itbelow (Paste your histogram here.) R. What is the shape of your histogram? 9 . How many of Dr. Flynn's patients do we expect to have PPMS? 10. What is the standard deviation for the number of PPMS patients from Dr. Flynn's practice 11. What is the probability that at least 3 patients are found to have PPMS? 12. What is the probability that fewer then 5 have PPMS? 13. What is the probability that between 1 and 5 patients have PPMS (including 1 and 5)? 14. Or. 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 to have PPMS, would this be considered significantly high, and therefore merit hiring = specialist? Explain your answer mathematically
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
